MS SQL Server TFS ASP.Net & C# PowerShell Consultant

MS SQL Server TFS ASP.Net & C# PowerShell Consultant (Jobs in Columbia, SC) Requirement id 158176 Job title Consultant Job location in Columbia, SC Skills required SQL DBA, System Implementation, MS SQL Server, TFS ASP.Net & C# PowerShell Open Date 06-May-2026 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement

• Job interview type

•

Email Recruiter:

coolsoft

Job Description Consultant:

SQL DBA, System Implementation, MS SQL Server, TFS ASP.Net & C# PowerShell Start date :6/8/2026

End Date :

12 Months from projected start date Submission deadline :5/13 at 5:00 PM EST.

Client Info :

DSS Note:

Interview Process:

1 round, virtual

Work Location:

Role is hybrid (3 days onsite per week)

• Candidate location: Candidate MUST be a SC resident or willing to relocate to SC prior to starting the role at their own expense.

Description:

JOB DUTIES / RESPONSIBILITIES

The Department seeks a highly motivated individual who has the skills and experience of designing, developing and supporting enterprise scale web applications in the Child Support Applications group under the South Carolina Department of Social Services. This is a posting of a position to perform in the role of SQL Database Administrator and Senior Developer that is responsible for developing applications and database integrations using the Microsoft SQL Server platform. This will include reports, vendor exports, data warehousing tasks and other data related tasks. The candidate will take initiative in performance, working independently and with groups to effectively accomplish project objectives and engage in the following:

• Identifying, extracting and transforming required data based on business requirements and following data governance standards
• Performing detailed data analysis and data profiling supporting the development and implementation of data cleanse/create processes and other strategies that optimize data quality
• Understanding performance, quality, and schedule considerations
• Interpreting complex data and communicate it in an effective manner, leveraging advanced reporting techniques
• Recognizing data patterns, quantify potential issues, and identify solutions
• Standardizing, harmonizing, cleaning, preparing, and using data for datasets development, reporting, and analysis
• Providing support to the project team in terms of technical specification and build of interface objects
• Lead efforts to design, test and validate system interfaces
• Work with state (agency IT staff) and Federal partners to design, test and implement interface files and procedures for data exchange
• Inspect and correct, as necessary, interface partner files in production
• Serve as primary contact for any interface production file issues during nightly batch process, monitors batch process for errors
• Act as liaison between Child Support team and interface partners
• Perform code, technical and logical reviews
• Monitor database growth trends and recommend normalization strategies and maintenance improvements to ensure long term performance and scalability
• Design, develop and manage data analysis reports using Microsoft PowerBI platform
• Serve as primary DBA for Child Support related applications
• Participate in the monitoring, oversight and reporting on the execution of the System Development Contractors performance as it relates to development, daily operations activities including batch and online performance.
• Developing and maintaining enterprise data authoritative ownership and stewardship metadata
• Communicating and supporting the implementation of corporate policies, standards, and procedures that provide effective architecture, governance, and management of the organizations information/data assets
• Developing and maintaining effective and efficient information architecture and data ownership awareness and training programs
• Monitoring regulatory and compliance guidelines (such as data retention and audit requirements) to determine impact on enterprise information architecture

REQUIRED SKILLS

• 5+ years of experience as a SQL DBA
• 5+ years of large system architecture
• Large scale production system implementation experience
• Call502-379-4456 Ext 100for more details.

Please provide Requirement id:

158176 while calling. EOE Protected Veterans/Disability