PostgreSQL Database Administrator (Mid-Level)

Sectigo

13h • $52,000 - $63,500 • Remote

About The Position

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:

Requirements

• 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.
• Deep understanding of PostgreSQL internals, including WAL mechanics, MVCC, vacuum processing, and lock management.
• Experience with automated failover and cluster management tools (e.g., Patroni, repmgr).
• Strong SQL performance tuning skills, with the ability to read EXPLAIN ANALYZE outputs and resolve locking contention.
• Practical experience managing connection poolers like PgBouncer and performing database version upgrades.
• Solid Linux systems administration experience, including filesystem performance and memory management.
• Proven experience managing backups, tested disaster recovery procedures, and handling split-brain replication scenarios with tools like pg_rewind.
• Infrastructure-as-code and automation skills (Ansible, Terraform, Git) for repeatable database deployments.
• Experience with database observability tools (Prometheus, Grafana, pgWatch, etc.).
• Clear communication skills to effectively explain technical issues to developers and other engineering teams.

Nice To Haves

• Hands-on experience with GCP and AWS environments.
• Experience with MariaDB or MySQL.
• Previous experience migrating database workloads from on-premise servers to the cloud or consolidating database instances.

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 251-500 employees