PostgreSQL Database Administrator

🔥 9 minutes ago

🇬🇧 United Kingdom – Remote

💵 £50k - £54k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

📀 Database Administrator

👻 Ghost score 0%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Sectigo

WebsiteLinkedInAll Job Openings

201 - 500 employees

🔒 Cybersecurity

☁️ SaaS

Cybersecurity • SaaS • Software

Sectigo is a leading digital certificate provider known for its comprehensive solutions in certificate lifecycle management (CLM) and online security. They offer a wide range of products, including SSL/TLS certificates, S/MIME email security, and code signing services, catering to organizations of all sizes. With a strong focus on automating certificate processes and enhancing digital trust, Sectigo aims to secure both human and machine identities in a rapidly evolving digital landscape.

📋 Description

• Administer the full 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 reintegrate failed or former primary nodes • Configure and monitor Barman base backups and WAL archiving or streaming • Manage backup retention, execute point-in-time recovery, and conduct documented restore and disaster-recovery tests against RPO and RTO targets • Manage PEM servers and agents, configure metrics and alert thresholds, investigate alerts and performance trends, and maintain notification and escalation integrations • Build repeatable PostgreSQL/EDB environments using TPA and Ansible/Spacelift • 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 to resynchronize nodes after timeline divergence when appropriate • Analyze execution plans and wait or lock behavior, tune SQL and indexes, and optimize PostgreSQL and operating-system settings • Operate PgBouncer and manage roles, privileges, authentication, pg_hba.conf, TLS, secrets, and least-privilege access • Plan and execute version upgrades, Community PostgreSQL-to-EDB migrations, and database consolidation with rollback validation, testing, and minimal downtime • Create runbooks and architecture documentation • Participate in change and incident processes and collaborate with DBAs, SRE, infrastructure, application, and security teams • Join an on-call rotation for production emergencies

🎯 Requirements

• Bachelor's degree in information systems, computer science, technology, or a related field is strongly preferred • In lieu of degree, 2+ years of relevant and/or equivalent experience is acceptable • Minimum of 5+ years of hands-on PostgreSQL administration in production environments is required • Hands-on production experience with EDB Postgres, EFM, Barman, PEM, and TPA • PostgreSQL monitoring using Prometheus and Grafana • Strong understanding of PostgreSQL HA design, streaming replication, failure detection, switchovers, failovers, quorum or witness concepts, split-brain prevention, and node rejoin procedures • 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 • Experience with Patroni, repmgr, pgBackRest, or pgWatch is desired • Experience with Terraform and automation using Bash or Python is desired • Experience with large PostgreSQL migrations, major-version upgrades, database consolidation, or hybrid on-premises/cloud environments is desired • Experience administering MariaDB or MySQL is desired

🏖️ Benefits

• Remote work • Equal opportunity and inclusive workplace • Opportunities for career growth and internal promotion • On-call rotation participation for production emergencies

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume