SQL DBA / Senior Developer
Intersources inc
Columbia, SC
Apply
JOB DETAILS
SALARY
$60–$65 Per Hour
JOB TYPE
Temporary, Contractor, Full-time
SKILLS
Analysis Skills, Business Analysis, Child Support, Code Reviews, Data Analysis, Data Profiling, Data Quality, Data Sets, Data Warehousing, Database Administration, Database Programming, Enterprise Architecture, Identify Issues, Information Architecture, Internet Application, 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, 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 Operations, System Validation, Systems/Internals Programming, Team Foundation Server (TFS), Technical Leadership, Test Design, Windows PowerShell
LOCATION
Columbia, SC
POSTED
7 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 the Company
I