Primary Skills: SQL
Develop operational policies, procedures, controls and standards
Develop, implement and maintain automation efficiencies using scripting languages (T-SQL, Powershell) in a Windows environment
Develop and maintain implementation guides and maintenance processes and documentation
Database software certifications, roadmap planning and maintenance management
Perform database environment capacity planning and availability management
Collaborate with partners to resolve company database policy compliance and vulnerability violations
Provide 24x7 on-call support for complex production problems to include experience with escalation and communication of the problem to senior management
Consult with and advise senior management on high impact database solutions and database management topics
Consults extensively with multiple groups, to lead initiatives that could have enterprise impact
Provide oversight, mentoring, and leadership to less experienced staff
Leads the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases.
Consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction.
Handles and leads various large-scale or highly complex data/database management activities including one or more of the following:
Designing highly complex logical and/or physical databases in SQL Server;
Leading highly complex data modeling, mapping, integration, and capacity planning efforts;
Developing management policies, procedures and standards; and
Gathers business requirements identification, analysis and development.
7+ year’s database design and administration experience
A BS/BA degree or higher in information technology
7+ years of experience with SQL Server 2008 thru 2016.
7+ years of experience with SQL Server technologies (clustering, AlwaysOn, partitioning, security, performance tuning, memory management, SQL tuning, statistics gathering, application audit logs, scheduling, etc.
7+ years of experience in utilizing performance-tuning tools like explain plans, index management, or similar technologies. Understand and interpret the reports generated from tools and resolve performance issues.
7+ years of experience in backup and recovery, application patching, cloning, maintenance and problem solving within the SQL Server environment.
5+ years of experience in leading and supporting upgrade activities within the SQL Server 2005 or greater environment.
5+ years of experience with Med (500GB) to Large (5 TB) sized databases
5+ years of operating under a highly structured change management protocols and processes
Proven ability to troubleshoot and trace data related issues throughout the architecture
Demonstrated ability to quickly learn, retain, and apply good interpersonal skills, and perform effectively under time pressure are critical skills required for this position
Excellent verbal and written communication
Must be strong in analyzing how SQL Server resources are being used during SQL executions.
Ability to write and maintain high quality documentation
Proven ability to build and maintain strong working relationships with business partners
3+ years of experience with monitoring tools such as SCOM
2+ years of experience with transactional, merge, and snapshot replication technologies
2+ years of experience with Transparent Data Encryption (TDE)
Familiarity and experience operating in an enterprise environment using formal procedures and policies required for escalation and outage resolution.