Sectigo

Sectigo

PostgreSQL Database Administrator (Mid-Level)

Company

Sectigo

Role

PostgreSQL Database Administrator (Mid-Level)

Job type

Full-time

Posted

Yesterday

Share this job

Salary

Not disclosed by employer

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

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

Education:

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

Experience:

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

Ideal Candidate Profiles, Talents, and Desired Qualifications:

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

All your information will be kept confidential according to EEO guidelines.

Global team. Global reach. Global impact.

At Sectigo, we believe doing good is good business. Our strength and our success come from our team of passionate, engaged individuals who make a difference, both locally and globally. Our commitment to engagement is rooted in an unconditionally inclusive workforce, embodying our unique perspectives, heritages, and backgrounds, all as diverse as the experiences of each Sectigo employee. Importantly, we strive to be recognized not only as the CLM leader but also for our intentional efforts to promote employees into the roles that most challenge and excite them, into experiences that allow them to grow their interests as we grow the business. We are committed to bringing a little bit of fun and a whole lot of happiness into everything we do so that our work – and our team members – reflect the positive outcomes we deliver to our customers every day.  

Resume ExampleCover Letter Example

Explore more