Senior Database Engineer (MySQL)

2 days ago – Be among the first 25 applicants Who We Are 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 partnerships that drive real results. We\’re a team of passionate problem-solvers who are dedicated to helping our clients win in the ever-evolving world of digital marketing. Why Join Us 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 salary, generous benefits, and a flexible work environment that allows you to thrive both personally and professionally. If you\’re ready to grow your career and make a difference, we\’d love to hear from you. Job Overview We are at a pivotal point in our tech progression. We\’re looking to grow the technical estate, replace existing systems with new and scale and develop the platform. It\’s an exciting time to join the team in this captivating period. As a Senior Database Engineer (MySQL) – Databases you will be part of the Partnerize Technical Operations team, working with the business, development, and IT functions. You will be working within a team of Infrastructure Engineers responsible for designing, building and implementing solutions for the platform and providing the required training to support the solution. You will also be responsible for ensuring all issues/problems are addressed in a timely manner by the team. You should have a keen interest in problem-solving accompanied with experience in networking, Linux systems and an experience in system designs, analysing what is currently implemented and offering improvements as well as ensuring the supporting documentation is in place. You’ll be supporting and maintaining the network, infrastructure, delivering projects and processes required to ensure we remain available, scalable, and secure. Involved in support, project delivery and maintenance activities completed by the Operational Team. As a Senior Database Engineer at Partnerize, You Will: Scoping the work coming into the Infrastructure Solutions team and delegating to the team members appropriately. Provide primary operational support and engineering for multiple large Databases servicing distributed software applications. Measure and optimise new implemented systems performance, with an eye toward pushing our capabilities forward. Build software and systems to manage platform infrastructure and applications. Improve reliability, quality, and time-to-market of our suite of software solutions. Partner with development teams to improve services through rigorous testing and release procedures. Document procedures, best practices, and troubleshooting steps for knowledge sharing and team collaboration. Strong communication skills to work with development teams, product owners, and other stakeholders to ensure database needs are met. Deliver large technical projects. Act as an escalation for other support teams within TechOps. Plan, prioritise, and estimate tasks using Jira. Experience in mentoring junior DBAs and providing technical leadership on database design, optimisation, and migration strategies. Essential Knowledge, Skills and Experience MySQL Proficiency in MySQL replication (master‑slave, master‑master) and high availability configurations. Experience in query performance optimisation, including slow query analysis, indexing strategies, and troubleshooting. Strong understanding of schema optimisation (e.g., normalisation, denormalisation, partitioning) to enhance database performance. Experience in managing MySQL upgrades and schema migrations in production environments, ensuring minimal downtime and data integrity. In‑depth knowledge of replication techniques across the various database technologies to ensure high availability, data consistency, and fault tolerance. Experience in setting up and maintaining multi‑master replication, geo‑replication, GTID and disaster recovery strategies. Proficient in resolving replication lag, fail‑over issues, and ensuring data integrity across different database platforms. PostgreSQL / NoSQL Databases Expertise in PostgreSQL replication (synchronous, asynchronous), logical replication, and managing replication lag. Ability to troubleshoot and resolve slow queries. Experience in PostgreSQL schema optimisation (indexing, partitioning, query rewrites) to ensure efficient data retrieval. Solid understanding of upgrades and migrations, including handling major and minor version upgrades, and managing extension compatibility. Database Upgrades Demonstrated experience in performing database upgrades (both major and minor versions) with minimal downtime, ensuring compatibility across systems, and handling post‑upgrade issues. Database Migrations In‑place migrations (within the same database platform). Cross‑database migrations (e.g., migrating from MySQL to PostgreSQL or MongoDB to CouchDB). Migrating between cloud providers or on‑prem to cloud for various database platforms. Automating and scripting the migration process where possible. Experience in versioning and testing migration scripts to ensure smooth transitions with minimal service interruption. Monitoring where they are treated fairly and respectfully, have equal access to opportunities and resources and can contribute fully to the organization’s success. Every individual in our business is expected to live this commitment without exception. Privacy and Data Protection The data collected as part of this application will be used for the recruitment process and any subsequent employment. You can find further information in Partnerize privacy policy here: https://partnerize.com/privacy-policy/ Seniority Level Mid‑Senior level Employment Type Full‑time Job Function Software Development, IT Services and IT Consulting Location London, United Kingdom Updates 2 days ago | London, United Kingdom Get notified about new Senior Database Engineer jobs in London, England, United Kingdom. #J-18808-Ljbffr