Walk-in | Tcs is Hiring For Database MS SQL DBA

Tata Consultancy Services; Chennai District; On-site; INR 900,000 - 1,400,000; Full time

Job summary

Tata Consultancy Services seeks a SQL Server DBA to administer and maintain databases across development, testing, and production environments. You will monitor health, performance, and security, and drive upgrades, patching, backups, and DR planning.

Collaborating with application, infrastructure, and cloud teams, you will implement indexing, optimize queries, and lead incident/change management to ensure continuity.

Qualifications

• Strong experience administering SQL Server databases across development, testing, and production environments.
• Proficient in monitoring health, availability, and performance of databases.
• Experience with installations, upgrades, migrations, and patching of databases.
• Knowledge of High Availability and Disaster Recovery configurations.
• Experience with backup, recovery, and restoration activities.
• Ability to diagnose and resolve performance issues, blocking, and deadlocks.
• Familiarity with indexing strategies and query optimization.
• Security management of databases, including users, roles and permissions.
• Experience handling incidents, problems and changes; documentation.
• Ability to collaborate with application, infra, and cloud teams.

Responsibilities

• Administer and maintain SQL Server databases across development, testing, and production environments.
• Monitor database health, availability, and performance.
• Perform database installation, upgrades, migrations, and patching.
• Configure and maintain High Availability and Disaster Recovery solutions.
• Manage backup, recovery, and restoration activities.
• Diagnose and resolve database performance issues, blocking, deadlocks, and resource bottlenecks.
• Implement indexing strategies and query optimization techniques.
• Manage database security, users, roles, and permissions.
• Handle incident, problem, and change management activities.
• Create and maintain operational documentation and SOPs.
• Support major incidents and ensure business continuity.
• Collaborate with application, infrastructure, and cloud teams.

Skills

Azure SQL Database / Managed Instance

AWS SQL Server Workloads

PowerShell Automation

SSIS

SSRS

SSAS

Azure DevOps and CI/CD

Oracle exposure

PostgreSQL exposure

MySQL exposure

ITIL Foundation Certification

Job description

Good-to-Have Skills

• Azure SQL Database / Managed Instance
• AWS SQL Server Workloads
• PowerShell Automation
• SSIS, SSRS, SSAS
• Azure DevOps and CI/CD
• Oracle, PostgreSQL, MySQL exposure
• ITIL Foundation Certification [EP JD SEG...MS SQL DBA | Word], [EP JD Format_SQL_DBA | Word]

Key Responsibilities

• Administer and maintain SQL Server databases across development, testing, and production environments.
• Monitor database health, availability, and performance.
• Perform database installation, upgrades, migrations, and patching.
• Configure and maintain High Availability and Disaster Recovery solutions.
• Manage backup, recovery, and restoration activities.
• Diagnose and resolve database performance issues, blocking, deadlocks, and resource bottlenecks.
• Implement indexing strategies and query optimization techniques.
• Manage database security, users, roles, and permissions.
• Handle incident, problem, and change management activities.
• Create and maintain operational documentation and SOPs.
• Support major incidents and ensure business continuity.
• Collaborate with application, infrastructure, and cloud teams.Role & responsibilities

Preferred candidate profile