Database Administrator

AdientOne LLC Logo
AdientOne LLC
Columbia, SC, United States
  • Software
  • FlexTime
  • Weekends
  • Applications have closed

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

  • Bachelor’s Degree
Apply for job