Microsoft SQL Server 2019
TCS
4 - 6 years
Chennai
Posted: 11/05/2025
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
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).