Senior Database Administrator - Project Lead (SQL Server, Child Care Team)

For more details, please connect with Soumya Nayak at [email protected] or call at (919) 892-9711.

Job Title: Database Administrator – Project Lead

Duration: 12 Months

Location: Columbia, SC (Hybrid – 3 days onsite per week)

Position Type: Contract

Hours Per Week: 40 Hr

Interview Type: 1 Round – Virtual (Video Required)

End Client: State of South Carolina (DSS)

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

Department: Department of Social Services

Scope of 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.

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.

Required/Preferred Skills:

• Over 6 years of experience in Database Administration, Backup and Recovery, Performance Tuning, RDBMS, SQL Server, and T-SQL.
• 2–4 years of hands-on expertise in Failover Clusters, High Availability, DMVs, SSIS, SSRS, Profiler, SQL Tuning, and Database Planning, Scaling, and Capacity Planning.
• Skilled with SQL Server 2008R2, 2012, 2014, and 2016, with 1–2 years of version-specific experience.
• 2–4 years of advanced knowledge in ETL and SSAS.
• Strong verbal and written communication skills with 2–4 years of experience.
• 1–2 years of intermediate experience in PowerShell, RedGate Toolset, and SDLC.

V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector, Enterprise Solutions, Professional Services, Ecommerce, Projects, and Products. Within Public Sector business unit, we cater IT Professional Services to Federal, State and Local. We have multiple awards/ contracts with 30+ states, including but not limited to NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, NM, VT, and WA.

If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.

Please share my contact information with others working in Information Technology.

Website: https://www.vgroupinc.com/publicsector

LinkedIn: https://www.linkedin.com/company/v-group/

Facebook: https://www.facebook.com/VGroupIT

Twitter: https://www.twitter.com/vgroupinc