Request ID:BL-10629-1 (912191115)
Hybrid SQL Server DBA with Backup/Recovery, Tuning, T-SQL, Clusters, HA, DMV, SSIS, SSRS, Profiler, ETL, SSAS, PowerShell, RedGate experience
Location:Columbia, SC
Duration:12+ Months Hrs/Wk:40.00
Remote: 75% – for training, meetings and project. Must report onsite for the first few days to pick up computer, training.
SCDSS – Security Disclosures *MANDATORY FOR ALL DSS Requests*
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
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.
DSS – DTS Contractor Security Disclosures MANDATORY (9).docx
RTR – SoSC IT Temp Solicitation_Attachment .docx