Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our team as a Senior Database Engineer, focusing on MySQL and database optimisation.
- Company: Partnerize is evolving its tech landscape, offering a dynamic environment for growth.
- Benefits: Enjoy a full-time role with opportunities for learning and development in a supportive culture.
- Why this job: Be part of an exciting tech transformation, contributing to impactful projects and innovations.
- Qualifications: Proficiency in MySQL, PostgreSQL, and experience in database migrations are essential.
- Other info: We're looking for passionate individuals eager to learn and grow with us.
The predicted salary is between 43200 - 72000 ÂŁ per year.
Join to apply for the Senior Database Engineer (MySQL) role at Partnerize
Join to apply for the Senior Database Engineer (MySQL) role at Partnerize
Get AI-powered advice on this job and more exclusive features.
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, they work 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.
We’re looking for a Senior Database Engineer – Databases with a desire to learn. For us, it\’s more about the person and the character than the role. We need people that will get excited about taking us to the next stage of our evolution helping us with their specific skills and experience but learning new ones along the way.
Essential Knowledge, Skills and Experience
MySQL:
- Proficiency in MySQL replication (master-slave, master-master) and high availability configurations.
- Experiencein 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, failover issues, and ensuring data integrity across different database platforms.
- 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.
Demonstrated experience in performing database upgrades (both major and minor versions) with minimal downtime, ensuring compatibility across systems, and handling post-upgrade issues.
Expertise in managing database migrations , including:
- 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 & Troubleshooting:
- Strong experience with database monitoring tools (e.g., Prometheus, Grafana, New Relic, Percona Monitoring and Management) for tracking performance metrics and ensuring database health.
- Expertise in diagnosing and resolving performance issues related to replication, slow queries, schema design, and database migrations.
- Knowledge of setting up alerting systems and responding to database issues proactively.
Desirable Knowledge, Skills and Experience
Automation & Scripting:
- Proficiency in scripting languages (e.g., Python, Shell, Bash) to automate routine DBA tasks such as backups, monitoring, upgrades, and mi grations.
- Experience with automation tools such as Ansible, Chef, or Puppet to manage database configurations across multiple environments.
- Familiarity with CI/CD pipelines for database schema changes and migrations to ensure controlled and tested deployments.
Apache Druid / Column based databases:
- Familiarity with setting up and managing replication across Druid clusters, including data availability and data sharding strategies.
- Experience with query optimisation in Druid, especially for long-running queries in OLAP workloads.
- Understanding of schema design and optimisation for Druid’s columnar data format.
- Knowledge of managing Druid upgrades and migrations within distributed environments to ensure zero-downtime or minimal disruption.
MongoDB:
- Expertise in MongoDB replication (ReplicaSets, Sharded Clusters) to ensure data redundancy, fault tolerance, and scalability.
- Experience with slow query troubleshooting using tools like the MongoDB Profiler and Aggregation Framework optimization.
- Proficient in schema design for MongoDB, with a focus on denormalisation , indexing strategies , and sharding to improve query performance.
- Hands-on experience with upgrading MongoDB versions and migrating data between MongoDB clusters or from on-premises to cloud environments.
Additional experience:
- Experience with monitoring systems (Zabbix, Prometheus)
- Containerisation and Orchestration : Familiarity with deploying and managing databases in containerized environments (e.g., Docker , Kubernetes ).
- Experience of JIRA and Confluence
- Openness to learn the required technologies.
- An interest in development, new technologies and innovation
- Supporting development teams into the refactoring of technical debt
Seniority level
-
Seniority level
Mid-Senior level
Employment type
-
Employment type
Full-time
Job function
-
Job function
Information Technology and Engineering
-
Industries
Advertising Services
Referrals increase your chances of interviewing at Partnerize by 2x
Sign in to set job alerts for “Database Engineer” roles.
London, England, United Kingdom 2 days ago
Data Engineer (open to the UK and Europe)
London, England, United Kingdom 1 week ago
Bristol, England, United Kingdom 2 months ago
London, England, United Kingdom 2 months ago
Manchester, England, United Kingdom 2 months ago
Data Engineer (open to the UK and Europe)
Greater London, England, United Kingdom 3 days ago
London, England, United Kingdom 4 months ago
London, England, United Kingdom 1 month ago
London, England, United Kingdom 2 months ago
London, England, United Kingdom 1 week ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Senior Database Engineer (MySQL) employer: Partnerize
Contact Detail:
Partnerize Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Database Engineer (MySQL)
✨Tip Number 1
Familiarise yourself with the latest MySQL features and best practices. Being able to discuss recent advancements or optimisations in MySQL during your interview can demonstrate your passion and commitment to staying current in the field.
✨Tip Number 2
Showcase your problem-solving skills by preparing examples of past challenges you've faced in database management. Be ready to explain how you approached these issues, the solutions you implemented, and the outcomes achieved.
✨Tip Number 3
Network with current employees or professionals in the industry through platforms like LinkedIn. Engaging with them can provide insights into the company culture and expectations, which can be invaluable during your interview.
✨Tip Number 4
Prepare to discuss your experience with automation and scripting, as these skills are highly valued. Be ready to share specific examples of how you've used tools like Python or Ansible to streamline database tasks in previous roles.
We think you need these skills to ace Senior Database Engineer (MySQL)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with MySQL, PostgreSQL, and any relevant database technologies. Focus on your skills in replication, performance optimisation, and schema design, as these are crucial for the role.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the position and the company. Mention specific projects or experiences that demonstrate your problem-solving skills and your ability to work within a team, as well as your eagerness to learn new technologies.
Showcase Relevant Projects: If you have worked on significant database projects, include them in your application. Describe your role, the challenges faced, and how you contributed to the project's success, particularly in areas like migration and automation.
Highlight Continuous Learning: Emphasise your commitment to continuous learning and professional development. Mention any courses, certifications, or self-study efforts related to database management, automation, or new technologies that align with the job requirements.
How to prepare for a job interview at Partnerize
✨Showcase Your MySQL Expertise
Be prepared to discuss your experience with MySQL replication, high availability configurations, and query performance optimisation. Bring specific examples of past projects where you successfully implemented these skills.
✨Demonstrate Problem-Solving Skills
Since the role requires a keen interest in problem-solving, be ready to share instances where you've tackled complex database issues. Highlight your analytical approach and how you ensured minimal downtime during upgrades or migrations.
✨Familiarise Yourself with Monitoring Tools
Understand the database monitoring tools mentioned in the job description, such as Prometheus and Grafana. Be prepared to discuss how you've used these tools to track performance metrics and resolve issues in previous roles.
✨Express Your Willingness to Learn
The company values character and a desire to learn over strict qualifications. Share your enthusiasm for new technologies and how you plan to grow within the role, especially regarding automation and scripting.
