About the Role

We are looking for an experienced PostgreSQL Database Administrator to own the operational reliability, availability, and resilience of our PostgreSQL setting. This role is responsible for managing database migrations, designing and maintaining High Availability (HA) architectures, and implementing Disaster Recovery (DR) strategies across data centers. You will be the go-to expert ensuring our PostgreSQL infrastructure is robust, performant, and production-ready at scale.

Key Responsibilities
- Plan, test, and execute schema and data migrations with minimal downtime (including zero downtime migration strategies for large production databases).
- Design, implement, and maintain High Availability (HA) architectures using tools such as Patroni, repmgr, pg_auto_failover, or similar.
- Design and manage Disaster Recovery (DR) setups, including cross-datacenter (DC-DR) replication, failover, and failback procedures. Configure and manage streaming replication, logical replication, and physical backups (pg_basebackup, WAL-G, pgBackRest, Barman).




- Define and regularly test RPO/RTO objectives; run DR drills and failover simulations.
- Own backup and restore strategy, ensuring backups are reliable, encrypted, and regularly validated through restore testing. Monitor database health, performance, and capacity; proactively tune configuration (postgresql.conf, autovacuum, memory settings, connection pooling).
- Manage connection pooling infrastructure (PgBouncer/Pgpool-II) for scalability and stability. Implement and enforce security best practices: role-based access control, encryption at rest/in transit, auditing, and compliance requirements. Collaborate with engineering teams on schema design reviews, query optimization, and capacity planning.
- Build and maintain runbooks, playbooks, and automation (Ansible/Terraform/scripts) for routine operations, failover, and recovery procedures. Participate in on-call rotation to respond to incidents, outages, and

📌 PostgreSQL Database Administrator (New Delhi)
🏢 IntelliDB Enterprise
📍 New Delhi