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 agencys 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:
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-lev...
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 agencys 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:
View more
View less