IT - DSS - Database Administrator - Project Lead at SUNSHINE ENTERPRISE USA LLC
Job Description
Job Description
IT - DSS - Database Administrator - Project Lead
Job Description:
Position: Database Administrator
Location: Columbia, SC (Hybrid/3 days onsite per week)
Years of Exp: 08+Years
Contract Type: C2C/ W2
Duration: 12+ Months
Candidates local to South Carolina are required
Summary
We’re seeking a Senior Database Administrator to provide expert-level support for SQL Server environments, primarily assisting the Child Care team with database design, performance tuning, and security best practices. The role also involves maintaining, optimizing, and ensuring the availability of agency-wide SQL databases.
Key Responsibilities:
· Mentor developers in schema design, query optimization, and security.
· Perform SQL Server tuning, backup/recovery, and high-availability management.
· Manage upgrades, patching, and troubleshooting across multiple environments.
· Collaborate with Agile/Scrum teams and lead database initiatives end-to-end.
· Provide after-hours maintenance support when needed.
Required Skills
· 6+ years of experience as a Database Administrator (SQL Server 2008R2–2016)
· 6+ years of experience with Backup/Recovery
· 6+ years of experience with Performance Tuning
· Expertise in performance tuning, backup/recovery, and HA/DR solutions
· Strong knowledge of T-SQL, SSIS, SSRS, SSAS, and RedGate tools
· Experience with PowerShell scripting and database automation
· Excellent analytical and communication skills
Preferred Skills
· Cloud Platform experience (SQL Database)
· PowerShell Scripting and Automation
· Database planning, scaling, and capacity planning
Must Skills
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
Resume Suggestions
Highlight relevant experience and skills that match the job requirements to demonstrate your qualifications.
Quantify your achievements with specific metrics and results whenever possible to show impact.
Emphasize your proficiency in relevant technologies and tools mentioned in the job description.
Showcase your communication and collaboration skills through examples of successful projects and teamwork.