Lead MySQL Database Engineer
On-siteBengaluru, Karnataka, India
Job Summary
Design, deploy, and manage MySQL clusters on physical, virtual, and AWS environments including RDS, Aurora, and Galera setups. Establish high availability, active-active configurations, and master-slave replication while orchestrating upgrades, backups, and disaster recovery plans. Optimize server performance through SQL tuning, hardware configuration, and capacity planning. Define monitoring and alerting strategies using tools like Datadog or PMM, and mentor engineering teams on best practices. Collaborate with application architects and stakeholders to design secure, compliant database solutions adhering to PCI standards and ITIL processes.
Required Qualifications
- Minimum 8 years of experience managing MySQL
- Experience with MySQL Active/Active cluster setup, Database Upgrade and Migrations, Scripting
- Experience administrating MySQL on Linux platform
- Experience with MySQL version upgrades in production environments with a zero or very minimum application down time
- Experience with design & architecting MySQL environments using any framework such as Galera Cluster or Percona XtraDB
- Experience deploying database monitoring using at least one of PMM, New Relic, Datadog, Nagios, Grafana, ELK, AppD, etc.
- Infrastructure as Code (IaC) such as Terraform, Ansible, Puppet, Chef
- Proficiency with cloud infrastructure, AWS RDS or equivalent
- Automation/scripting skills in a modern language like Python, Shell scripting, Go, Java, Rust
- Proficiency in CI/CD pipelines such as Jenkins, Github Actions, Gitlab
- Advanced experience with database performance tuning including SQL tuning, hardware configuration and capacity planning
- Strong technical leadership, mentoring and time management skills
Desired Qualifications
- Experience working with PCI (Payment Card Industry Data Security) standards
- ITIL environment experience
- Deep experience with SQL, stored procedures, functions, triggers, batch jobs, reporting, analytics
- Experience managing PostgreSQL, SQL Server, and/or Oracle
- Experience and knowledge with NoSQL and data engineering technologies such as Kafka, Redis, Snowflake, Databricks, Spark, Redshift, ETL, etc.
- Experience with data analytics and Business intelligence
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.