Strong understanding of SQL 2017, SQL 2016 SQL 2014, SQL 2012 and SQL 2008 R2 database architecture
Experience in High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server.
Hands On in Cloud computing skills/Knowledge on AZURE/AWS
Expertise on Clustering, Always on, log shipping, mirroring, replication techniques
Experience with Performance Tuning and query Optimization
Create database and security standards for SQL Server environments
Experience working with Virtual Machines, Windows server, including Active Directory.
Experience in developing stored procedures, triggers, indexes, and views
Hands on experience in SQL Database migrations and Upgradations
Backing up and restoring databases. Should be able to design Backup & retention Policy for VLDB.
Ensuring compliance with database vendor license agreement
Basic Knowledge of SQL Licensing
Well versed with Incident, Asset, Problem and Change Management (ITIL)
Knowledge of 3rd party tools for Backup Recovery, Monitoring, Patching & performance tuning
Good written and oral communication skills
HCL America Inc.