SQL DBA / Senior Developer

Job Title: Systems Software Programmer – Advanced (SQL DBA / Senior Developer) (10123) Location: Columbia, South Carolina – Hybrid (3 days onsite per week) Duration: 12 Months Contract (Possibility of Extension) Candidate Location Requirement: Candidate must currently be a South Carolina resident or willing to relocate to South Carolina before the start date at their own expense. Job Description The selected candidate will function as a SQL Database Administrator and Senior Developer, responsible for developing enterprise-scale web applications and managing database integrations using the Microsoft SQL Server platform. Key Responsibilities Design, develop, and support enterprise-scale web applications for Child Support Services systems • Perform SQL Server database administration, development, and integration tasks • Extract, transform, and analyze data based on business requirements and data governance standards • Conduct data profiling and analysis to support data cleansing and data quality improvement initiatives • Design, develop, and maintain reports, vendor exports, and data warehousing processes • Standardize, harmonize, clean, and prepare datasets for reporting and analytics • Lead efforts to design, test, and validate system interfaces and data exchange processes • Work with State IT staff and Federal partners to implement interface files and procedures • Monitor nightly batch processing jobs and troubleshoot interface file issues • Perform code reviews, technical reviews, and logical reviews for development work • Monitor database growth trends and recommend performance optimization strategies • Serve as the primary DBA for Child Support applications and ensure database performance and scalability • Design and develop data analytics reports using Microsoft Power BI • Oversee vendor development work and monitor contractor performance related to system development and operations • Ensure compliance with data governance policies, data retention requirements, and audit standards • Provide technical guidance to the development team and support enterprise information architecture initiatives Required Skills 5+ years of experience as a SQL Database Administrator (SQL DBA) • 5+ years of experience in large system architecture • Experience implementing large-scale production systems • Experience overseeing work performed by software development vendors • Strong experience with Microsoft SQL Server • Experience using TFS (Team Foundation Server) • Experience with Microsoft Visual Studio 2022 • Development experience using C#, ASP.NET, and/or .NET • Experience with PowerShell scripting Preferred Skills Experience with Child Support Enforcement system design and development • Experience using Microsoft Power BI Education Bachelor’s Degree or equivalent professional experience Technology Environment Microsoft SQL Server 2022 Enterprise Server • SQL Server Reporting Services (SSRS) • Team Foundation Server (TFS) • Microsoft Visual Studio 2022 • C#, ASP.NET, .NET • PowerShell • Microsoft Power BI