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