MY SQL DBA

Tata Consultancy Services; Mumbai City; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading company in the technology sector is hiring a MySQL DBA. The role involves managing MySQL databases, ensuring performance optimization, and implementing security measures. Candidates should have 5-12 years of experience and a strong technical background.

Qualifications

• 5-12 years of experience required.
• Mid-Senior level position.

Responsibilities

• Install, configure, and manage MySQL/MariaDB instances.
• Implement and monitor backups for disaster recovery.
• Analyze and optimize slow queries.

Skills

Database Administration

Backup & Recovery

Performance Tuning & Optimization

High Availability & Replication

Security & Compliance

Troubleshooting & Issue Resolution

Automation & Scripting

Database Design & Capacity Planning

Patch Management & Upgrades

Cloud & Hybrid Management

Job description

Get AI-powered advice on this job and more exclusive features.

TCS has been a pioneer in nurturing young tech talent. We are a global leader in the technology sector, committed to growth and innovation.

We are Hiring for MY SQL DBA

Job Description

Experience: 5-12 years

Required Skills and Responsibilities

• Database Administration: Install, configure, and manage MySQL/MariaDB instances across production, staging, and development environments.
• Backup & Recovery: Implement and monitor mysqldump, Percona XtraBackup, and binary log backups for disaster recovery.
• Performance Tuning & Optimization: Analyze slow queries using EXPLAIN, Performance Schema, and Query Profiling; optimize indexes and configurations.
• High Availability & Replication: Configure and manage Master-Slave, Master-Master, Group Replication setups.
• Security & Compliance: Enforce user access controls, SSL encryption, auditing, and GDPR compliance.
• Troubleshooting & Issue Resolution: Address deadlocks, replication lag, crashes, and performance issues.
• Automation & Scripting: Develop scripts for automating backup, monitoring, and maintenance tasks.
• Database Design & Capacity Planning: Support schema design, data partitioning, and resource scaling based on workload patterns.
• Patch Management & Upgrades: Apply patches, version upgrades, and security fixes with minimal downtime.
• Cloud & Hybrid Management: Administer MySQL databases in various environments.

Other details include educational requirements, company registration encouragement, and data privacy notices.

Additional Job Details

• Seniority Level: Mid-Senior level
• Employment Type: Full-time
• Job Function: Information Technology
• Industry: IT Services and Consulting

Referrals can double your chances of interview success. Notifications about similar jobs in Mumbai, Maharashtra, India, are available.