Systems Software Programmer Advanced (SQL DBA / Senior Developer)

InterSources Inc.

Columbia, SC

Apply

JOB DETAILS

SKILLS

Analysis Skills, Artificial Intelligence (AI), Business Analysis, Child Support, Cloud Applications, Cloud Computing, Code Reviews, Data Analysis, Data Profiling, Data Quality, Data Sets, Data Warehousing, Database Administration, Database Programming, ERP (Enterprise Resource Planning), Enterprise Architecture, ISO (International Organization for Standardization), Identify Issues, Information Architecture, Information Technology Consulting, International Electro-Technical Commission (IEC), Internet Application, Internet Security, Large-Scale Systems, Maintain Compliance, Microsoft .NET, Microsoft ASP.NET (Active Server Page), Microsoft C# (C Sharp), Microsoft Product Family, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Visual Studio, Online Marketing, Oracle, Performance Analysis, Performance Tuning/Optimization, Power BI, Production Systems, Project Tracking, Quality Assurance, Quality Management, SQL (Structured Query Language), SQL Databases, SQL Server Reporting Services (SSRS), Scripting (Scripting Languages), Software Administration, Software Development, Software Engineering, System Architecture, System Integration (SI), System Operations, System Validation, Systems/Internals Programming, Team Foundation Server (TFS), Technical Leadership, Test Design, User Experience Design (UXD), User Interface Design, Web Programming, Windows PowerShell

LOCATION

Columbia, SC

POSTED

30+ days ago

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.

About the Company

InterSources Inc.

It’s all about harnessing the real power of data. InterSources Inc was founded in 2007 providing intelligent data solutions to clients across industries and geographies.

Over the years, we have built products on Business Intelligence & Big Data platform simplifying and transforming the way business intelligence and real-time data analytics empower Corporations and end-users using Softwares like Tableau, Business Objects, MicroStrategy, etc.

In the process, we have enabled companies to use data analytics to help better understand, predict and influence consumer behavior, identify new market opportunities as they emerge, provide to users the data they need, alert the user when and why key business metrics have changed and enable them to make smart decisions.

COMPANY SIZE

100 to 499 employees

INDUSTRY

Computer/IT Services

FOUNDED

2007

WEBSITE

https://www.intersourcesinc.com/

Resume Resources

Free Resume Templates Free Resume Builder