Senior PostgreSQL Database Administrator

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.