Sr PostgreSQL DBA

Role: Sr PostgreSQL Database Administrator (DBA)Location: Hyderabad, IndiaJob descriptionWe 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 environmentsPerform and manage logical and physical backups, restores, and recovery strategiesExecute database upgrades (minor and major versions) with minimal downtimeDesign 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 bottlenecksTune and manage PostgreSQL configuration parameters and leverage system catalogs for deep analysisPerform routine maintenance tasks such as vacuuming, indexing, and database housekeepingDeploy and manage PostgreSQL in cloud environments like AWS (RDS/EC2) or AzureImplement and maintain high availability (HA) solutions using tools like Repmgr, Pgpool, or EFMManage and optimize multi-terabyte databases ensuring performance and scalabilityMonitor database health and implement proactive measures to prevent outagesCollaborate with engineering, DevOps, and product teams to support application performanceDocument processes, configurations, and recovery proceduresRequirements: Strong knowledge of PostgreSQL architecture and internalsHands-on experience with backup/restore strategies, replication, and disaster recoveryProven experience in performance tuning and troubleshooting production issuesExperience managing large-scale (multi-TB) PostgreSQL databasesSolid understanding of PostgreSQL system catalogs and configuration tuningExperience 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 skillsAbility to work independently and quickly learn new technologiesExperience supporting high-volume, mission-critical production environmentsStrong communication and collaboration skills across cross-functional teams