Database Performance Engineer Job in Leadsquared
Database Performance Engineer
- Bengaluru, Bangalore Urban, Karnataka
- Not Disclosed
- Full-time
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 database ops 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 the engineering team to get them fixed.
Identify blocked transactions and deadlocks and work with the engineering team to resolve them.
Work with the release team to ensure there is no risk and impact on database cluster posts changes.
Provision clusters and manage scaling needs.
Data migration
Requirements:
3+ years of experience in deployment, monitoring, tuning, and administration of high concurrency MySQL production databases.
Solid understanding of writing optimized SQL queries on MySQL databases
Understanding of AWS, VPC, networking, security groups, IAM, and roles.
Expertise in scripting in Python or Shell/Powershell
Must have experience in large scale data migrations
Excellent communication skills.
Your 4 Step Guide to Career Success
