We are looking for a highly skilled and experienced MySQL Database Administrator (DBA) to join our team at Tata Consultancy Services (TCS) in Delhi. The ideal candidate will possess strong expertise in MySQL architecture, administration, performance optimization, and troubleshooting, along with a deep understanding of database management tasks and Linux systems.
Key Responsibilities
- MySQL Database Administration. Manage, maintain, and optimize MySQL databases. This includes overseeing performance tuning, user management, backups, and replication.
- Performance Optimization. Enhance MySQL database performance by identifying and resolving bottlenecks and inefficiencies.
- Replication and Backup. Implement and manage replication, perform database backups and restores, ensuring data integrity and availability.
- Linux Systems Administration. Expertise in Linux implementation, maintenance, and troubleshooting, including the use of Unix shell scripting for automation of tasks.
- Migration and Upgrades. Plan and execute MySQL database migrations and upgrades, tuning the operating system and storage for optimized database performance.
- Automation. Develop and implement automation processes to reduce manual administrative tasks, using tools such as jobs, PowerShell scripts, etc.
- Troubleshooting and Testing. Diagnose and resolve complex issues related to MySQL databases, ensuring minimal downtime and operational continuity.
- Complex Database Environments. Handle highly complex database environments, manage change control, and ensure systems are compliant with industry standards and regulations.
- Collaboration. Work closely with cross-functional teams to address database-related challenges, ensure smooth operations, and support system improvements.
Required Skills & Experience
- MySQL Expertise. In-depth knowledge of MySQL architecture, administration tasks, performance optimization, and replication.
- Backup & Recovery. Proficiency in backup tools such as xtrabackup, mysqldump, and file snap restore methodologies.
- Linux Systems. Strong experience with Linux systems, including implementation, maintenance, and advanced shell scripting.
- Performance Tuning & SQL. Strong SQL coding skills and experience in optimizing and tuning large MySQL databases.
- Migration & Upgrade Planning. Experience in planning and executing migrations and upgrades while optimizing operating systems and storage.
- Troubleshooting. Ability to identify, diagnose, and resolve performance issues or database-related challenges.
- Automation. Ability to implement automation using scripting or tools to reduce manual database administration tasks.
- Change Control & Validation. Experience working in controlled environments with strict change management procedures.
- Problem-Solving. Excellent analytical and problem-solving skills, with the ability to think critically and resolve complex issues.
Desired Skills
- Experience with complex MySQL environments and high-availability setups.
- Familiarity with additional database management tools and techniques.
- Effective communication and collaboration skills to work with various teams.
Certifications
- Relevant certifications in MySQL, Linux, or Database Administration will be an added advantage.
This job description reflects the detailed technical skills and responsibilities required for the MySQL Database Administrator role at TCS. It focuses on performance optimization, advanced troubleshooting, and experience in complex environments, along with a strong emphasis on Linux system administration and automation.