Senior SQL Database Administrator

Job Description

Senior SQL Database Administrator Jaipur, Rajasthan 6 years experience Full-Time Senior SQL Database Administrator Required Experience Minimum : 6 years Maximum : 10 years Job Description 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. Job Responsibility 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.