Systems Software Programmer Advanced
Posted
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
About US: InterSources Inc. is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.
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
About US: InterSources Inc. is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.
