Senior MySQL Developer/DBA

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

Job summary

A recruitment agency is seeking an experienced MySQL Database Administrator based in or near Oxford, UK, to implement and maintain high-traffic databases. This role requires expertise in SQL performance tuning, database server management, and works both in-office and remotely. Ideal candidates will be comfortable in a high-availability environment and possess strong communication skills.

Qualifications

• Experience as a MySQL DBA and developer.
• Ability to manage database server configurations and log files.
• Good experience in backup and recovery plan development.
• Experience in performance tuning and optimization.

Responsibilities

• Implement and maintain high-traffic database applications.
• Ensure databases run optimally and performantly.
• Work in a high-availability business environment.

Skills

MySQL DBA and developer experience

Database server configuration management

Backup and recovery plan development

Performance tuning and optimization

Migrating SQL Server databases to MySQL

Writing performant SQL and stored procedures

Upgrading MySQL architecture

Working with source control platforms like GIT

Using logging and analysis tools

Understanding architectural design choices

Writing performant queries

Experience in high-traffic environments

Knowledge of data security best practices

Application of software development best practices

Great communication skills

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