Lead Database Administrator

At Partnerize, we're on a mission to transform the way businesses grow. We've built the leading partnership automation platform that empowers brands to discover, engage, and convert their audiences at scale. From affiliate marketing to influencer collaborations, we help our clients build and manage profitable partne...

We're looking for passionate, talented people who want to be part of a winning team. At Partnerize, you'll find a culture of collaboration, innovation, and respect. We're guided by our core values, and we're committed to creating an environment where everyone can do their best work. We also offer a competitive salar...

We are at a pivotal point in our tech progression. We're looking to grow our technical estate, architect new systems, remove technical debt and scale our platform. It's an exciting time to join Partnerize, and we are looking for a technical leader to help spearhead this evolution.

MySQL & On-Premise Infrastructure: Advanced administration of MySQL in production environments, whether on-premise or in the cloud. Crucially, as our primary database is on-premise, you must possess strong Linux system administration and networking awareness to independently support, secure, and maintain the underlying servers.
Independence: Experience as either the sole or lead owner for large production database infrastructure within a SaaS environment with demonstrable accountability for its availability and performance. A proven track record of managing these responsibilities while coordinating with external technical stakeholders and adhering to light change management processes.
High Availability & Replication: Advanced experience configuring and troubleshooting complex MySQL replication setups (such as primary-replica, multi-master, and GTID). Proven ability to quickly resolve replication lag, manage smooth failovers, and execute disaster recovery plans. 
Monitoring: A working understanding of database monitoring tools and patterns. What to measure, appropriate thresholds, and response mechanics.
Performance Optimisation: Deep expertise in query tuning, slow query analysis, and advanced schema optimisation (including normalisation, partitioning, query rewrites, and indexing strategies).
Upgrades, Migrations & Scripting: Proven track record of executing minimal-downtime upgrades and complex migrations (in-place, cross-database, or migrating ancillary workloads). Highly skilled in automating these processes using Python and/or Bash to build robust, version-controlled scripts.
Database Security & Compliance: Experience securing database infrastructure through SSL/TLS encryption, user access control, audit logging, and automated backup encryption.
Automation, Containers & CI/CD: Hands-on expertise using Ansible for configuration management, deploying and managing databases within Kubernetes/containerised environments, and managing version control and pipelines via GitLab for any database related change.
Monitoring & Troubleshooting: Hands-on experience deploying and configuring monitoring/alerting stacks (such as Prometheus, Grafana, or Percona Monitoring and Management) for proactive issue resolution and database health tracking.
PostgreSQL & Hybrid Estates: Advanced administration of PostgreSQL, alongside experience managing database workloads across a hybrid environment (e.g., combining on-premise architecture with AWS).
OLAP & Data Warehousing (Apache Druid / Snowflake): Familiarity with columnar databases and cloud data platforms, particularly Apache Druid and Snowflake. Experience with schema design, data sharding strategies, OLAP query optimisation for long-running queries, and managing zero-downtime upgrades in distributed environments.
Service Management Tooling: Experience using Jira and Confluence for managing workflows, project tracking, and creating technical documentation.
Openness to learn the required technologies.
An interest in development, new technologies and innovation.
Supporting development teams into the refactoring of technical debt.
At Partnerize, we recognise it is unrealistic for a candidate to fulfil 100% of the criteria in this job description. We encourage you to apply if you feel you meet the majority of the requirements above. We know that skills evolve over time, so if you have a keen appetite to learn and evolve alongside us over time, come join our team!