MySQL Developer
Job Description
About the Role
We are looking for a MySQL Developer to design, optimize, and maintain data systems built on Schema Design & Migration, Query Optimization, InnoDB Tuning. This role combines technical depth in MySQL with the ability to understand business context — you'll work with analysts, engineers, and stakeholders to ensure data is reliable, accessible, and useful. The ideal candidate has hands-on experience with MySQL Workbench and ProxySQL, can diagnose complex query performance issues, and understands both OLTP and OLAP patterns. You'll own data pipeline reliability, query performance, and schema evolution for systems handling millions of records.
Key Responsibilities
- Own Schema Design & Migration implementation and optimization — configuration, customization, and ongoing enhancement based on business needs
- Manage Query Optimization workflows including setup, user training, and continuous improvement of processes
- Implement and maintain InnoDB Tuning ensuring seamless integration with existing systems and workflows
- Design and maintain MySQL schemas optimized for both operational and analytical workloads
- Write and optimize complex queries, stored procedures, and data transformation pipelines
- Monitor MySQL performance — query execution plans, resource utilization, and capacity planning
- Build automated ETL/ELT pipelines for data integration from multiple source systems
- Create dashboards and reporting solutions that enable data-driven decision making
- Implement data quality checks, validation rules, and monitoring for data pipeline reliability
- Plan and execute database migrations with zero-downtime cutover strategies
Must-Have Qualifications
- Hands-on experience with Schema Design & Migration — configuration, customization, and troubleshooting in production environments
- Proficiency with MySQL Workbench as part of the MySQL development/operations workflow
- 3+ years of hands-on MySQL experience in production environments
- Strong SQL skills — complex queries, window functions, CTEs, and query optimization
- Experience with data modeling — star schemas, normalization, and denormalization trade-offs
- Understanding of ETL/ELT pipeline design and data quality management
- Ability to communicate data insights to both technical and non-technical stakeholders
Nice-to-Have Skills
- Oracle MySQL Database Administrator certification or equivalent validated credential
- Oracle MySQL Developer certification or equivalent validated credential
- Experience with advanced MySQL features: Query Optimization, InnoDB Tuning, Replication & Clustering
- Familiarity with the broader MySQL ecosystem including ProxySQL and Percona Toolkit
- Experience with real-time streaming systems (Kafka, Kinesis, or Flink)
- Knowledge of data governance frameworks and data catalog tools
Interview Tips
Technical Coding Exercise
Give a small, realistic MySQL coding challenge that tests fundamentals — clean code, edge case handling, and test writing. Time-box to 45-60 minutes.
Architecture Whiteboard
Present a system design problem relevant to MySQL. Evaluate their approach to scalability, data modeling, and trade-off discussions.
Code Review Simulation
Show a MySQL pull request with both good patterns and subtle issues. Assess what they catch, how they communicate feedback, and what they prioritize.
Past Project Deep-Dive
Have them walk through their most challenging MySQL project. Ask probing questions about architecture decisions, obstacles, and what they learned.
Typical Team Structure
Team Size
2-5 MySQL developers
Reports To
Engineering Manager, Tech Lead, or CTO
Collaborates With
Product Management, QA/Testing, DevOps, Design
Skip the JD — Get Matched Instead
Tell us your MySQL requirements and we'll send pre-vetted profiles with video intros in 24-48 hours.
You're all set!
We'll send matched profiles within 24-48 hours. Check your email for next steps.