System Software Programmer- SQL

IT - DSS - System Software Programmer - ConsultantJob id: 1012304/06/202612 Months from projected start date1201 Main Street Suite 600 Colubmia, SCThe State of South Carolina is looking for a Systems Software Programmer - AdvancedWhy is this position open: The Child Support Services Applications Team is part of the Department of Social Services (DSS) and is responsible for developing and maintaining applications in support of the Child Support Services Division (CSSD) including PACSS (Palmetto Automated Child Support System), SDNH (State Directory of New Hires) and the Client Portal application.Interview Process: 1 round, virtualDuration of the Contract: 12 monthsPossibility for Extension: YesWork Location: Role is hybrid (3 days onsite per week)Candidate location: Candidate MUST be a SC resident or willing to relocate to SC prior to starting the role at their own expense.Full job description attached and required and preferred skills are listed below.JOB DUTIES / RESPONSIBILITIES:The Department seeks a highly motivated individual who has the skills and experience ofdesigning, developing and supporting enterprise scale web applications in the Child SupportApplications group under the South Carolina Department of Social Services. This is a posting of aposition to perform in the role of SQL Database Administrator and Senior Developer that isresponsible for developing applications and database integrations using the Microsoft SQL Serverplatform. This will include reports, vendor exports, data warehousing tasks and other data relatedtasks.The candidate will take initiative in performance, working independently and with groups toeffectively accomplish project objectives and engage in the following:• Identifying, extracting and transforming required data based on business requirementsand following data governance standards• Performing detailed data analysis and data profiling supporting the development andimplementation of data cleanse/create processes and other strategies that optimize dataquality• Understanding performance, quality, and schedule considerations• Interpreting complex data and communicate it in an effective manner, leveragingadvanced reporting techniques• Recognizing data patterns, quantify potential issues, and identify solutions• Standardizing, harmonizing, cleaning, preparing, and using data for datasetsdevelopment, reporting, and analysis• Providing support to the project team in terms of technical specification and build ofinterface objects• Lead efforts to design, test and validate system interfaces• Work with state (agency IT staff) and Federal partners to design, test and implementinterface files and procedures for data exchange• Inspect and correct, as necessary, interface partner files in production• Serve as primary contact for any interface production file issues during nightly batchprocess, monitors batch process for errors• Act as liaison between Child Support team and interface partners• Perform code, technical and logical reviews• Monitor database growth trends and recommend normalization strategies andmaintenance improvements to ensure long-term performance and scalability• Design, develop and manage data analysis reports using Microsoft PowerBI platform• Serve as primary DBA for Child Support related applications• Participate in the monitoring, oversight and reporting on the execution of the SystemDevelopment Contractor's performance as it relates to development, daily operationsactivities including batch and online performance.• Developing and maintaining enterprise data authoritative ownership and stewardshipmetadata• Communicating and supporting the implementation of corporate policies, standards, andprocedures that provide effective architecture, governance, and management of theorganization's information/data assets• Developing and maintaining effective and efficient information architecture and dataownership awareness and training programs• Monitoring regulatory and compliance guidelines (such as data retention and auditrequirements) to determine impact on enterprise information architectureREQUIRED SKILLS:• 5+ years of experience as a SQL DBA• 5+ years of large system architecture• Large scale production systemimplementation experience• Experience overseeing work ofSoftware Development Vendors• MS SQL Server• TFS (Team Foundation Server)• Microsoft Visual Studio 2022• C#, ASP.net, and/or .NET• PowershelREQUIRED EDUCATION:• BACHELOR'S DEGREE OR EQUIVALENTEXPERIENCEENVIRONMENTS AND TOOLS• MS SQL 2022 enterprise server and MSSQL 2022 enterprise server ReportingServices• TFS (Team Foundation Server)• Microsoft Visual Studio 2022• C#, ASP.net, .NET• POWERSHELL• MICROSOFT POWERBIPREFERRED SKILLS (RANK IN ORDER OFIMPORTANCE):• Experience with Child SupportEnforcement system design anddevelopment• Experience with PowerBIADDITIONAL SKILLS:• Proven abilities to plan, organize,instruct, and review the work of thedevelopment team.• Knowledge of generally acceptedsystem architecture, projectmanagement and supervisionprinciples and practices.• Ability to communicate (orally andwritten) effectively with technical,non-technical staff,customers/stakeholders (State andFederal) and executives.• Ability to communicate effectivelywith DSS and other State