IT - DSS - System Software Programmer - Consultant

Position InformationResumeR2RCover LetterMeets Work LocationPlease ensure you attach the SC Cover Sheet (attached), a valid Right to Represent, and the candidate's resume with full legal first name, and last name. Withdrawn candidates will not be permitted to be replaced. If you would like to use a sub vendor, only 1 level deep, please submit the Sub Vendor usage form.The 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.Will close to submissions on 5/13 at 5:00PM EST.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.Required SkillsSkill TypeSkill Name5+ years of experience as a SQL DBA5+ years of large system architectureLarge scale production system implementation experienceExperience overseeing work of Software Development VendorsMS SQL ServerTFS (Team Foundation Server)Microsoft Visual Studio 2022C#, ASP.net, and/or .NETPowershellPreferred SkillsSkill TypeSkill NameExperience with Child Support Enforcement system design and developmentExperience with PowerBIAttachment:Statement of Work (SOW) for Contingent Labor Request(why do you enjoy working for the company – selling points for potential candidates):WORK TEAM FOCUSED ON RESULTSnew role, increased workload, new dept, resignation, promotion)?New PositionThe 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.The Department seeks a highly motivated individual who has the skills and experience of designing, developing and supporting enterprise scale web applications in the Child Support Applications group under the South Carolina Department of Social Services. This is a posting of a position to perform in the role of SQL Database Administrator and Senior Developer that is responsible for developing applications and database integrations using the Microsoft SQL Server platform. This will include reports, vendor exports, data warehousing tasks and other data related tasks.The candidate will take initiative in performance, working independently and with groups to effectively accomplish project objectives and engage in the following:Identifying, extracting and transforming required data based on business requirements and following data governance standardsPerforming detailed data analysis and data profiling supporting the development and implementation of data cleanse/create processes and other strategies that optimize data qualityUnderstanding performance, quality, and schedule considerationsInterpreting complex data and communicate it in an effective manner, leveraging advanced reporting techniquesRecognizing data patterns, quantify potential issues, and identify solutionsStandardizing, harmonizing, cleaning, preparing, and using data for datasets development, reporting, and analysisProviding support to the project team in terms of technical specification and build of interface objectsLead efforts to design, test and validate system interfacesWork with state (agency IT staff) and Federal partners to design, test and implement interface files and procedures for data exchangeInspect and correct, as necessary, interface partner files in productionServe as primary contact for any interface production file issues during nightly batch process, monitors batch process for errorsAct as liaison between Child Support team and interface partnersPerform code, technical and logical reviewsMonitor database growth trends and recommend normalization strategies and maintenance improvements to ensure long term performance and scalabilityDesign, develop and manage data analysis reports using Microsoft PowerBI platformServe as primary DBA for Child Support related applicationsParticipate in the monitoring, oversight and reporting on the execution of the System Development Contractor's performance as it relates to development, daily operations activities including batch and online performance.Developing and maintaining enterprise data authoritative ownership and stewardship metadataCommunicating and supporting the implementation of corporate policies, standards, and procedures that provide effective architecture, governance, and management of the organization's information/data assetsDeveloping and maintaining effective and efficient information architecture and data ownership awareness and training programsMonitoring regulatory and compliance guidelines (such as data retention and audit requirements) to determine impact on enterprise information architecture5+ years of experience as a SQL DBA5+ years of large system architectureLarge scale production system implementation experienceExperience overseeing work of Software Development VendorsMS SQL ServerTFS (Team Foundation Server)Microsoft Visual Studio 2022C#, ASP.net, and/or .NETPowershellExperience with Child Support Enforcement system design and developmentExperience with PowerBIBachelor's degree or equivalent experienceN/AMS SQL 2022 enterprise server and MS SQL 2022 enterprise server Reporting ServicesTFS (Team Foundation Server)Microsoft Visual Studio 2022C#, ASP.net, .NETPOWERSHELLMICROSOFT POWERBIProven abilities to plan, organize, instruct, and review the work of the development team.Knowledge of generally accepted system architecture, project management and supervision principles and practices.Ability to communicate (orally and written) effectively with technical, non-technical staff, customers/stakeholders (State and Federal) and executives.Ability to communicate effectively with DSS and other State information technology staff.By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at .