Job description
Job Title: Database Administrator - Project Lead (Hybrid)
Location: Columbia, SC
Duration: 12 Months
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.
Daily Duties / 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.
In addition to this, this position will assist (at a senior-level) with the support, maintenance, security, and availability of the agency’s SQL Server environment for other application teams, while prioritizing Child Care commitments.
- 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, SARG ability 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 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 Services 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
- ETL Advanced 2-4 Years
- SSAS Advanced 2-4 Years
- Verbal Communication Intermediate 2-4 Years
- Written Communication Intermediate 2-4 Years
- PowerShell Intermediate 1-2 Years
- RedGate Toolset Intermediate 1-2 Years
- SDLC Intermediate 1-2 Years
Required Education:
- Bachelor’s Degree
