Senior MySQL Developer/DBA (Remote)

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

Job summary

A leading recruitment firm is seeking a highly experienced MySQL Database Administrator for a role based in the Oxford area. This position allows remote work, with in-office attendance required only once a month. The successful candidate will implement, maintain, and optimize high-traffic databases while migrating SQL Server databases to MySQL. The ideal individual possesses strong experience in performance tuning, managing database configurations, and writing efficient SQL solutions. Excellent communication skills are necessary as part of a global team.

Qualifications

• Experience working as a MySQL DBA and developer.
• Ability to manage database server configurations.
• Skilled in developing and testing backup and recovery plans.
• Experience in performance tuning and optimization.
• Strong experience writing performant SQL and stored procedures.
• Solid understanding of architectural design choices.

Skills

MySQL DBA and developer

Database server configurations

Backup and recovery plans

Performance tuning and optimisation

Migrating SQL Server databases to MySQL

Writing performant SQL

Source control platforms (GIT)

Logging and analysis tools

Database architectural design

Communication skills

Tools

Elasticsearch

Rollbar Sentry

Job description

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 Oxford 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.

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 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 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