MySQL SME

Infosys; Bengaluru; On-site; INR 1,200,000 - 1,500,000; Full time

Job summary

A leading IT service provider in Bengaluru is seeking a MySQL SME with over 8 years of experience in managing MySQL databases in production settings. The role requires expertise in performance tuning, query optimization, and strong scripting skills in Shell/Python. Responsibilities include managing high availability solutions and collaborating with development teams on schema design. This full-time opportunity provides a pathway for impactful database management while working within a dynamic IT environment.

Qualifications

• 8+ years of experience managing MySQL in production environments.
• Expertise in performance tuning, query optimization, indexing.
• Hands-on experience with high availability solutions.

Responsibilities

• Manage and optimize MySQL databases for high performance.
• Collaborate with teams to refine schema design and support application optimization.
• Automate routine DBA tasks using shell scripting or Python.

Skills

MySQL management

Performance tuning

Query optimization

Indexing

Linux/Unix proficiency

Shell/Python scripting

Database security best practices

Tools

Percona XtraBackup

Nagios

Grafana

AWS RDS

Azure MySQL

GCP

Job description

Join to apply for the MySQL SME role at Infosys

Join to apply for the MySQL SME role at Infosys

8+ years of experience managing MySQL in production environments with strong command of MySQL architecture and InnoDB. Expertise in performance tuning, query optimization, indexing, and resolving slow queries, locking, and replication issues. Hands‑on experience with high availability solutions including replication (Master–Slave, GTID, Group Replication) and clustering. Proficiency in backup & recovery tools (Percona XtraBackup, mysqldump, PITR) and strong Linux/Unix and scripting skills (Shell/Python). Familiarity with cloud databases (AWS RDS/Aurora, Azure MySQL, GCP), monitoring tools (Nagios, Zabbix, Prometheus, Grafana), and database security best practices.

Manage and optimize MySQL databases across development, testing, and production environments to ensure high performance, availability, and reliability. Design, implement, and maintain scalable MySQL architectures, including replication, clustering, and high‑availability solutions. Perform advanced performance tuning, query optimization, and indexing to improve application and database efficiency. Implement and manage robust backup and recovery strategies, including point‑in‑time recovery and disaster recovery planning. Monitor database health, diagnose replication issues, and resolve slow queries, locking, and performance bottlenecks. Collaborate closely with development and engineering teams to refine schema design, enhance queries, and support application optimization. Automate routine DBA tasks using shell scripting or Python to improve efficiency and reduce manual overhead. Manage database security through user access controls, auditing, encryption, and adherence to compliance standards. Utilize monitoring tools such as Nagios, Zabbix, Prometheus, or Grafana to track performance and proactively address issues. Support deployments and migrations across on‑prem and cloud environments (AWS RDS, Azure MySQL, GCP). Maintain clear documentation for configurations, processes, best practices, and troubleshooting guides. Stay updated on the latest MySQL features, industry best practices, and emerging database technologies.

Seniority level

• Mid‑Senior level

Employment type

• Full-time

Job function

• Other
• IT Services and IT Consulting

Referrals increase your chances of interviewing at Infosys by 2x