Senior SQL Database Administrator

Job Description: 75% - for training, meetings and project. Must report onsite for the first few days to pick up computer, training.

SCOPE OF THE PROJECT:
This request is for a senior-level database administrator to: 1) Provide senior-level support and guidance to our Child Care team for several initiatives; 2) Assist (at a senior-level) with the support, maintenance, security, and availability of our SQL environment.

DAILY DUTIES / RESPONSIBILITIES:
Primarily, this position will provide senior-level support and guidance to our Child Care team.

In addition to this, this position will assist (at a senior-level) with the support, maintenance, security, and availability of our SQL environment.

Designs, develops, implements, and maintains database, procedures, and functions that accommodate changing business priorities and technological changes while providing availability, scalability, performance, recoverability, reliability, and security.
Acts as liaison for SQL Server DB performance, integration, migration, upgrade, storage, and replication strategies.
Focuses on Performance Tuning of database instance across various applications/systems, to include indexing and optimizer strategies, stored procedures/triggers, partitioning, locking schemes, temporary spaces/sort area, and memory management.
Monitors the database systems to ensure secure services with minimum downtime.
Interacts with project management and Agile development teams to develop a strong understanding of the project and database development objectives.
Participates in troubleshooting and triaging of issues with different team members to drive towards root cause identification and resolution.
Documents, tracks and escalates issues as appropriate.
Participates in Scrum teams in support of Agile projects; end-to-end support for build, deployment, and operational activities.
Exercises considerable latitude, discretion, and independent judgment in determining technical objectives of assignments.
Routine operation maintenance including installations, upgrades, patching, monitoring, auditing, issue resolution.
Manage and prioritize multiple, diverse tasks simultaneously.
Must be flexible, independent and self-motivated.
Work collaboratively to meet team goals/mission.
Provide after-hours or weekend maintenance as needed.
Perform other duties as assigned.

REQUIRED SKILLS:
Database Administration Expert 6+ Years
Backup/Recovery Expert 6+ Years
Performance Tuning Expert 6+ Years
RDBMS Expert 6+ Years
SQL Server Expert 6+ Years
T-SQL Expert 6+ Years
Failover Clusters Expert 2-4 Years
High-Availability Expert 2-4 Years
DMVs Expert 2-4 Years
SSIS Expert 2-4 Years
SSRS Expert 2-4 Years
Profiler Expert 2-4 Years
SQL Tuning Expert 2-4 Years
Database planning, scaling, and capacity planning Expert 2-4 Years
SQL Server 2008R2 Expert 1-2 Years
SQL Server 2012 Expert 1-2 Years
SQL Server 2014 Expert 1-2 Years
SQL Server 2016 Expert 1-2 Years
SQL Server 2019 Expert 1-2 Years
ETL Advanced 2-4 Years
SSAS Advanced 2-4 Years
Verbal Communication Advanced 2-4 Years
Written Communication Advanced 2-4 Years
PowerShell Intermediate 1-2 Years
RedGate Toolset Intermediate 1-2 Years
SDLC Intermediate 1-2 Years

REQUIRED EDUCATION:
Bachelor's Degree or years of expereince
Additional Sills: Database Administration Expert 6+ YearsBackup/Recovery Expert 6+ YearsPerformance Tuning Expert 6+ YearsRDBMS Expert 6+ YearsSQL Server Expert 6+ YearsT-SQL Expert 6+ YearsFailover Clusters Expert 2-4 YearsHigh-Availability Expert 2-4 YearsDMVs Expert 2-4 YearsSSIS Services Expert 2-4 YearsSSRS Expert 2-4 YearsProfiler Expert 2-4 YearsSQL Tuning Expert 2-4 YearsDatabase planning, scaling, and capacity planning Expert 2-4 YearsSQL Server 2008R2 Expert 1-2 YearsSQL Server 2012 Expert 1-2 YearsSQL Server 2014 Expert 1-2 YearsSQL Server 2016 Expert 1-2 YearsETL Advanced 2-4 YearsSSAS Advanced 2-4 YearsVerbal Communication Intermediate 2-4 YearsWritten Communication Intermediate 2-4 YearsPowerShell Intermediate 1-2 YearsRedGate Toolset Intermediate 1-2 YearsSDLC Intermediate 1-2 Years