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 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 YearsRequired Education :
Bachelors DegreeKey Skills
Databases,Disaster Recovery,SQL,High Availability,Microsoft SQL Server,ssrs,Database Design,Performance Tuning,SSIS,Database Administration,Sybase,Oracle
Employment Type : Full Time
Experience : years
Vacancy : 1