Role: MySQL Database Administrator
Job Type: Permanent
Location: Sheffield, UK
Number of hours: 40 hours per week – full time
Ready to utilize your experience and expertise in MySQL Database Administration?
We have an exciting role for you - MySQL Database Administrator!
Careers at TCS: It means more
TCS is a purpose-led transformation company, built on belief. We do not just help businesses to transform through technology. We support them in making a meaningful difference to the people and communities they serve - our clients include some of the biggest brands in the UK and worldwide. For you, it means more to make an impact that matters, through challenging projects which demand ambitious innovation and thought leadership.
The Role
As MySQL Database Administrator (DBA), you are responsible for the performance, integrity, and security of MySQL databases.
Key responsibilities:
- Installation & Configuration: Set up, configure, and maintain MySQL database servers across various environments (On-prem, Linux, Windows, or Cloud like AWS RDS).
- Performance Tuning: Monitor system health and perform query optimization, slow query analysis, and indexing strategies to ensure high efficiency.
- Backup & Recovery: Design and implement robust backup and restoration strategies to ensure 24x7 operation support and business continuity.
- Security Management: Manage user access, permissions, and data encryption to ensure compliance with data protection regulations.
- High Availability: Implement and manage MySQL replication (Master-Slave/Master-Master) and disaster recovery solutions.
- Database Design: Collaborate with developers on schema design, table structures, and capacity planning
Your Profile:
Key skills/knowledge/experience:
- Proficiency in MySQL: Deep understanding of storage engines (InnoDB, MyISAM), MySQL 8.0 features, and partitioning.
- Tools: Expertise in MySQL Workbench, Percona XtraBackup, and monitoring tools like Prometheus or Grafana.
- Operating Systems: Strong command of Linux/Unix environments and shell scripting (Bash/Python) for task automation.
- Cloud Platforms: Experience with managed database services on Google Cloud SQL or Azure
- Certification: Industry-recognized certifications like Oracle Certified Professional, MySQL Database Administrator are highly preferred.