Senior Database Administrator

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