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 p...