PostgreSQL Database Administrator

Sectigo

1d • Remote

About The Position

Sectigo is seeking a hands-on PostgreSQL Database Administrator to manage database services across on-premises infrastructure and GCP. The position combines production operations with project work, including migration from Community PostgreSQL to EDB Postgres, high-availability standardization, database consolidation, and operational automation. The DBA will work closely with DBAs, SRE, infrastructure, application, and security teams to assess the environment, identify risks and improvements, recommend practical solutions, and deliver stable production operations.

The role covers the full database lifecycle, high availability with EDB Failover Manager, backup and recovery with Barman, monitoring with PEM, replication and recovery, performance engineering, connectivity and security, and migrations. It also includes building repeatable environments using TPA and Ansible/Spacelift, maintaining configuration in Git and GitHub, documenting runbooks and architecture, participating in change and incident processes, collaborating with engineering teams, and joining an on-call rotation for production emergencies. Additional tasks may be assigned based on company initiatives and business needs.

This is a full-time, remote position based in the U.K. The target compensation package is GBP 50,000–54,000, subject to internal equity and years of experience; adjustments may be considered through an approval process based on business needs and market trends.

Requirements

• At least 5 years of hands-on PostgreSQL administration in production environments, including routine operations and complex troubleshooting.
• Hands-on production experience with EDB Postgres, EFM, Barman, PEM, and TPA, as well as PostgreSQL monitoring with Prometheus and Grafana.
• Strong understanding of PostgreSQL high-availability design, streaming replication, failure detection, switchovers, failovers, quorum or witness concepts, split-brain prevention, and node rejoin procedures.
• Demonstrated experience with backup validation, WAL archiving, retention management, point-in-time recovery, and full restore or disaster-recovery testing.
• Strong knowledge of PostgreSQL internals, including WAL, MVCC, vacuum and autovacuum, checkpoints, memory management, locking, and transaction behavior.
• Strong SQL performance-tuning skills, including EXPLAIN (ANALYZE, BUFFERS), index design, query-plan analysis, and diagnosis of blocking or resource contention.
• Solid Linux administration and troubleshooting skills, including CPU, memory, filesystem, storage I/O, systemd services, networking, and shell scripting.
• Strong hands-on experience with Ansible, Git, and GitHub, including playbooks, inventories, pull requests, peer review, conflict resolution, and version-controlled TPA configuration.
• Hands-on experience configuring, administering, and troubleshooting PgBouncer.
• Experience with GCP and/or AWS, including virtual machines, networking, storage, identity and access management, and cloud monitoring.
• Clear written and verbal communication, disciplined documentation, sound production judgment, and willingness to participate in an on-call rotation.
• A bachelor's degree in information systems, computer science, technology, or a related field is strongly preferred. In lieu of a degree, 2 or more years of relevant and/or equivalent experience is acceptable.

Nice To Haves

• Experience with comparable PostgreSQL tools such as Patroni, repmgr, pgBackRest, or pgWatch.
• Experience with Terraform and automation using Bash or Python.
• Previous involvement in large PostgreSQL migrations, major-version upgrades, database consolidation, or hybrid on-premises/cloud environments.
• Experience administering MariaDB or MySQL.
• A practical and accountable approach to balancing availability and data protection with delivery needs, investigating carefully, communicating risk clearly, automating repeatable work, testing recovery procedures, and remaining calm during production incidents.

Responsibilities

• Administer the PostgreSQL and EDB database lifecycle, including installation, configuration, patching, upgrades, capacity planning, security, monitoring, incident response, and decommissioning.
• Configure, operate, monitor, and troubleshoot EDB Failover Manager clusters; perform planned switchovers and failover tests, validate application connectivity, and safely reintegrate failed or former primary nodes.
• Configure and monitor Barman base backups and WAL archiving or streaming, manage retention, execute point-in-time recovery, and conduct documented restore and disaster-recovery tests against agreed RPO and RTO targets.
• Register and manage servers and agents in PEM, configure metrics and alert thresholds, investigate alerts and performance trends, and maintain notification and escalation integrations.
• Use TPA and Ansible/Spacelift to build repeatable PostgreSQL/EDB environments and maintain playbooks and configuration in Git and GitHub using branches, pull requests, and peer review.
• Configure and troubleshoot physical streaming and logical replication, replication slots, WAL retention, lag, and timeline issues; use pg_rewind when appropriate to resynchronize nodes after timeline divergence.
• Analyze execution plans and wait or lock behavior, tune SQL and indexes, and optimize PostgreSQL and operating-system settings, including autovacuum, memory, storage, and checkpoint or WAL behavior.
• Operate PgBouncer and manage database roles, privileges, authentication, pg_hba.conf, TLS, secrets, and least-privilege access in accordance with organizational standards.
• Plan and execute major and minor version upgrades, Community PostgreSQL-to-EDB migrations, and database consolidation with validated rollback, testing, and minimal downtime.
• Create runbooks and architecture documentation, participate in change and incident processes, collaborate with engineering teams, and join an on-call rotation for production emergencies.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level