Job Description
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 integ...