Senior PostgreSQL Database Administrator (High Availability & DR Specialist) | Imeediate Joiner

We are seeking an experienced PostgreSQL Database Administrator (DBA) to design, implement, and manage PostgreSQL environments for UAT, Production, and Disaster Recovery (DR). The ideal candidate will have strong expertise in High Availability (HA), replication, backup & recovery, security, monitoring, and disaster recovery strategies. The role also involves creating Standard Operating Procedures (SOPs), comprehensive documentation, and knowledge transfer to internal teams.

Key Responsibilities

1. Database Design & Implementation

Architect and implement PostgreSQL database environments for

UAT, Production, and DR .

Ensure optimal performance, scalability, and reliability of database instances.

Configure database parameters, schemas, and storage as per project requirements.

2. High Availability & Disaster Recovery

Set up

High Availability (HA)

configuration with

manual failover .

Implement

Disaster Recovery (DR)

setup with replication.

Conduct periodic DR drills to validate recovery procedures and failover readiness.

3. Backup & Recovery Strategy

Develop and implement a

robust backup strategy

(physical / logical backups).

Configure automated backup scheduling and retention policies.

Test and validate recovery processes to ensure data integrity and minimal downtime.

4. Security, Monitoring & Auditing

Implement

role-based access control , database encryption, and secure authentication methods.

Set up

monitoring tools

for performance, replication lag, and availability tracking.

Configure

auditing mechanisms

to meet compliance and regulatory requirements.

5. Documentation & Knowledge Transfer

Prepare comprehensive

documentation

of PostgreSQL configurations, procedures, and maintenance tasks.

Develop

Standard Operating Procedures (SOPs)

for operational use.

Conduct

training sessions

and handover knowledge to the operations / support team.

Required Skills & Qualifications

Education :

Bachelor’s degree in Computer Science, Information Technology, or related field.

Experience :

5+ years of PostgreSQL DBA experience, with proven expertise in HA, replication, and DR.

Technical Expertise :

PostgreSQL installation, configuration, and optimization.

HA setup using tools like

Patroni, repmgr, pgPool-II, or similar .

DR replication strategies (streaming replication, logical replication).

Backup tools ( pgBackRest, Barman, or custom scripts ).

Security hardening, SSL / TLS encryption, and role-based access control.

Monitoring tools ( pgAdmin, Prometheus, Grafana, or equivalent ).

Soft Skills :

Strong documentation skills, team collaboration, and ability to train technical staff.