Track Lead

Role and responsibilities

• Should have minimum 6+Yrs experience in SQL Database Administration
• Responsible for Installation, configuration and migration of SQL server (2012, 2016, 2019 & 2022)
• Implementing new technologies and design changes whenever required.
• Applying patches/upgrades to maintain security level Requirements
• Good understanding of MS SQL Architecture, File groups, Partitioning, Schemas, Snapshots, Memory etc.
• SQL Server Database Basic Administration and exposure on Latest Features.
• Handling of day to day activities Blockings, Long running transaction, Deadlocks etc
• Troubleshoot issues related to Temp Db, Transaction Log and System Databases
• Instance/Database monitoring/configuring DB Mail/SQL Mail and Alerts & Operators
• Good knowledge of Index Management & Statistics
• Good exposure on SSIS, SSRS
• Knowledge and troubleshooting Issues related to HA (Log shipping, Mirroring,
  Always On etc.)
• Scheduling Database Backups, taking Full and Transaction Log Backups.
• Implementing SQL Server Database Security Policy
• Experience with Database Migration, Installation, Upgrades and Patching
• Experience in T-SQL, Power Shell scripting
• Working Knowledge of Cluster
• Experience in Performance tuning (Query and Instance level)
• Good in English communication
• Good in ITSM Process (Incidents, Change & Problem).