Role: Sr PostgreSQL Database Administrator (DBA)
Location: Hyderabad, India
Job Description
We are looking for a highly capable PostgreSQL DBA who can take complete ownership of database operations in a high-volume, mission-critical environment. This role requires deep expertise in PostgreSQL internals, strong troubleshooting ability, and hands-on experience managing large-scale databases in cloud environments like AWS or Azure.
Responsibilities
- Manage and maintain PostgreSQL databases across production, staging, and development environments
- Perform and manage logical and physical backups, restores, and recovery strategies
- Execute database upgrades (minor and major versions) with minimal downtime
- Design and manage replication setups, including streaming replication and point-in-time recovery (PITR)
- Troubleshoot performance issues including locks, blocking, long-running queries, and system load bottlenecks
- Tune and manage PostgreSQL configuration parameters and leverage system catalogs for deep analysis
- Perform routine maintenance tasks such as vacuuming, indexing, and database housekeeping
- Deploy and manage PostgreSQL in cloud environments like AWS (RDS/EC2) or Azure
- Implement and maintain high availability (HA) solutions using tools like Repmgr, Pgpool, or EFM
- Manage and optimize multi-terabyte databases ensuring performance and scalability
- Monitor database health and implement proactive measures to prevent outages
- Collaborate with engineering, DevOps, and product teams to support application performance
- Document processes, configurations, and recovery procedures
Requirements
- Strong knowledge of PostgreSQL architecture and internals
- Hands-on experience with backup/restore strategies, replication, and disaster recovery
- Proven experience in performance tuning and troubleshooting production issues
- Experience managing large-scale (multi-TB) PostgreSQL databases
- Solid understanding of PostgreSQL system catalogs and configuration tuning
- Experience with cloud-based PostgreSQL deployments (AWS or Azure)
- Hands-on experience with high availability and clustering tools (Repmgr / Pgpool / EFM)
- Strong Linux/Unix administration and scripting skills
- Ability to work independently and quickly learn new technologies
- Experience supporting high-volume, mission-critical production environments
- Strong communication and collaboration skills across cross-functional teams
Skills:- PostgreSQL, Amazon Web Services (AWS) and Linux/Unix
