Job DescriptionInterview Mode : Virtual mode

NRole: MS SQL DBA

NExperience: 8 to 10 Years

NLocation: Kolkata, Bangalore, Chennai

NMust-Have:

N

n
4+ years of solid experience as a Seniors/Lead SQL Server DBA in a production(Cluster & Standalone) environment.
N
Valuable knowledge of SQL Server 2012, 2014, 2016, 2017, and 2019 versions.
N
Good understanding of Install, configure, and maintain SQL Server instances on-premises.
N
Design, develop, and maintain databases, tables, indexes, views, stored procedures, and other database objects.
N
Optimize database performance by tuning queries, indexes, and server configurations.
N
Scripting Knowledge specially on T-SQL & PowerShell will be added advantage.
N
Strong command of SQL Migration On-prem to On-prem, On-Prem to Cloud services (AWS/AZURE IAAS/PAAS).
N
Robust understanding ofdatabase backup and recovery, disaster recovery, and high availability solutions.



Ensure database availability and disaster recovery by implementing backup and recovery plans and performing regular backups and restores.
N
Configure, manage & troubleshoot issue related to Replication(Snapshot & Transactional replication).
N
Configure, manage & troubleshoot issue related to High availability technique like Always-On Availability technology.
N
Robust knowledge in database security by managing user access, permissions, and authentication.
N
Identify and resolve database-related issues and incidents by troubleshooting problems and performing root cause analysis.
N
Collaborate with cross-functional teams to support application development and deployment.
N

nGood to have:

NBasic/advance Knowledge in Snowflakes will be added advantage but not mandatory.

📌 Hiring: Ms Sql Dba Bengaluru
🏢 Tata Consultancy Services
📍 Bengaluru