Overview
Job Description: 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 is migrating our community PostgreSQL databases to EnterpriseDB (EDB) to achieve better high availability. You will play a key role in this migration, focusing on EDB Failover Manager (EFM), as well as ongoing database consolidation 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 to internal equity and years of experience.
Note: We are seeking 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 implementing them.
Responsibilities
* 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 migration from community PostgreSQL to EnterpriseDB (EDB) using EFM.
* Handle system-level and query performance tuning—analyzing execution plans, optimizing indexes, and tuning parameters (e.g., shared_buffers, work_mem, autovacuum).
* 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 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; use utilities like pg_rewind to resynchronize nodes after failover events.
* Participate in an on-call rotation to provide operational support for after-hours production emergencies.
* Additional tasks related to company initiatives and business needs may be assigned.
Qualifications
* Education: Bachelor’s degree in information systems, computer science, technology, or a related field is strongly preferred. In lieu of a degree, 2+ years of relevant experience is acceptable.
* Experience: Minimum of 3 to 5+ years of hands-on PostgreSQL administration in production environments (on-prem and cloud).
* Direct experience with EnterpriseDB (EDB) and configuring high availability using EFM.
* Deep understanding of PostgreSQL internals (WAL, MVCC, vacuum, lock management).
* Experience with automated failover and cluster management tools (e.g., Patroni, repmgr).
* Strong SQL performance tuning skills; ability to read EXPLAIN ANALYZE and resolve locking issues.
* Experience managing connection poolers like PgBouncer and upgrading database versions.
* Solid Linux systems administration experience, including filesystem performance and memory management.
* Experience with backups, tested disaster recovery procedures, and handling split-brain replication with tools like pg_rewind.
* Infrastructure-as-code and automation skills (Ansible, Terraform, Git) for repeatable deployments.
* Experience with database observability tools (Prometheus, Grafana, pgWatch, etc.).
* Clear communication skills to explain technical issues to developers and engineering teams.
EEO Information: All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr