SQL Database Administrator Project Lead

Position: SQL Database Administrator - Project Lead

Duration: 12 Months with extension

Location: Columbia SC 29201 (Hybrid (3 days onsite per week))

Special Requirement:

• Need USC or GC
• Work location: 1201 Maine Street Suite 600 Columbia SC 29201

Job Description:

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.

Responsibilities

Primarily this position will provide senior-level support and guidance to our Child Care team including mentoring Child Care developers on schema and query design execution-plan review/tuning and security best practices.

• Designs develops implements and maintains database procedures and functions that accommodate changing business priorities and technological changes while ensuring availability scalability performance recoverability reliability and security.
• Acts as liaison for SQL Server database performance integration migration upgrade storage and replication strategies.
• Performs SQL Server performance tuning: waits/Query Store analysis index & stats optimization SARGability fixes and parallelism tuning.
• Monitors the database systems to ensure secure services with minimum downtime; configures alerts and telemetry for proactive detection.
• Interacts with project management and Agile development teams to develop a strong understanding of 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.
• Performs routine operations and maintenance including installations upgrades patching monitoring auditing and issue resolution.
• Manages and prioritizes multiple diverse tasks simultaneously.
• Must be flexible independent and self-motivated.
• Work collaboratively to meet team goals/mission.
• Provides after-hours or weekend maintenance as needed.
• Perform other duties as assigned.

Required /Desired Skills:

• 6 Years Database Administration
• 6 Years Backup/Recovery
• 6 Years Performance Tuning
• 6 Years RDBMS
• 6 Years SQL Server
• 6 T-SQL
• 4 Years Failover Clusters
• 4 Years High-Availability
• 4 Years DMVs
• 4 Years SSIS Services
• 4 Years SSRS
• 4 Years Profiler
• 4 Years SQL Tuning
• 4 Years Database planning scaling and capacity planning
• 2 Years SQL Server 2008R2
• 2 Years SQL Server 2012
• 2 Years SQL Server 2014
• 2 Years SQL Server 2016
• 4 Years ETL
• 4 Years SSAS
• 4 Years Verbal Communication
• 4 Years Written Communication
• 2 Years PowerShell
• 2 Years Red Gate Toolset
• 2 Years SDLC
• 6 years of experience as a Database Administrator
• 6 years of experience with Backup/Recovery
• 6 years of experience with Performance Tuning

Preferred skills

• Cloud Platform experience (SQL Database)
• PowerShell Scripting and Automation
• Database planning scaling and capacity planning