PostgreSQL Database Administrator (DBA)

Durapid Technologies Private Limited; Gurugram District; Hybrid; INR 1,200,000 - 2,300,000; Full time

Job summary

Durapid Technologies Private Limited is seeking a skilled PostgreSQL Database Administrator (DBA) with 3–4 years of hands-on experience. The role focuses on database administration, performance optimization, backup and recovery, replication, and production support in a hybrid Gurgaon environment.

The ideal candidate will troubleshoot production issues, optimize queries, manage backups, and collaborate with cross-functional teams including infrastructure, cloud, and DevOps.

Qualifications

• 3–4 years of hands-on PostgreSQL database administration experience.
• Strong SQL, query optimization, indexing, and execution plans knowledge.
• Experience with backup, recovery, PITR and replication.
• Understanding of HA (High Availability) and DR (Disaster Recovery).
• Production troubleshooting and performance monitoring skills.
• Good knowledge of Linux/Unix environments.
• Exposure to AWS, Azure, or GCP cloud platforms.
• Familiarity with CI/CD pipelines and infrastructure automation.
• Experience with Bash, Python, Ansible, Terraform, or similar tools.

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases across development, staging, and production environments.
• Monitor performance, troubleshoot issues, and optimize SQL queries, indexes, and execution plans.
• Manage backups, recovery, PITR, and disaster recovery processes.
• Configure and maintain PostgreSQL Streaming and Logical Replication.
• Perform performance tuning, VACUUM, ANALYZE, and capacity planning.
• Handle production incidents and BTB/RTB activities.
• Implement database security, roles, permissions, access controls, and auditing.
• Support migrations, version upgrades, patching, and environment refresh.
• Automate routine admin tasks using scripting and automation tools.
• Collaborate with application development, infrastructure, cloud, and DevOps teams.

Skills

PostgreSQL DBA

SQL optimization

Backup recovery

PITR

HA/DR

Production troubleshooting

Linux/Unix

Cloud: AWS/Azure/GCP

CI/CD automation

Scripting: Bash/Python

Ansible/Terraform

Job description

Job Title:

PostgreSQL Database Administrator (DBA)

Location:

Gurgaon (Hybrid)

Experience:

3–4 Years

Notice Period:

Immediate to 7 Days

Employment Type:

Full-Time

Job Summary

We are looking for a skilled PostgreSQL Database Administrator (DBA) with 3–4 years of hands‑on experience in database administration, performance optimization, backup and recovery, replication, and production support. The ideal candidate should have strong troubleshooting skills and experience managing PostgreSQL databases in production environments.

Key Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases across development, staging, and production environments.
• Monitor database performance, troubleshoot issues, and optimize SQL queries, indexes, and execution plans.
• Manage database backups, recovery, Point-in-Time Recovery (PITR), and disaster recovery processes.
• Configure and maintain PostgreSQL Streaming and Logical Replication.
• Perform database performance tuning, VACUUM, ANALYZE, and capacity planning.
• Handle production incidents, RTB (Run the Business), and BTB (Build the Business) activities.
• Implement database security, user roles, permissions, access controls, and auditing.
• Support database migrations, version upgrades, patching, and environment refresh activities.
• Automate routine database administration tasks using scripting and automation tools.
• Collaborate with application development, infrastructure, cloud, and DevOps teams.

Required Skills & Qualifications

• 3–4 years of hands-on PostgreSQL database administration experience.
• Strong knowledge of SQL, query optimization, indexing, and execution plans.
• Experience with PostgreSQL backup, recovery, PITR, and replication.
• Understanding of High Availability (HA) and Disaster Recovery (DR).
• Strong experience in production database troubleshooting and performance monitoring.
• Good knowledge of Linux/Unix environments.
• Exposure to AWS, Azure, or GCP.
• Familiarity with CI/CD pipelines and infrastructure automation.
• Experience with Bash, Python, Ansible, Terraform, or similar tools.

Good To Have

• Experience managing large-scale PostgreSQL databases.
• Exposure to MongoDB administration.
• Knowledge of Oracle or MySQL.
• Experience with database monitoring and observability tools.

Joining Preference:

Immediate joiners or candidates available within 7 days.

Skills: database performance tuning,communication skills,linux,sql,database backup and recovery,database replication,database administration,aws / azure / gcp,postgresql