Sql Database Administrator

Tata Consultancy Services; New Delhi; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Tata Consultancy Services in Delhi seeks an experienced SQL Database Administrator to design, implement and manage high-availability MySQL databases in production environments. You will handle backups, restores and performance tuning for optimal data integrity and throughput.

Required is 6+ years of relevant experience, with expertise in replication, GTID, group replication, DR drills, Linux file systems, LVM and cloud/virtualization technologies. Strong scripting for automation is essential.

Qualifications

• 6+ years of experience in SQL database administration.
• Expertise in installing, supporting and managing High availability MySQL Database in Production.
• Backup, Archival and Restoration of MySQL Database.
• OS and Database performance Tuning and Optimization.
• MySQL Replication Setup, Group Replication , GTID and Troubleshooting. Setup High-availability and DR Setup.
• Experience in DR Drill activities.
• Knowledge on Linux file systems & LVM.
• Cloud Environment and Virtualization Technologies.
• Automation of routine jobs using shell scripting.

Responsibilities

• Install, support and manage high-availability MySQL databases in production.
• Perform backup, archival and restoration of databases.
• Tune OS and database performance for optimal throughput.
• Configure replication and DR setups including GTID and group replication.
• Participate in DR drills and storage, security and user management tasks.
• Leverage shell scripting to automate routine jobs.

Skills

MySQL

High availability

Performance tuning

Shell scripting

Linux

Cloud

DB replication

Data migration

Job description

Role : SQL Database Administration

Experience : 6+ years

Location : Delhi

• Expertise in installing, supporting and managing High availability MySQL Database in Production.
• Backup, Archival and Restoration of MySQL Database.
• OS and Database performance Tuning and Optimization.
• MySQL Replication Setup, Group Replication , GTID and Troubleshooting. Setup High-availability and DR Setup.
• Experience in DR Drill activities.
• Store Procedures, triggers and Function ,Partition.
• Data Migration
• Good to have knowledge on Different database domain (Oracle, PostgreSQL , MongoDB)
• knowledge Linux file systems & LVM
• Cloud Environment and Virtualization Technologies
• performance tuning, storage management, user management, and security management.
• Expertise in automating routine jobs using shell / Perl scripting