Database Administrator

Database Administrator – Project Lead [8660]

Type: Contract W2

Duration: 12 months (possibility of extension)

Location: Hybrid (3 days onsite per week)

Candidate Requirement: Must be a current South Carolina resident ( no relocation allowed )

Interview Process: 1 round, virtual (video required)

We are seeking a senior-level Database Administrator – Project Lead to provide advanced support and guidance for multiple initiatives, with a primary focus on Child Care systems. This role involves mentoring developers, optimizing database performance, and ensuring the security, availability, and reliability of SQL Server environments.

The ideal candidate will be highly experienced in SQL Server administration, performance tuning, and high-availability solutions, while also demonstrating strong leadership and collaboration skills.

Responsibilities

• Provide senior-level support and mentoring to development teams on schema design, query optimization, execution plan tuning, and security best practices.

• Design, develop, implement, and maintain databases, procedures, and functions to meet evolving business needs.

• Act as liaison for SQL Server performance, integration, migration, upgrade, storage, and replication strategies.

• Perform SQL Server performance tuning (Query Store analysis, index optimization, parallelism tuning, etc.).

• Monitor database systems for availability, security, and minimal downtime; configure alerts and telemetry for proactive detection.

• Collaborate with project management and Agile teams to align database objectives with project goals.

• Troubleshoot and resolve issues, documenting and escalating as needed.

• Participate in Scrum teams, supporting build, deployment, and operational activities.

• Perform routine operations including installations, upgrades, patching, monitoring, and auditing.

• Manage and prioritize multiple tasks simultaneously with independence and flexibility.

• Provide after-hours or weekend maintenance as required.

• Required Skills & Experience

• Database Administration: Expert, 6+ years

• Backup/Recovery: Expert, 6+ years

• Performance Tuning: Expert, 6+ years

• RDBMS & SQL Server: Expert, 6+ years

• T-SQL: Expert, 6+ years

• Failover Clusters & High Availability: Expert, 2–4 years

• DMVs, SSIS, SSRS, Profiler, SQL Tuning: Expert, 2–4 years

• Database Planning, Scaling, Capacity Planning: Expert, 2–4 years

• SQL Server Versions (2008R2–2016): Expert, 1–2 years each

• Education: Bachelor's Degree

• Preferred Skills

• ETL Development: Advanced, 2–4 years

• SSAS: Advanced, 2–4 years

• PowerShell: Intermediate, 1–2 years

• RedGate Toolset: Intermediate, 1–2 years

• SDLC Knowledge: Intermediate, 1–2 years

• Verbal & Written Communication: Intermediate, 2–4 years