• 3 years of experience in database development and support in MS SQL Server environments.
• Experience in install and configuring in SQL Server ( 2005, 2008, 2012, 2014 & 2016 )
• Strong experience in Database Administration in SQL Server ( 2005, 2008, 2012, 2014 & 2016 )
• Experience on AG, Clustering, Database mirroring, Replication and log shipping configuring and troubleshoot issues.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Experience in SQL server hardening and SQL audit policy.
• Knowledge in SQL user/login permissions and privileges.
• Ability in monthly log review for privileged DB accounts.
• Knowledge and experience in TDE (transparent data encryption)
• 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
• Strong knowledge of indexes, index management, integrity checks, configuration, patching and upgrade.
• Knowledge of SQL Server tools ( Profiler, DTA, SSMS, DAC)
• SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
• Solid acquaintance with windows server, security delegation, SPNs, storage components.
• Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc. )
• SQL Database Operational support to tech users