We are looking for a highly experienced Senior SQL Database Administrator (DBA) with 7+ years of hands-on experience in MySQL to manage and optimize the database infrastructure for a high-scale SaaS application serving 10,000+ tenants across multiple countries. The ideal candidate must have deep expertise in database optimization, performance tuning, multi-tenant architecture, and best practices to ensure high availability, scalability, and efficiency.

You will play a crucial role in managing a multi-tenant SaaS database, ensuring data partitioning, indexing strategies, query optimization, and high availability to support a rapidly growing user base.

Key Responsibilities:

Database Management for a SaaS Platform:

• Design, implement, and maintain a scalable multi-tenant database architecture in MySQL.
• Ensure high availability, fault tolerance, and redundancy across multiple regions.
• Optimize database performance to handle a large volume of transactions from 10,000+ tenants.
• Develop data partitioning and sharding strategies to scale horizontally.

Performance Optimization & Query Tuning:

• Optimize SQL queries, stored procedures, and indexing strategies to improve performance.
• Analyze and fine-tune execution plans, slow queries, and database bottlenecks.
• Implement caching mechanisms and optimize read-heavy operations.

Security, Backup & Disaster Recovery:

• Implement data security best practices, including encryption, access control, and GDPR compliance.
• Develop and maintain automated backup and disaster recovery plans.
• Monitor database logs for security threats, anomalies, and performance degradation.

Scalability & Automation:

• Automate routine database tasks using scripting (Bash, Python, or SQL-based tools).
• Implement database monitoring, alerting, and predictive analytics for proactive issue resolution.
• Design and optimize schema changes and migrations to ensure minimal downtime.

Collaboration & Documentation:

• Work closely with developers, DevOps, and product teams to integrate scalable database solutions.
• Guide engineering teams on query optimization, best practices, and efficient schema design.
• Maintain detailed documentation for database architecture, query tuning guidelines, and security policies.

Required Qualifications:

• Experience: 7+ years as a MySQL DBA, preferably managing SaaS applications with high-traffic databases.
• Technical Skills:

o Expertise in MySQL database administration, tuning, and multi-tenant architecture.

o Strong knowledge of query optimization, indexing strategies, and execution plans.

o Experience with data partitioning, replication, clustering, and sharding.

o Proficiency in writing and debugging stored procedures, triggers, and complex SQL queries.

o Knowledge of database security, compliance, and data encryption.

o Familiarity with MySQL monitoring tools (Percona, MySQL Enterprise Monitor, Zabbix, or Prometheus).

o Experience working with Linux-based MySQL environments.

• Problem-Solving & Troubleshooting:

o  Ability to analyze, debug, and resolve performance issues in large-scale databases.

o  Strong analytical skills for data optimization and scalability challenges.

• Communication & Collaboration:
• Ability to work closely with developers and DevOps teams to ensure efficient database operations.
• Strong documentation skills for database architecture, tuning best practices, and troubleshooting guides.

Nice-to-Have:

o Experience with cloud-based MySQL solutions (AWS RDS, Azure MySQL, Google Cloud SQL).

o Exposure to containerized databases using Docker and Kubernetes.

o Familiarity with CI/CD pipelines for automated database deployments.

What We Offer:

• Competitive salary and benefits package.
• Exciting opportunity to work on a global SaaS platform with large-scale data challenges.
• Collaborative and innovative work environment.
• Full-time role based in Jaipur with career growth opportunities.