PostgreSQL Database Administrator

Sectigo is the most innovative provider of certificate lifecycle management (CLM), delivering solutions that help the world’s largest brands simplify how digital trust is managed and scaled. Sectigo’s automated, cloud-native CLM platform issues and manages digital certificates across enterprise environments, enabling organizations to reduce complexity, accelerate time to value, and strengthen security across environments. Sectigo is one of the largest, longest-standing, and most reputable CAs with more than 700,000 customers, including 65% of the Fortune 500.

Sectigo holds six combined active leadership seats in the CA/Browser Forum and ETSI and brings two decades of delivering unparalleled digital trust.
Simplicity at Scale. How we show up with each other and our customers every day is just as important, and we win as #One Sectigo by living out our core values
-Support,Excellence,Communication,Teamwork,Integrity,Growthand Openness. We are committed to investing in our diverse teams where everyone understands their role and how they support our strategic goals, we drive operational excellence through scale and efficiency, and we strive to delight our customers and become the market leader in our industry. If you aspire to join a driven team that holds each other accountable to meeting our lofty goals and you’d like to be part of our growth story in delivering a market leading user experience, we’d like to talk to you.

We are looking for a hands-on PostgreSQL DBA to help manage database services across our on-premises infrastructure and GCP. The role combines production operations with project work, including migration from Community PostgreSQL to EDB Postgres, high-availability standardization, database consolidation, and operational automation.

You will work closely with DBAs, SRE,infrastructure,application, and security teams. We need someone who can assess the current environment,identify risks and improvements, recommend practical solutions, and follow them through tostable production operations.

Here are the core functions, responsibilities, and expectations for this role:

• PostgreSQL and EDB administration.
  
  Administer the full database lifecycle, including installation, configuration, patching, upgrades, capacity planning, security, monitoring, incident response, and decommissioning.
• High availability with EFM.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.
• Backup and recovery with Barman.
  
  Configure andmonitorbase 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.
• Monitoring and alerting with PEM.Register and manage servers and agents, configure meaningful metrics and alert thresholds, investigate alerts and performance trends using graphs, andmaintainnotification and escalation integrations.
• Automation and version control.
  
  Use TPA and Ansible/Spaceliftto build repeatable PostgreSQL/EDB environments andmaintainplaybooks and configuration in Git and Git Hub using branches, pull requests, and peer review.
• Replication and recovery.
  
  Configure and troubleshoot physical streaming and logical replication, replication slots, WAL retention, lag, and timeline issues; iate to resynchronize a node after timelines diverge.
• Performance engineering.
  
  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.
• Connectivity and security.
  
  Operate Pg Bounce rand  manage roles, privileges, authentication,.conf, TLS, secrets, and least-privilege access in line with organizational standards.
• Migration sand consolidation.
  
  Plan and execute major and minor version upgrades, Community PostgreSQL-to-EDB migrations, and database consolidation with validated rollback, testing, and minimal downtime.
• Operational ownership.
  
  Create runbooks and architecture documentation,participate in change and incident processes, collaborate with engineering teams, and join an on-call rotation for production emergencies.
• Additional tasks associated with this position may be assigned in response to company initiatives and business needs.

More information about this role:

This is a full-time and remote position based in the U.K. The target…