Walk-in | Database - MSSQL

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

Job summary

Tata Consultancy Services in Chennai is seeking an experienced SQL DBA to join our data services team. You will manage complex L3 escalations, implement Always On Availability Groups, and handle failover, replication, and log shipping to ensure high availability.

You will also optimize queries, manage indexing, and perform backup/recovery strategies while guiding cloud migrations to Azure or AWS. Strong T-SQL and PowerShell scripting is required in this hands-on role.

Qualifications

• 5+ years of DBA/DBA support experience.
• Experience with HADR features: AG, failover, log shipping.
• Cloud migrations to Azure or AWS required.
• Strong scripting in T-SQL and PowerShell.
• Proficient in performance tuning and indexing.

Responsibilities

• Handle complex L3 escalation incidents, root-cause analysis, and performance bottlenecks.
• Manage Always On Availability Groups, failover clustering, replication, and log shipping.
• Performance optimize slow queries, execution plans, index management, and database statistics.
• Perform database installations, version upgrades, security patching, and cloud data migrations (e.g., to Azure or AWS).
• Write scripts using T-SQL or PowerShell to automate routine DBA and monitoring tasks.
• Advanced database administration, backup/recovery strategies, capacity planning, and SSIS/SSRS support.
• Cloud Knowledge: Familiarity with Azure SQL or AWS RDS platforms is often preferred

Skills

L3 escalation handling

Root cause analysis

Query optimization

Index management

Backup and recovery

Cloud migrations

T-SQL scripting

PowerShell scripting

Capacity planning

Performance monitoring

Tools

T-SQL

PowerShell

SSIS

SSRS

Azure SQL

AWS RDS

Job description

TCS is conducting a F2F interview on 19th September in Chennai One location.

Key Responsibilities

• Handle complex L3 escalation incidents, root-cause analysis, and performance bottlenecks.


• Manage Always On Availability Groups, failover clustering, replication, and log shipping.


• Performance Optimize slow queries, execution plans, index management, and database statistics.


• Perform database installations, version upgrades, security patching, and cloud data migrations (e.g., to Azure or AWS).


• Write scripts using T-SQL or PowerShell to automate routine DBA and monitoring tasks.


• Advanced database administration, backup/recovery strategies, capacity planning, and SSIS/SSRS support.


• Cloud Knowledge: Familiarity with Azure SQL or AWS RDS platforms is often preferred