SQL Database Developer

End Client: State of South Carolina Job Title: SQL Database Developer Location: Cayce, SC 29033 (100% Remote) Duration: 12 Months Position Type: Contract Hours Per Week: 40 Hr Interview Mode: Webcam Requirement ID: 1150 8 Department : South Carolina Department of Public Health (DP H) Descriptio n: This opening is a new program specific position to support the technical needs of our STD HIV staff. Some current projects include data migrations to our replacement Electronic Disease Surveillance System (EDSS), ongoing Data Warehousing project, upcoming eCR projects, and general Data Pipeline improvements and monitoring. The position may also support related Lab and Disease Surveillance systems and help with CDC Data Modernization Effor ts. Responsibilit ies:Prepare and maintain process documentation, data flows, and diagrams for assigned processes (new and existi ng).Work with end users to perform gap analysis, gather and document functional requirements, and create necessary proce ssesAssist with project and time management including estimates and status repor tingAbility to plan, organize, review, and implement associated project milestones to complet ion.Process Development, Process Automation, and ETL Solut ionsSQL stored procedure creation, advanced query design, debugging, and optimization(MS T- SQL)Rewriting of SAS code into SSIS Packages and Power B.I.; SSIS Debugg ing,Rewriting and optimization of remaining SAS code and queries as nee ded.Data Pipeline and Reporting Development, Modification, Improvement, and Monito ringHelp format and automate data uploads into the Data Warehouse and Disease Surveillance Systems like CDC SAMS / eHARS and the new Electronic Disease Surveillance System (EpiT rax)Parsing of multiple data formats including xml\, csv, SOAP, HL7Assist with system, data and database migrations and related changes, testing, and valida tionHelp with eCR solutions including condition authoring, data import and utilization, process automation and troubleshooting, and data review, analysis, and repor tingMonitor production processing to ensure proper data flow and response t imesHelp to perform and automate daily maintenance proce ssesDebug, troubleshoot, and optimize new and existing proces ses.Resolve processing iss ues.Support related server, database, software upgrades, and new environment configura tionEnsure maximum system uptime for critical components to ensure business continu ity.Advise the Team on best practice and techniques. Mentor team and staff on advanced top ics.Modification / rewrite of existing processes and creation of new processes to be compliant with agency security requirements and following industry best stand ards Required Sk ills:3+ Years of Experience with MS T- SQL (Stored Procedures, Advanced Queries, Optimiza tion)3+ Years of Experience with ETL Process Develo pment1+ Year of Experience with SQL Server Integration Services ( SSIS)3+ Years of Experience with Report Develo pment3+ Years of Experience with Data Warehousing & Relational Data bases1+ Year of Experience HL7 v 2.3.1 -2.5.1 and ORU Mes sages3+ Years of Experience wit h XML3+ Years of Experience with MS SQL Server 2016+1+ Year of Experience with security and data classification related to CDC, HIPAA, CJIS, PHI , PII PREFERRED SKILLS (RANK IN ORDER OF IMPORT ANCE):Ability to manage large data sets ( 1 TB+)Requirements Gathering & Documen tationPublic Health / Disease Surveillance Systems Expe rienceStatistical Analysis System (SAS)LOINC / SNOMEDFASTQ FILES AND DEMULTIP LEXINGR & R Studio