Systems Software Programmer - Advanced (SQL DBA / Senior Developer)

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., * 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

• 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.