<div>At Deservely, we believe that career services should be redefined to help professionals navigate career changes with ease. While organizations have access to recruitment consultants and headhunters to hire talent, professionals seeking a career change often have to fend for themselves. We aim to change this status quo by providing professionals with the support and resources they need to succeed in their careers. Our current products and services, which include a cutting-edge online resume builder, expert resume writing and reviewing services, and LinkedIn profile management, are just the beginning of our journey toward creating a digital career assistant for professionals worldwide. If you're ready to take the next step in your career, visit us at www.deservely.com, and stay tuned for more exciting developments to come!</div>

Deservely Technologies Pvt Ltd

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
<ul>
<li>
Design, develop, and maintain complex SQL queries, stored procedures, functions, triggers, and database objects.
</li>
<li>
Work with MySQL and Amazon Aurora databases to support application and business requirements.
</li>
<li>
Analyze and optimize query performance using EXPLAIN plans, indexing strategies, and execution analysis.
</li>
<li>
Perform database performance tuning, troubleshoot slow queries, and resolve database bottlenecks.
</li>
<li>
Design and maintain efficient database schemas, indexes, and data access patterns.
</li>
<li>
Execute data migrations, database upgrades, schema changes, and data validation activities from different databases.
</li>
<li>
Handle system-level database activities, including configuration, resource utilization, connection management, and troubleshooting.
</li>
<li>
Support database administration activities, including user access, permissions, monitoring, and maintenance.
</li>
<li>
Ensure data integrity, consistency, availability, and reliability across database environments.
</li>
<li>
Collaborate with application developers, DevOps, and infrastructure teams to improve database performance and reliability.
</li>
<li>
Document database designs, optimization techniques, migration procedures, and operational processes.
</li>
</ul>
Must-Have Skills
<ul>
<li>
5+ years of experience in MySQL database development.
</li>
<li>
Strong hands-on experience with MySQL and/or Amazon Aurora.
</li>
<li>
Expertise in complex SQL queries, joins, subqueries, CTEs, and query design.
</li>
<li>
Strong experience developing and maintaining stored procedures, functions, and triggers.
</li>
<li>
Proficiency in query optimization, execution plan analysis using EXPLAIN, and indexing strategies.
</li>
<li>
Hands-on experience in database performance tuning and troubleshooting.
</li>
<li>
Experience with data migrations, schema changes, and data validation.
</li>
<li>
Understanding of database administration and system-level database operations.
</li>
<li>
Strong knowledge of relational database concepts, transactions, locking, and concurrency.
</li>
</ul>
Good-to-Have Skills
<ul>
<li>
Experience working with JSON data types and JSON-based queries in MySQL.
</li>
<li>
Database automation and scripting for routine maintenance and operational tasks.
</li>
<li>
Experience with database monitoring, performance metrics, and alerting.
</li>
<li>
Knowledge of backup and recovery strategies.
</li>
<li>
Experience handling large-scale databases and high-volume transactional workloads.
</li>
</ul>