MySQL Developer

Deservely Technologies; Indore District; Sur place; INR 800 000 - 1 600 000; Plein temps

Résumé du poste

Deservely Technologies seeks an experienced MySQL Developer to design and optimize complex SQL queries, stored procedures, and database objects. You will work with MySQL and Amazon Aurora, ensuring high performance, reliability, and scalable data solutions.

The role involves query optimization, performance tuning, migrations, and close collaboration with DevOps and development teams to deliver robust database systems.

Qualifications

• 5+ years of MySQL database development experience.
• Hands-on with MySQL and Amazon Aurora databases.
• Strong knowledge of complex SQL queries, joins, and subqueries.
• Experience building and maintaining stored procedures, functions and triggers.
• Proficient in query optimization and indexing strategies.
• Experience in performance tuning and troubleshooting databases.
• Familiarity with data migrations, schema changes and validation.
• Understanding of admin and system-level database operations.
• Knowledge of transactions, locking, and concurrency.

Responsabilités

• Design, develop, and maintain complex SQL queries and database objects.
• Work with MySQL/Aurora to support applications and business needs.
• Analyze and optimize performance using EXPLAIN plans and indexing.
• Tune databases and resolve slow queries and bottlenecks.
• Design efficient schemas, indexes, and data access patterns.
• Execute migrations, upgrades, and schema changes with validation.
• Handle system-level DB activities including config and resources.
• Support DB administration: user access, permissions, monitoring, maintenance.
• Ensure data integrity and availability across environments.
• Collaborate with developers/DevOps to improve reliability.
• Document designs, migration procedures, and operational processes.

Connaissances

5+ years of experience

Complex SQL queries

Stored procedures and triggers

Query optimization

Performance tuning

Data migrations

Schema design

System-level DB operations

Transactional integrity

Outils

MySQL

Amazon Aurora

Description du poste

Experience

5+ Years

Role

MySQL Developer

Job Summary

We are looking for an experienced MySQL Developer with strong expertise in database development, complex SQL queries, stored procedures, query optimization, and performance tuning. The ideal candidate should have hands-on experience with MySQL/Amazon Aurora, database migrations, and system-level database activities, ensuring high performance, reliability, and scalability.

Key Responsibilities

• Design, develop, and maintain complex SQL queries, stored procedures, functions, triggers, and database objects.
• Work with MySQL and Amazon Aurora databases to support application and business requirements.
• Analyze and optimize query performance using EXPLAIN plans, indexing strategies, and execution analysis.
• Perform database performance tuning, troubleshoot slow queries, and resolve database bottlenecks.
• Design and maintain efficient database schemas, indexes, and data access patterns.
• Execute data migrations, database upgrades, schema changes, and data validation activities from different databases.
• Handle system-level database activities, including configuration, resource utilization, connection management, and troubleshooting.
• Support database administration activities, including user access, permissions, monitoring, and maintenance.
• Ensure data integrity, consistency, availability, and reliability across database environments.
• Collaborate with application developers, DevOps, and infrastructure teams to improve database performance and reliability.
• Document database designs, optimization techniques, migration procedures, and operational processes.

Must-Have Skills

• 5+ years of experience in MySQL database development.
• Strong hands-on experience with MySQL and/or Amazon Aurora.
• Expertise in complex SQL queries, joins, subqueries, CTEs, and query design.
• Strong experience developing and maintaining stored procedures, functions, and triggers.
• Proficiency in query optimization, execution plan analysis using EXPLAIN, and indexing strategies.
• Hands-on experience in database performance tuning and troubleshooting.
• Experience with data migrations, schema changes, and data validation.
• Understanding of database administration and system-level database operations.
• Strong knowledge of relational database concepts, transactions, locking, and concurrency.

Good-to-Have Skills

• Experience working with JSON data types and JSON-based queries in MySQL.
• Database automation and scripting for routine maintenance and operational tasks.
• Experience with database monitoring, performance metrics, and alerting.
• Knowledge of backup and recovery strategies.
• Experience handling large-scale databases and high-volume transactional workloads.

Skills: query optimization,stored procedures,performance tuning,complex sql,indexing,mysql,database migration,aws