Database Administrator

Columbia, IN - USA

Monthly Salary: Not Disclosed

Posted on: 7 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Title: Database Administrator

Location: Columbia SC(3 days onsite)

Duration: 12 Months

Pay Rate: $60 to $70 hourly on W2

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 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 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 skills:

6 Years of experience in Database Administration Backup/Recovery Performance Tuning RDBMS SQL Server T-SQL.
2 Years of experience in Failover Clusters High-Availability DMVs SSIS Services SSRS Profiler SQL Tuning Database planning scaling and capacity planning ETL SSAS.
1 Years of experience in SQL Server 2008R2 SQL Server 2012 SQL Server 2014 Expert SQL Server 2016 SSAS PowerShell RedGate Toolset SDLC.

Required education:

Bachelors Degree

Job Title: Database Administrator Location: Columbia SC(3 days onsite) Duration: 12 Months Pay Rate: $60 to $70 hourly on W2 Daily Duties / Responsibilities: Primarily this position will provide senior-level support and guidance to our Child Care team including mentoring Child Care developers on...