Sr Database Administrator

Overview

Hybrid
$73.33 - $75.86
Contract - W2
Contract - 12 Month(s)

Skills

SQL
Database
Microsoft SQL Server
Migration
Performance Tuning
Scrum
Issue Resolution
Agile
ROOT
Scalability
Statistics

Job Details

Location: Hybrid (3 days onsite per week & 2 days remote- Columbia SC 29201) Duration: 12 months contract (with possible extension)
Candidate location:
Candidate must be a CURRENT SC resident. No relocation allowed.
Scope of the Project:
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, 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 (rank in order of importance):

Database AdministrationExpert6+ Years
Backup/RecoveryExpert6+ Years
Performance TuningExpert6+ Years
RDBMSExpert6+ Years
SQL ServerExpert6+ Years
T-SQLExpert6+ Years
Failover ClustersExpert2-4 Years
High-AvailabilityExpert2-4 Years
DMVsExpert2-4 Years
SSIS ServicesExpert2-4 Years
SSRSExpert2-4 Years
ProfilerExpert2-4 Years
SQL TuningExpert2-4 Years
Database planning, scaling, and capacity planningExpert2-4 Years
SQL Server 2008R2Expert1-2 Years
SQL Server 2012Expert1-2 Years
SQL Server 2014Expert1-2 Years
SQL Server 2016Expert1-2 Years
ETLAdvanced2-4 Years
SSASAdvanced2-4 Years
Verbal CommunicationIntermediate2-4 Years
Written CommunicationIntermediate2-4 Years
PowerShellIntermediate1-2 Years
RedGate ToolsetIntermediate1-2 Years
SDLCIntermediate1-2 Years

Required education:
Bachelor's degree.
About US Tech Solutions:
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit .
US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.