MySql Developer

LeadSquared is a leading customer acquisition SaaS platform used by over 70,000 users across 25 countries to run their sales and marketing processes. Our goal is to grow 10X in the next 3 years which is an exciting scale challenge for our Devops and Engineering teams.

The Role
Our entire platform is hosted on AWS, and the heart and core of our platform is based on MySQL databases. As of today, we have 100+ database servers handling several TBs of transactional data, and this could grow 100X in the next few years.
We are looking for a strong database engineer to manage, monitor and tune our MySQL clusters setup on AWS Aurora.

Responsibilities:
• Monitor the performance of database clusters and proactively identify scaling needs
• Analyze slow queries and work with engineering team to get them fixed.
• Help reports team write optimized queries and help create indexes where necessary
• Identify blocked transactions and deadlocks and work with engineering team to resolve them.
• Work with release team to ensure there is no risk and impact on database clusters post changes.
 
Requirements:
• 4+ years of experience in developing database (MySQL) driven applications with query writing and optimization as the primary responsibility
• Solid expertise in SQL
• Must have experience of identifying slow queries and fixing them.
• Understand blocked transactions and deadlocks and know how to resolve them.

• Experience in reviewing stored procedures and queries written for MySQL and guiding developers to write optimized queries.
• Excellent communication skills.