Has 5+ years of experience in database development and support in MS SQL Server environments.
SQL Development – ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints).
Strong experience in Database Administration in SQL Server
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Experience in implementing operational automation.
Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of SQL Server tools (Profiler, DTA, SSMS, PerfMon, DMVs, system SPs).
Knowledge of windows server, security delegation, SPNs, storage components.
Documentation skills for processes and procedures and SQL documentation
Ability to give rapid SQL database operational support to tech users
Knowledge of differences and limitations of different versions of SQL Server from 2014 onwards.