Advanced PostgreSQL Systems 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 upgr...