02 Oct
|
Deservely Technologies
|
Indore
02 Oct
Deservely Technologies
Indore
Senior MySQL Developer
Location: Indore (Vijay Nagar)
Work Mode: Onsite
Experience: 6–10 Years
Employment Type: Full-Time
About The Role
We are looking for an experienced Senior MySQL Developer with 6–10 years of strong hands-on experience in database development, query optimization, and performance tuning. The ideal candidate should have deep expertise in MySQL/Amazon Aurora MySQL, complex SQL queries, stored procedures, indexing, and database performance optimization.
The candidate will work closely with application developers, QA, DevOps, and product teams to design productive database solutions, troubleshoot performance issues, and ensure reliable handling of business-critical data.
This is a hands-on role for someone who enjoys solving complex database problems, improving query performance, and working with large-scale production databases.
Key ResponsibilitiesMySQL & Aurora Development
• Design, develop, and maintain database solutions using MySQL and Amazon Aurora MySQL.
• Develop complex SQL queries, joins, subqueries, views, functions, and database objects.
• Create and maintain stored procedures, functions, triggers, and other database components.
• Design efficient database schemas based on application and business requirements.
• Ensure database solutions are scalable, reliable, and maintainable.
Query Optimization & Performance Tuning
• Analyze and optimize slow or complex SQL queries.
• Use EXPLAIN and EXPLAIN ANALYZE to understand query execution plans.
• Identify performance bottlenecks related to queries, indexes, joins, and database design.
• Create and improve indexes to increase query performance.
• Perform database performance tuning for high-volume and production workloads.
• Monitor query performance and recommend improvements to development teams.
Production Database Support
• Troubleshoot database-related production issues and provide root-cause analysis.
• Analyze slow queries, locking issues, deadlocks, connection problems, an
📌 MYSQL DATABASE DEVELOPER (Indore)
🏢 Deservely Technologies
📍 Indore