Intersources inc

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

Job Title: Systems Software Programmer - Project Lead (10122) Duration: 12 Months (Possibility of Extension) Interview Process: 1 Round - Virtual Work Location: Remote (May become fully onsite at Columbia, SC 29201 without notice) Relocation: Candidates must be willing to relocate to South Carolina immediately if required Position Overview The Child and Adult Protective Services Applications Team, part of DSS Human Services Division (HSD), is seeking a highly motivated Systems Software Programmer - Project Lead to design, develop, and support enterprise-scale web applications built on the Microsoft .NET platform. The team is responsible for supporting critical child welfare systems including: Child and Adult Protective Services System (CAPSS) Child and Adult Information Portal (CAIP) Human Services Portal (HSP) This role requires strong hands-on technical leadership and experience building secure, scalable, N-tier web applications in a Microsoft enterprise environment. Key Responsibilities Design, develop, and maintain enterprise-level web applications using Microsoft .NET technologies. Develop visual interfaces, application logic, database components, and web services. Build and deploy scalable, secure, data-driven web applications. Review and improve existing system designs and code quality. Design and document subsystems and components using object-oriented principles. Implement and debug application components and services. Write and execute unit tests and participate in system integration testing. Collaborate with engineers and technical leads to refine system architecture. Support source control, build management, deployment processes, and CI/CD pipelines. Provide technical leadership and oversight for infrastructure and monitoring scripts. Work independently and collaboratively to meet project objectives. Required Skills & Experience 7+ years of experience designing and implementing medium to large-scale systems using Microsoft .NET architecture. 5+ years of experience developing data-driven applications using relational database engines. 5+ years of experience building and deploying web-based systems utilizing: N-tier architecture Dynamic content Highly scalable approaches Complex security implementations 3+ years of experience with Angular Framework (Version 15+). Strong experience with: C#, VB.NET, ASP.NET, ASP.NET Core ASP.NET MVC 4 or higher Entity Framework 6+ WCF jQuery and JavaScript (ES6+) RxJS (Observables, Subjects, Operators) Angular CLI (Project scaffolding and management) Responsive design principles MS SQL Server 2016/2019 (8+ years) SQL Server Reporting Services (SSRS) Azure DevOps (3+ years) Microsoft Visual Studio 2019/2022 Experience with source code management and build management tools. Preferred Skills Experience working in Agile environments. Experience with performance, security, and regression testing tools. PowerShell scripting (2+ years). Windows Server 2016/2019 administration (IIS, Active Directory). Experience supporting child welfare or public sector systems (strongly preferred). Required Education Bachelor's Degree in Computer Science, Information Technology, or related field OR equivalent work experience.