Systems Software Programmer - Advanced

• Serve as SQL Database Administrator and Senior Developer for enterprise Child Support applications
• Design, develop, and maintain applications and database integrations using Microsoft SQL Server
• Develop reports, vendor exports, and support data warehousing initiatives
• Perform data extraction, transformation, profiling, cleansing, and analysis
• Lead interface design, testing, validation, and implementation activities
• Coordinate with State IT staff and Federal partners for data exchange procedures
• Monitor and troubleshoot nightly batch processing and production interface issues
• Conduct code reviews, technical reviews, and logical reviews
• Monitor database growth trends and recommend optimization and normalization strategies
• Design and develop reporting solutions using Microsoft PowerBI
• Support enterprise data governance, architecture, metadata, and stewardship initiatives
• Oversee and monitor Software Development Vendor activities and deliverables
• Ensure compliance with data retention, audit, and regulatory requirements
• Communicate effectively with technical teams, stakeholders, executives, and external partners

• 5+ years of experience as a SQL DBA
• 5+ years of large system architecture experience
• Large-scale production system implementation experience
• Experience overseeing Software Development Vendors
• Strong expertise in:

• MS SQL Server
• TFS (Team Foundation Server)
• Microsoft Visual Studio 2022
• C#
• ASP.NET / .NET
• PowerShell

Preferred Skills

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

Required Education

• Bachelor's Degree or equivalent experience

Environment & Tools

• MS SQL Server 2022 Enterprise
• SQL Server Reporting Services (SSRS)
• TFS (Team Foundation Server)
• Microsoft Visual Studio 2022
• C#, ASP.NET, .NET
• PowerShell
• Microsoft PowerBI

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.