Senior PostgreSQL Database Administrator

Duties and Responsibilities
Lead 24x7 monitoring and proactive management of PostgreSQL production, staging, and development environments.
Perform advanced performance tuning at query, schema, and system levels — identify slow queries, analyze execution plans, and implement effective optimization strategies.
Manage PostgreSQL partitioning strategies (range, list, hash) for handling large data volumes and improving query performance.
Implement and maintain robust backup and disaster recovery strategies including pg_basebackup, pgBackRest, barman, and Point-In-Time Recovery (PITR).
Architect and administer streaming replication, logical replication, and failover mechanisms for high availability and business continuity.
Plan and execute PostgreSQL upgrades and data center migrations, ensuring minimal downtime and data integrity.
Deep dive into PostgreSQL internals — WAL, shared buffers, background processes, autovacuum internals, and query executor/optimizer behavior — to diagnose and resolve performance bottlenecks.




Design and implement monitoring and alerting frameworks using tools like pg_stat_statements, pgMonitor, Prometheus, or custom scripts.
Perform root-cause analysis (RCA) of incidents and provide detailed performance diagnostics reports.
Review and optimize database memory and I/O parameters (shared_buffers, work_mem, effective_cache_size, checkpoint tuning, autovacuum tuning, etc.).
Manage and audit user roles, security policies, and ensure databases are aligned with enterprise security standards.
Coordinate with application, infrastructure, and Development teams to design scalable, fault-tolerant PostgreSQL architectures.
Evaluate and recommend recent PostgreSQL extensions and open-source tools to enhance database reliability and observability.
Maintain comprehensive documentation for operational procedures, performance baselines, backup/recovery workflows, and failover protocols.

Skills and Experience Required

4+ y

📌 Senior Database Administrator (Bengaluru)
🏢 BCITS
📍 Bengaluru