PostgreSQL DBA / Database Administrator

Tata Consultancy Services; Hyderabad, Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Tata Consultancy Services is seeking an experienced PostgreSQL Database Administrator (DBA) to manage and optimize PostgreSQL environments across on-premises and cloud platforms in Hyderabad, Bangalore, or PAN India.

You will focus on performance tuning, backup and recovery, security, and automation with Bash or Python, collaborating with development and data teams to ensure high availability and smooth migrations to cloud services such as AWS or Azure.

Qualifications

• 6–12 years of PostgreSQL DBA experience.
• Experience with on‑prem and cloud environments.
• Strong performance tuning and SQL optimization.
• Backup, recovery, and DR strategies.
• RBAC and security management.
• Automation via Bash or Python.
• Cloud migration projects experience.
• Troubleshooting and issue resolution.

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases across on-premises and cloud environments.
• Monitor database performance and optimize SQL queries.
• Implement backup, recovery, and disaster recovery strategies.
• Manage database security, user authentication, authorization, and RBAC.
• Develop automation scripts using Bash or Python for database administration tasks.
• Plan and execute database migration projects from on-premises to cloud platforms.
• Collaborate with development, data migration, and application teams to support database activities.
• Troubleshoot database issues and ensure optimal system performance.

Skills

PostgreSQL DBA

SQL

Performance tuning

Backup & recovery

RBAC

Bash/Python scripting

Cloud migration

Troubleshooting

Tools

AWS RDS/EC2

Azure DB services

Job description

Role & responsibilities

PostgreSQL DBA

Experience: 6-12 Years
Location: Hyderabad / Bangalore / PAN India

Job Description

We are looking for an experienced PostgreSQL Database Administrator (DBA) to manage, maintain, and optimize PostgreSQL database environments. The ideal candidate should have strong expertise in database administration, performance tuning, backup and recovery, security management, and cloud migration initiatives.

Key Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases across on-premises and cloud environments.
• Monitor database performance and optimize SQL queries to ensure high availability and reliability.
• Implement and manage backup, recovery, and disaster recovery strategies.
• Manage database security, user authentication, authorization, and Role-Based Access Control (RBAC).
• Develop automation scripts using Bash or Python for database administration tasks.
• Plan and execute database migration projects from legacy platforms and on-premises environments to cloud platforms.
• Collaborate with development, data migration, and application teams to support database-related activities.
• Troubleshoot database issues and ensure optimal system performance.

Required Skills

• Strong experience in PostgreSQL Database Administration.
• Expertise in SQL, database architecture, memory management, and storage concepts.
• Experience with PostgreSQL performance tuning and query optimization.
• Hands-on experience with backup, recovery, replication, and high-availability solutions.
• Knowledge of AWS (RDS/EC2) and/or Azure database services.
• Experience in database migration and cloud adoption projects.
• Proficiency in Bash/Python scripting for automation.
• Strong troubleshooting and problem-solving skills.

Preferred

• PostgreSQL DBA Certifications (CPSDBA or equivalent).
• Experience working in large enterprise database environments.
• Exposure to cloud-native database architectures and modernization initiatives.