Job Description :
Has 8+ years of experience in database development and support in MS SQL Server environments.
· Strong experience in Database Administration in SQL Server ( 2012, 2014, 2016)
· 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.
· 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.
· Expert 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, SSIS, SSRS, SAC, SSCM, PerfMon, DMVs, system sprocs)
· 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 runbooks, topology, etc )
· SQL Database Operational support to tech users
· SQL Clustering HA, Active-Active, Active-Passive, Always-On (2012, 2014, 2016)
· Ability to mentor and guide other SQL DBA’s in database administration tasks, procedures, and duties
· Ability to help guide the technology/decision path for operating MS SQL in an Enterprise environment.
Preferred candidates would also meet the following criteria:
· Solid acquaintance with windows server, security delegation, SPNs, storage components.
· Documentation skills for processes and procedures.
· Knowledge of 3rd party DBA tools and applications ( e.g RedGate, SpotLight, LightSpeed, SCOM )
· MCDBA / MCT certification
· Experience in Database Administration in SQL Server ( 2008, 2012, 2014, 2016 )
Knowledge in a scripting / programming language.