Senior Postgresql Database Administrator

THG; Manchester; On-site; GBP 45,000 - 75,000

Job description

About THG

We're a fast-moving, global technology group that specialises in taking brands direct to consumers. We're home to a portfolio of leading brands and sites including Myprotein, ESPA, LOOKFANTASTIC, and Cult Beauty, all of which are powered by our fully integrated digital commerce ecosystem, THG Ingenuity.

We handle everything in-house, including technology, content creation, e-commerce, marketing, manufacturing, new product development, and logistics. This comprehensive approach ensures we can fully realise our vision and maintain our leadership in a rapidly evolving global industry.

Join THG Ingenuity and Shape the Future of Database as a Service!

At THG Ingenuity, we are entering a game-changing phase in our database evolution. We are launching a cutting-edge Database as a Service (DBaaS) platform, powered by PostgreSQL at its core, to drive scalability, efficiency, and innovation across our global operations.

To lead this transformation, we are looking for an experienced and passionate Senior PostgreSQL Database Administrator (DBA) to join our team.

Why Join Us?

• Be at the forefront of database innovation, shaping a high-performance DBaaS platform.
• Work with modern technologies, including PostgreSQL, Kubernetes (K8s), and cloud-native architectures.
• Collaborate with top-tier engineers and database experts in a dynamic and fast-paced environment.
• Influence database strategy, performance tuning, and security at scale.

Responsibilities

• Design, deploy, and maintain highly available PostgreSQL database clusters.
• Implement and manage replication, clustering, and failover mechanisms.
• Monitor database performance, apply optimizations, and manage upgrades.
• Plan and execute database migrations as part of major version upgrades.
• Develop and maintain robust backup and recovery procedures.
• Ensure database security, integrity, and availability through best practices.
• Optimize query performance and database tuning.
• Collaborate with development teams to design and optimize database schemas.
• Utilise Kubernetes (K8s) for container orchestration and management of database services.
• Manage and integrate PostgreSQL clustering technologies (e.g., Patroni, Consul, etcd).
• Troubleshoot and resolve database-related issues efficiently.
• Maintain comprehensive documentation on database configurations, procedures, and best practices.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5+ years of hands-on experience as a PostgreSQL DBA in production environments.
• Strong expertise of PostgreSQL architecture, performance tuning, and query optimization.
• Experience with database backup, recovery, and security best practices.
• Proficiency in SQL and PL/pgSQL.
• Hands-on experience with Kubernetes (K8s) for container orchestration.
• Experience with Patroni for PostgreSQL high availability and failover management.
• Excellent problem-solving skills and keen attention to detail.
• Strong communication and collaboration skills.

Preferred skills:

• Experience with automation tools (e.g., Ansible, Terraform).
• Knowledge of other database systems (e.g., SQL Server, Couchbase, MySQL).
• Familiarity with CI/CD pipelines and DevOps practices.
• Experience with Consul for service discovery and configuration.
• Knowledge of cloud platforms (e.g., AWS, Azure, GCP).
• Experience in deploying and managing multi-region or multi-data centre database clusters.

What's in it for me?

Career Development

• Access bespoke development programmes that have been designed and developed by our in-house L&D team.
• Continued development through our upskilling programme that is delivered in partnership with an industry-leading training provider.

Enhanced Leave

• 25 days annual leave plus bank holidays.
• Don't want to work on your birthday? We don't either! Enjoy your day off on us!
• Enhanced maternity and paternity pay, depending on length of service.
• Up to 10 days compassionate leave.
• Buy back up to 3 days each year.
• Unlock 2 days volunteer leave after 12-months.

Wellbeing Support

• Access face-to-face and virtual appointments with our in-house GP.
• Access our in-house CBT therapist.
• Access our 247 Employee Assistance Programme (EAP) which is provided by Bupa.
• State-of-the-art on-site gym.
• Access to our on-site physio.

Other Perks

• Save up to 12% on the cost of personal tech through our salary sacrifice scheme.
• Subsidised bus pass from Manchester City Centre to our ICON office.
• Up to 50% staff discount on THG brands.
• On-site staff shop.
• Access to on-site barber.
• Know someone who would be perfect for THG? Refer them and get up to £1000 when they pass their probation.
• Anniversary gifts when you hit 5 and 10 years of service.

THG is proud to be a Disability Confident Committed employer. If you are invited to interview, please let us know if there are any reasonable adjustments we can make to the recruitment process that will enable you to perform to the best of your ability.

THG is committed to creating a diverse & inclusive environment and hence welcomes applications from all sections of the community.

Because of the high volumes of applications our opportunities attract, it sometimes takes us time to review and consider them all. We endeavour to respond to every application we receive within 14 days. If you haven't heard from us within that time frame or should you have any specific questions about this or other applications for positions at THG please contact one of our Talent team to discuss further.