Sr Database Administrator

US Tech Solutions; Columbia (SC); Hybrid; USD 100,000 - 130,000; Full time

Job summary

A leading tech solutions company is seeking a senior database administrator in Columbia, SC. You will provide guidance to the Child Care team on SQL maintenance and development best practices, while also mentoring developers. Candidates must possess a bachelor’s degree and at least 6 years of expertise in database administration, backup/recovery, and performance tuning. This role offers a hybrid work environment with a focus on collaboration.

Qualifications

• 6+ years of experience in database administration.
• 6+ years of expertise in backup/recovery processes.
• 6+ years experience in performance tuning.

Responsibilities

• Provide senior-level support and guidance to the Child Care team.
• Assist with support, maintenance, and security of SQL environments.
• Mentor developers on schema and query design.

Skills

Database Administration Expert

Backup/Recovery Expert

Performance Tuning Expert

RDBMS Expert

SQL Server Expert

T-SQL Expert

Failover Clusters Expert

High-Availability Expert

DMVs Expert

SSIS Services Expert

SSRS Expert

Profiler Expert

SQL Tuning Expert

Database planning, scaling, and capacity planning Expert

SQL Server 2008R2 Expert

SQL Server 2012 Expert

SQL Server 2014 Expert

SQL Server 2016 Expert

ETL Advanced

SSAS Advanced

Verbal Communication

Written Communication

PowerShell

RedGate Toolset

SDLC

Education

Bachelor’s degree

Job description

Duration : 12+ Months Contract

Location : Hybrid (3 days onsite per week & 2 days remote- Columbia SC 29201)

Candidate location: Candidate must be a CURRENT SC resident.

Job Description

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

• 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 www.ustechsolutions.com (http://www.ustechsolutionsinc.com) .

US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.