PostgreSQL Database Administrator (Mid-Level)

Responsibilities:

• Manage the full lifecycle of our production PostgreSQL infrastructure, including deployment, architecture, capacity planning, and monitoring.
• Handle system-level and query performance tuning and manage connection pooling using PgBouncer.
• Execute major and minor version upgrades with minimal downtime and assist in database consolidation projects.

Qualifications:

• Minimum of 3 to 5+ years of hands-on experience administering PostgreSQL in production environments (both on-prem and cloud).
• Direct experience with EnterpriseDB (EDB) and configuring high availability using EFM.
• Strong SQL performance tuning skills, with the ability to read EXPLAIN ANALYZE outputs and resolve locking contention.