PostgreSQL Database Administrator (DBA)

Durapid Technologies Pvt Ltd; Gurugram District; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Durapid Technologies Pvt Ltd in Gurugram is seeking a skilled PostgreSQL Database Administrator (DBA) with 3–4 years of hands-on experience. The role covers database administration, performance optimization, backup and recovery, replication, and production support to ensure high availability in a hybrid environment.

You will monitor performance, tune SQL queries, manage PITR and DR, and collaborate with DevOps and development teams to implement automation and secure access controls.

Qualifications

• 3–4 years of hands-on PostgreSQL DBA experience.
• Strong SQL skills and performance tuning.
• Backup, recovery, PITR and replication expertise.
• HA/DR understanding; production troubleshooting.
• Proficiency in Linux/Unix; cloud exposure (AWS/Azure/GCP).
• Familiarity with automation tools and scripting.

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases across environments.
• Monitor performance, optimize queries, and manage indexes and execution plans.
• Handle backups, PITR, DR, and disaster recovery processes.
• Configure streaming and logical replication.
• Perform tuning and capacity planning; manage incidents.
• Collaborate with DevOps, application, and cloud teams.
• Automate routine tasks with scripting.

Skills

SQL

Query optimization

PostgreSQL

Backup & recovery

PITR

Replication

HA/DR

Linux/Unix

Cloud exposure

Scripting

Tools

Bash

Python

Ansible

Terraform

CI/CD pipelines

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.