Manager of Database Administration

Responsibilities:

Lead the development of standards, processes and procedures (creating KBs, runbooks, topology) and ensuring consistency in operations
Develop operations to ensure optimal performance, availability and scalability of all critical database environments at all times
Lead the troubleshooting of any database performance or stability issues
Identify sub-optimal database architecture, design, or operational practices and lead the execution of projects to address them
Create monitoring standards and practices to ensure complete visibility of all database operations and supporting infrastructure

Bachelor's Degree in Computer Science or equivalent experience
Minimum seven years' experience supporting MSSQL server in a high availability, high transaction OLTP environment with a minimum of 5 years managing DBAs in similar environments
Excellent root cause and impact assessment skills
Adept analytical skills with the ability to conduct methodical and well-reasoned analysis of performance issues
SQL Server database engine on contemporary versions of SQL Server
Demonstrable knowledge of how it operates along with strengths and weaknesses of the design/architecture and troubleshooting core database engine and configuration issues
AlwaysOn architecture, clustering, mirroring, and transactional replication
Indexes, index management, integrity checks, configuration, partitioning
SQL Server monitoring/performance tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
SQL Development - ability to write, review and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints )
Windows server, security delegation, SPNs, storage and storage sub-systems
Experience migrating SQL Server to a big data solution is a plus