At a Glance
- Tasks: Manage and optimise high-traffic MySQL databases while migrating SQL Server databases.
- Company: Join a dynamic team in Oxford, working remotely most of the time.
- Benefits: Enjoy flexible remote work with just one office day per month.
- Why this job: Be part of a skilled team, contributing to impactful database solutions in a 24/7 environment.
- Qualifications: Must have experience as a MySQL DBA and developer, with strong SQL skills.
- Other info: Stay updated with the latest technologies and best practices in a collaborative setting.
The predicted salary is between 48000 - 84000 Β£ per year.
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
#J-18808-Ljbffr
Senior MySQL Developer/DBA employer: McNally Recruitment Ltd
Contact Detail:
McNally Recruitment Ltd Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land Senior MySQL Developer/DBA
β¨Tip Number 1
Familiarise yourself with the latest MySQL features and best practices. Being up-to-date with the latest advancements will not only enhance your skills but also demonstrate your commitment to continuous learning, which is highly valued in a Senior MySQL Developer/DBA role.
β¨Tip Number 2
Network with professionals in the database management field, especially those who work with MySQL. Attend local meetups or online webinars to connect with others, share knowledge, and potentially get referrals that could lead to job opportunities.
β¨Tip Number 3
Showcase your experience with SQL Server to MySQL migrations. Prepare to discuss specific projects where you successfully managed this process, as itβs a key requirement for the role and can set you apart from other candidates.
β¨Tip Number 4
Highlight your ability to work in high-availability environments. Be ready to provide examples of how you've ensured database performance and security in such settings, as this aligns closely with the expectations for the position.
We think you need these skills to ace Senior MySQL Developer/DBA
Some tips for your application π«‘
Tailor Your CV: Make sure your CV highlights your experience as a MySQL DBA and developer. Focus on specific projects where you've managed database configurations, optimised performance, and migrated SQL Server databases to MySQL.
Craft a Strong Cover Letter: In your cover letter, emphasise your understanding of high-traffic environments and your ability to work within a 24/7/365 schedule. Mention your passion for technology and how you stay updated with the latest skills relevant to the role.
Showcase Relevant Skills: Clearly list your mandatory skills in your application. Highlight your experience with performance tuning, backup and recovery plans, and your familiarity with tools like GIT and logging analysis tools such as Elasticsearch.
Demonstrate Communication Skills: Since this role involves working with an internationally based team, make sure to convey your strong communication skills in your application. Provide examples of how you've successfully collaborated with diverse teams in the past.
How to prepare for a job interview at McNally Recruitment Ltd
β¨Showcase Your Technical Expertise
Be prepared to discuss your experience with MySQL in detail. Highlight specific projects where you implemented, maintained, or optimised databases, and be ready to explain the challenges you faced and how you overcame them.
β¨Demonstrate Problem-Solving Skills
Expect scenario-based questions that assess your ability to troubleshoot and optimise database performance. Think of examples where you successfully resolved issues related to high-traffic environments or database migrations.
β¨Communicate Clearly and Effectively
As a core member of an internationally based team, strong communication skills are essential. Practice explaining complex technical concepts in simple terms, as you may need to collaborate with non-technical stakeholders.
β¨Stay Updated on Industry Trends
Show your passion for technology by discussing recent developments in database management and security best practices. This demonstrates your commitment to continuous learning and staying relevant in the field.