ABOUT TCS
Join Tata Consultancy Services, Asia Pacific and be part of an organization committed to sustainable development for our future. TCS follows the Tata group philosophy of building sustainable businesses that are rooted in the community and demonstrate care for the environment. Our unique values position us to combine a purpose-driven worldview with digital innovation, collaborating with customers, communities and governments to lead and shape innovative solutions for a sustainable future. TCS has been carbon neutral in its operations across 11 countries, 12 delivery center's and 18 offices in Asia Pacific since 2022. This is only the initial stage in TCS journey as we strive to achieve long-term net zero emissions by 2030.
Corporate sustainability is embedded in our triple-bottom-line, focusing on people, the planet, and our purpose. Our offices are designed with eco-friendly features that significantly reduce our carbon footprint and enhance energy efficiency. We actively champion green initiatives, such as promoting paperless operations, implementing energy-efficient practices, and fostering employee engagement in sustainability efforts. When you become part of the TCS family, you will play an essential role dedicated to innovation, excellence, and crafting a brighter, greener future together. Join us and be a part of our mission to drive sustainability through technology and talent at Tata Consultancy Services, APAC today.
Job Title: MySQL Database Administrator (MySQL DBA)
Job Summary
We are seeking an experienced MySQL Database Administrator (DBA) to manage, optimize, and support mission-critical MySQL database environments. The ideal candidate should have deep expertise in MySQL Clusters, InnoDB Cluster, MySQL Router, Group Replication, High Availability (HA), Disaster Recovery (DR), Performance Tuning, and Automation. The role involves ensuring database availability, reliability, scalability, and security across enterprise applications.
Key Responsibilities
Database Administration
- Install, configure, upgrade, and maintain MySQL Server environments.
- Manage MySQL 5.7/8.0 databases in production, staging, and development environments.
- Perform database capacity planning and storage management.
- Implement database standards, policies, and procedures.
MySQL Cluster & High Availability
- Design, implement, and support MySQL InnoDB Cluster environments.
- Configure and manage MySQL Group Replication.
- Administer MySQL Router for application connectivity and failover.
- Configure multi-node database clusters for high availability.
- Monitor cluster health and troubleshoot replication issues.
- Perform failover testing and disaster recovery drills.
Replication Management
- Configure and maintain:
- Asynchronous Replication
- Semi-Synchronous Replication
- Group Replication
- Multi-Source Replication
- Resolve replication lag and consistency issues.
- Monitor replica performance and synchronization.
Performance Tuning
- Analyze slow query logs and optimize SQL queries.
- Create and maintain indexes for performance improvements.
- Tune MySQL configuration parameters:
- Buffer Pool
- Redo Log
- Binary Logs
- Query Cache (legacy)
- Temp Tables
- Conduct database health checks and performance assessments.
Backup and Recovery
- Implement backup strategies using:
- MySQL Enterprise Backup
- Percona XtraBackup
- mysqldump
- mysqlpump
- Perform point-in-time recovery (PITR).
- Validate backup and recovery procedures periodically.
Monitoring and Troubleshooting
- Monitor database performance using:
- MySQL Enterprise Monitor
- PMM (Percona Monitoring and Management)
- Grafana
- Prometheus
- Zabbix
- Nagios
- Troubleshoot database outages and performance bottlenecks.
- Perform root cause analysis (RCA) for incidents.
Security and Compliance
- Manage database users, roles, and privileges.
- Implement SSL/TLS encryption.
- Configure auditing and security controls.
- Ensure compliance with organizational security policies.
Automation and DevOps
- Automate routine DBA tasks using Shell/Python/Bash.
- Support CI/CD deployments involving database changes.
- Collaborate with cloud and DevOps teams.
Required Technical Skills
Core MySQL Skills
- MySQL Server 5.7/8.0 Administration
- MySQL Architecture
- Database Design
- SQL Query Optimization
- Indexing Strategies
- Partitioning
MySQL Cluster Skills (Mandatory)
- MySQL InnoDB Cluster
- MySQL Group Replication
- MySQL Shell (AdminAPI)
- MySQL Router
- Single Primary Mode
- Multi Primary Mode
- Cluster Set Management
- Cluster Failover & Recovery
Replication Technologies
- Master-Slave Replication
- Master-Master Replication
- GTID Replication
- Semi-Synchronous Replication
- Multi Source Replication
Backup & Recovery
- MySQL Enterprise Backup
- Percona XtraBackup
- mysqldump
- PITR Recovery
Monitoring Tools
- PMM
- Grafana
- Prometheus
- Zabbix
- Nagios
- MySQL Enterprise Monitor
Operating Systems
- Linux Administration (RHEL, CentOS, Rocky Linux, Ubuntu)
- Shell Scripting
MySQL Router Specific Skills
Candidate should have hands-on experience in:
- Installing and configuring MySQL Router.
- Configuring MySQL Router with InnoDB Cluster.
- Managing Read/Write and Read-Only routing.
- Dynamic routing during failover.
- Router bootstrap configuration.
- Monitoring Router logs and troubleshooting connection issues.
- Load balancing database traffic.
- Integrating applications with MySQL Router endpoints.
- Understanding metadata cache and routing strategies.
