Senior MySQL Developer/DBA

McNally Recruitment Ltd; City Of London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A recruitment agency seeks a highly experienced MySQL Database Administrator based in or near Oxford, UK. The role involves implementing and tuning high-traffic database applications, with remote work flexibility. Strong performance tuning skills and experience in migrating SQL Server databases are essential. Join a skilled team focused on optimising database performance and security.

Qualifications

• Ability to understand business data structure.
• Experience working in a high-availability environment.
• Solid understanding of data security best practices.

Responsibilities

• Implement, maintain, and tune high-traffic database applications.
• Migrate existing SQL Server databases to MySQL.
• Work as a core team member to ensure databases run optimally.

Skills

Experience working as a MySQL DBA and developer

Performance tuning, optimisation, execution plans

Ability to profile and optimise server resource usage

Experience with migrating SQL Server databases to MySQL

Strong experience writing performant SQL

Good experience in developing, managing, and testing backup and recovery plans

Experience with source control tools such as GIT

Experience with logging and analysis tools

Solid understanding of architectural design choices

Passion for technologies and desire to remain up to date

Job description

Overview

Our client is seeking a highly experienced MySQL Database Administrator based in or near Oxford, UK, as you will be required to work in the office 1 day per month; otherwise, you will be working remotely. The candidate will be responsible for implementing, maintaining, and tuning high-traffic, multiple database applications as well as migrating existing SQL Server databases.

Behavioural Competency

You will have the ability to understand the business in terms of how the data is structured, making valuable contributions to ensure that the databases are running in optimal and performant conditions.

Experience and Role Fit

As a Senior MySQL Developer/DBA, you should be comfortable working with a variety of implementations and be used to working within a high-availability business that operates on a 24/7/365 schedule. You will have experience working within highly skilled and multifaceted teams, capable of utilising a range of tools and processes to build robust, performant, scalable and modern applications.

Mandatory Skills

• Experience working as a MySQL DBA and developer
• Experience working with and managing database server configurations, log files, binary logs, etc., along with the ability to profile and optimise server resource usage.
• Good experience in developing, managing, and testing backup and recovery plans.
• Experience in performance tuning, optimisation, execution plans and indexes, along with best practices for database design.
• Experience with migrating SQL Server databases to MySQL
• Strong experience writing performant SQL, stored procedures, etc
• Experience in performing upgrades to the core MySQL architecture when appropriate
• Solid experience working with source control platforms and tools such as GIT.
• Experience with logging and analysis tools (Elasticsearch, Rollbar Sentry)
• Solid understanding of architectural design choices (Heap, MyISAM, INNO DB etc)
• Experience writing performant queries and procedures to ensure optimal solutions
• Experience working with high-traffic, responsive environments and applications to ensure the performance, security, and availability of databases.
• Passion for technologies and a desire to remain up to date with the latest skills
• Knowledge and experience with data security best practices
• Application of software development best practices
• Great communication skills as a core member of an internationally based team