Senior PostgreSQL DBA – Job Description:
Experience: Require a minimum of 10+ years of dedicated, relevant experience in PostgreSQL Database Administration. Must possess a solid, authoritative command over both enterprise Linux (RHEL/OEL) and Windows Server environments, actively managing database hosting layers, file system structures, and platform-specific performance variables across both operating systems.
Backup & Recovery Engineering: Design, implement, and audit automated logical (pg_dump, pg_dumpall) and physical backup strategies (pg_basebackup, pgBackRest, Barman), enforcing strict Point-In-Time Recovery (PITR) workflows via Write-Ahead Log (WAL) archiving to satisfy strict corporate RPO and RTO objectives.
Capacity & Cloud Cost Planning: Handle advanced capacity planning, transaction log growth forecasting, data density mapping, and public cloud financial optimization (right-sizing compute nodes, adjusting Provisioned IOPS/throughput limits, and choosing between serverless and provisioned models).
Deep Health Telemetry: Monitor, baseline,



and troubleshoot cluster health using native analytical extensions (pg_stat_statements, pgstattuple), catalogs (pg_stat_activity, pg_stat_bgwriter), log parsers (pgBadger), and cloud telemetry engines (AWS CloudWatch, Azure Monitor) alongside third-party APM observability suites.
Incident & Lock Management: Diagnose and mitigate active production incidents, including replication lag starvation, connection pool exhaustion, spinlock contentions, query regressions, and complex relational deadlocks or transactional blocking queues via recursive pg_locks analysis.
Security & Compliance Hardening: Implement and enforce rigorous database infrastructure security protocols, utilizing connection-level encryption (SSL/TLS), Row-Level Security (RLS), Column-Level encryption, strict Role-Based Access Controls (RBAC), advanced extension auditing (pgaudit), vulnerability remediation, and corporate compliance architectures (e.g., SOC2,

📌 PostgreSQL DBA (Hyderabad)
🏢 data intensity
📍 Hyderabad