Job Summary
Job Summary : 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. Implementing Backup/Restoration Strategy 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 TempDb, 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, AlwaysOn etc.)
Job Responsibilities : Good understanding of MS SQL Architecture, File groups, Partitioning, Schemas, Snapshots, Memory etc. Good knowledge of Index Management & Statistics Good exposure on SSIS, SSRS .• Good in English communication Good in ITSM Process (Incidents, Change & Problem
Job Description : Scheduling Database Backups, taking Full and Transaction Log Backups. - \\\\r\\\\n Implementing SQL Server Database Security Policy \\\\r\\\\n Experience with Database Migration, Installation, Upgrades and Patching \\\\r\\\\n Experience in T-SQL, PowerShell scripting\\\\r\\\\n Working Knowledge of Cluster \\\\r\\\\n Experience in Performance tuning (Query and Instance level)\\\\r\\\\n Good in English communication\\\\r\\\\n Good in ITSM Process (Incidents, Change & Problem
Key Responsibilities
NA
Skill Requirements
Skill Requirement : Good understanding of MS SQL Architecture, File groups, Partitioning, Schemas, Snapshots, Memory etc. Good knowledge of Index Management & Statistics Good exposure on SSIS, SSRS .• Good in English communication Good in ITSM Process (Incidents, Change & Problem
Other Requirements
Other Requirement : 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, PowerShell scripting Working Knowledge of Cluster Experience in Performance tuning (Query and Instance level) Good in English communication Good in ITSM Process (Incidents, Change & Problem)