Microsoft SQL Server 2019

TCS

4 - 6 years

Chennai

Posted: 11/05/2025

Job Description

Job Description

Role: Microsoft SQL Server 2019
Exp : 4 To 6 yrs
Location : Chennai 

Job Description

MSSQL DBA & AWS RDS Database Requirement

Certifications & Skills:

ITIL Certified

SQL Server Database Administration (Versions 2012, 2014, 2016, 2019)

Hands-on experience with Azure Foundational Services, Data Management Services (Optional), and Cloud Awareness

PowerShell, Shell Scripting, Python (Optional)

Responsibilities:

MSSQL DBA (L2 Level):

End-to-end Physical Database Administration duties

Backup & Restore Management

Database Lifecycle Management (SQL Server Build, Version Upgrades, Patch Management, Decommissioning Activities)

Experience in writing T-SQL (Stored Procedures, Views, Tables, Triggers, User-Defined Functions)

Hands-on experience with business continuity solutions such as Log Shipping, Database Mirroring, and SQL Always-On

Support Disaster Recovery (DR) Drills

Database Migrations (On-Premise, Azure Cloud)

Database Maintenance (Index Management, Statistics Management, Database Refresh, Cloning)

SQL Server Agent Management

Experience in handling performance issues related to capacity management, performance tuning (Locking, Blocking, Deadlocks)

Trend Analysis, Reporting & Auditing

Security Implementation: Database Encryption (TDE / Always-Encrypted), Role-Based Access Control, Linked Servers

AWS RDS (L1 Level):

Basic administration of AWS RDS instances (SQL Server, MySQL, PostgreSQL)

Monitoring and handling basic performance issues

Assisting in backups and snapshot management

Managing parameter groups and security groups

Assisting with failover testing and minor troubleshooting

Basic user and role management in RDS

Understanding of RDS maintenance tasks, including minor version upgrades and patches

Coordinating with senior team members for major RDS-related issues

Location
Chennai
Job Function
TECHNOLOGY
Role
Database Administrator
Job Id
360361
Desired Skills
Microsoft SQL Server 2016
Desired Candidate Profile
Qualifications : BACHELOR OF ENGINEERING

About Company

Tata Consultancy Services (TCS) is one of the largest multinational IT services and consulting companies in the world, headquartered in Mumbai, India. It operates in over 50 countries and is a part of the Tata Group, India's largest business conglomerate. TCS offers a wide range of services including software development, consulting, digital transformation, and business solutions, serving industries such as finance, healthcare, retail, and telecommunications. Known for its global reach, technological expertise, and innovation, TCS is consistently ranked among the top IT services companies globally.

Services you might be interested in

One-Shot Campaign

Reach out to ideal employees in one shot!

The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).