SQL DBA and System Software Programmer Consultant

Job Overview

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 system. The role is a SQL Database Administrator and Senior Developer responsible for developing applications and database integrations using Microsoft SQL Server, including reports, vendor exports, data warehousing, and other data‑related tasks.

• Take initiative in performance, working independently and with groups to effectively accomplish project objectives.
• Identify, extract, and transform required data based on business requirements and data‑governance standards.
• Perform detailed data analysis and data profiling supporting the development and implementation of data cleansing/create processes and other strategies that optimize data quality.
• Understand performance, quality, and schedule considerations, interpret complex data, and communicate it effectively using advanced reporting techniques.
• Recognize data patterns, quantify potential issues, and identify solutions.
• Standardize, harmonize, clean, prepare, and use data for datasets, development, reporting, and analysis.
• Provide support to the project team with technical specifications and building 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 the primary contact for any interface production file issues during nightly batch processes and monitor batch processes for errors.
• Act as liaison between the Child Support team and interface partners.
• Perform code, technical, and logical reviews.
• Monitor database growth trends and recommend normalization strategies and maintenance improvements for long‑term performance and scalability.
• Design, develop, and manage data analysis reports using Microsoft PowerBI.
• Serve as primary DBA for Child Support related applications.
• Participate in monitoring, oversight, and reporting on the execution of the system.
• Support contractor performance as it relates to development, daily operations, batch and online performance.
• Develop and maintain enterprise data authoritative ownership and stewardship metadata.
• Communicate and support the implementation of corporate policies, standards, and procedures that provide effective architecture, governance, and management of information data assets.
• Develop and maintain effective and efficient information architecture and data ownership awareness and training programs.
• Monitor regulatory and compliance guidelines (such as data retention and audit requirements) to determine impact on enterprise information architecture.

Role is hybrid (3 days onsite per week). Candidate must be a South Carolina resident or willing to relocate to South Carolina prior to starting the role at their own expense.

• 5+ years of experience as a SQL DBA
• 5+ years of large system architecture experience
• Large scale production system implementation experience
• Experience overseeing work of Software Development Vendors
• MS SQL Server
• TFS (Team Foundation Server)
• Microsoft Visual Studio 2022
• C#, ASP.NET, and/or .NET
• Powershell

• Experience with Child Support Enforcement system design and development
• Experience with PowerBI