The company provides certificate lifecycle management software that issues and manages digital certificates for enterprises.
This is a hands-on PostgreSQL DBA role covering production database services across on-premises systems and GCP.
Much of the work is project-based: moving Community PostgreSQL to EDB Postgres, standardising high availability, consolidating databases and automating operations.
You will work alongside DBAs, SRE, infrastructure, application and security staff to assess the current setup, flag risks, suggest workable fixes and see them through to stable running.
Responsibilities
Look after the whole database lifecycle: install, configure, patch, upgrade, plan capacity, secure, monitor, respond to incidents and retire systems.
Run EDB Failover Manager clusters, watching and fixing them, carrying out planned switchovers and failover tests, checking application connections, and rejoining failed or former primaries safely.
Set up and watch Barman base backups and WAL archiving or streaming, control retention, perform point-in-time recovery, and run documented restore and disaster-recovery tests against agreed RPO and RTO targets.
Add and manage servers and agents in PEM, set useful metrics and alert thresholds, dig into alerts and trends with graphs, and keep notification and escalation links working.
Build repeatable PostgreSQL and EDB environments with TPA and Ansible/Spacelift, and keep playbooks and configuration in Git and GitHub through branches, pull requests and peer review.
Set up and fix physical streaming and logical replication, replication slots, WAL retention, lag and timeline problems, using pgrewind when a node must resync after timelines diverge.
Study execution plans and lock or wait behaviour, tune SQL and indexes, and adjust PostgreSQL and OS settings such as autovacuum, memory, storage, checkpoints and WAL.
Run PgBouncer and manage roles, privileges, authentication, pghba.conf, TLS, secrets and least-privilege access to company standards.
Plan and carry out major and minor upgrades and Community PostgreSQL to EDB migrations and consolidation, with tested rollback and minimal downtime.
Write runbooks and architecture documents, take part in change and incident processes, work with engineering teams, and join the production on-call rotation.
Take on other tasks as company initiatives and business needs arise.
Requirements
Education: a bachelor's degree in information systems, computer science, technology or a related field is strongly preferred.
Education: without a degree, 2+ years of relevant or equivalent experience is accepted.
Experience: 5+ years of hands-on production PostgreSQL administration, covering routine operations and complex troubleshooting.
Hands-on production use of EDB Postgres, EFM, Barman, PEM and TPA, plus PostgreSQL monitoring with Prometheus and Grafana.
Solid grasp of PostgreSQL HA design: streaming replication, failure detection, switchovers, failovers, quorum or witness concepts, split-brain prevention and node rejoin.
Proven work on backup validation, WAL archiving, retention, point-in-time recovery and full restore or disaster-recovery testing.
Deep knowledge of PostgreSQL internals: WAL, MVCC, vacuum and autovacuum, checkpoints, memory, locking and transactions.
Strong SQL tuning: EXPLAIN (ANALYZE, BUFFERS), index design, plan analysis and finding blocking or resource contention.
Solid Linux administration and troubleshooting: CPU, memory, filesystems, storage I/O, systemd, networking and shell scripting.
Strong hands-on Ansible, Git and GitHub: playbooks, inventories, pull requests, peer review, conflict resolution and version-controlled TPA configuration.
Hands-on experience configuring, running and troubleshooting PgBouncer.
Experience with GCP and/or AWS: virtual machines, networking, storage, identity and access management, and cloud monitoring.
Clear written and spoken communication, careful documentation, sound judgment in production and willingness to join an on-call rotation.
Desired qualifications (optional): experience with similar PostgreSQL tools such as Patroni, repmgr, pgBackRest or pgWatch.
Desired qualifications (optional): experience with Terraform, and automation in Bash or Python.
Desired qualifications (optional): past work on large PostgreSQL migrations, major-version upgrades, consolidation, or hybrid on-premises and cloud estates.
Desired qualifications (optional): experience administering MariaDB or MySQL.
Ideal candidate (optional): a practical, accountable DBA who balances uptime and data protection with delivery, investigates carefully, flags risk clearly, automates repeat work, tests recovery instead of assuming it works, and stays calm during incidents.
Conditions
Full-time, remote role based in the U.K.
Target pay is GBP 50,000 to 54,000, depending on internal equity and years of experience.
The range may be changed through an approval process to reflect business needs and market trends.
The company is an equal opportunity employer and may use AI tools in hiring, with human oversight at each stage.
Where you’d work
Fully remote
You can work from
United Kingdom
About the company
S
Sectigo
Industry: Cybersecurity
Also hiring in Ottawa, Canada, Romania and TN, United States