At a Glance
- Tasks: Manage PostgreSQL databases and lead exciting migration projects in a hybrid environment.
- Company: Join Sectigo, a leader in digital trust and certificate lifecycle management.
- Benefits: Competitive salary, remote work, and opportunities for professional growth.
- Other info: Inclusive culture with a focus on employee growth and engagement.
- Why this job: Be part of a dynamic team making a real impact in online security.
- Qualifications: 3-5 years of PostgreSQL experience and strong problem-solving skills required.
The predicted salary is between 52000 - 63500 £ per year.
At Sectigo, we align around our mission and pride ourselves in helping thousands of customers sleep better at night. Sectigo is the most innovative provider of certificate lifecycle management (CLM), delivering comprehensive solutions that secure human and machine identities for the world’s largest brands. Sectigo’s automated, cloud-native CLM platform issues and manages digital certificates across all certificate authorities (CAs) to simplify and improve security protocols within the enterprise.
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 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.
Qualifications:
- 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 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.
PostgreSQL Database Administrator (Mid-Level) in Manchester employer: Sectigo
Contact Detail:
Sectigo Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land PostgreSQL Database Administrator (Mid-Level) in Manchester
✨Tip Number 1
Network like a pro! Reach out to current or former employees at Sectigo on LinkedIn. A friendly chat can give you insider info and maybe even a referral, which can really boost your chances.
✨Tip Number 2
Prepare for the interview by brushing up on your PostgreSQL skills. Be ready to discuss your experience with EDB and high availability setups. We want to see how you tackle real-world problems!
✨Tip Number 3
Show off your passion for database management! During interviews, share examples of past projects where you improved performance or handled migrations. It’s all about demonstrating your ownership and problem-solving skills.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our team at Sectigo.
We think you need these skills to ace PostgreSQL Database Administrator (Mid-Level) in Manchester
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the PostgreSQL DBA role. Highlight your experience with PostgreSQL, EDB, and any relevant cloud platforms like GCP. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about database management and how you can contribute to our mission at Sectigo. Keep it concise but impactful – we love a good story!
Show Off Your Technical Skills: Don’t shy away from showcasing your technical expertise. Mention specific tools and technologies you've worked with, like Patroni or PgBouncer. We’re keen on seeing how you’ve tackled challenges in your previous roles.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re serious about joining our team!
How to prepare for a job interview at Sectigo
✨Know Your PostgreSQL Inside Out
Make sure you brush up on your PostgreSQL knowledge, especially around high availability and EDB. Be ready to discuss your experience with tools like Patroni and EFM, as well as your approach to performance tuning and query optimisation.
✨Showcase Your Problem-Solving Skills
Prepare to share specific examples of how you've tackled challenges in previous roles. Whether it's managing backups or handling disaster recovery, having concrete stories will demonstrate your ability to take ownership and drive solutions.
✨Familiarise Yourself with the Company Culture
Sectigo values teamwork, integrity, and growth. Research their core values and think about how your personal values align with theirs. Be ready to discuss how you can contribute to their mission of delivering unparalleled digital trust.
✨Ask Insightful Questions
Prepare thoughtful questions that show your interest in the role and the company. Inquire about their upcoming projects, like the migration to EDB, and how you can play a part in achieving their goals. This shows you're not just interested in the job, but also in being a valuable team member.