Job Description
Job description
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
