PostgreSQL Database Administrator (Mid-Level)

We are looking for a mid-level PostgreSQL DBA to join our team. You will help manage our database infrastructure operating in a hybrid environment across our on-premise servers and Google Cloud Platform (GCP).

A major upcoming project for our team is migrating our community PostgreSQL databases to EnterpriseDB (EDB) to achieve better high availability. You will play a key role in this migration, specifically focusing on EDB Failover Manager (EFM), as well as ongoing database consolidation efforts to optimize our infrastructure footprint.

This is a full-time and remote position based in the U.K. The target compensation package for this role is between GBP 52,000 and 63,500, subject upon internal equity and years of experience.  We may make further adjustments through an approval process if the targeted compensation range needs to be modified based on business needs and market trends.

We need a self-starter who takes ownership of their work. You should be comfortable assessing the current database landscape, identifying areas for improvement, proposing practical solutions, and seeing them through to completion.

Here are the core functions, responsibilities, and expectations for this role: 

• Manage the full lifecycle of our production PostgreSQL infrastructure, including deployment, architecture, capacity planning, and monitoring.
• Manage high-availability PostgreSQL clusters using tools like Patroni, and drive the upcoming migration from community PostgreSQL to EnterpriseDB (EDB) using EFM.
• Handle system-level and query performance tuning—analyzing execution plans, optimizing indexes, and tuning parameters like shared_buffers, work_mem, autovacuum, etc.
• Manage connection pooling using PgBouncer and configure database security, including user roles, access controls, and pg_hba.conf.
• Execute major and minor version upgrades with minimal downtime and assist in database consolidation projects.
• Manage and test our backup and disaster recovery strategies using tools like Barman, pgBackRest, and shell scripts to ensure reliable point-in-time recovery.
• Configure, monitor, and troubleshoot physical and logical streaming replication, and utilize utilities like pg_rewind to quickly resynchronize nodes after failover events.
• Participate in an on-call rotation to provide operational support for after-hours production emergencies.
• Additional tasks associated with this position may be assigned in response to company initiatives and business needs.