PostgreSQL DBA / Database Administrator

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.