Database Developer (SQL) Project Lead

The selected candidate will need to pass the following screenings:

7 Year Standard Background Check & Credit History Check

E-Verify

Please ensure you attach the SC Cover Sheet (attached) a valid Right to Represent and the candidates 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 Senior Database Developer (Database Developer (SQL) - Project Lead)

Why is this position open: New position to support the project/technical needs of the STD HIV Staff including data migrations to EDSS Data Warehousing Projects and upcoming eCR Projects.

Will close to submissions on June 30th 2026 5:00PM EST.

Interview Process: 1 Round of Virtual Interviews

Duration of the Contract: 12 Months

Possibility for Extension: No this is a project-based position.

Work Location: The role is 100% remote.

Candidate location: No SC residency required. Open to Nationwide Candidates that are comfortable working EST Hours.

Required Skills

3 Years of Experience with MS T-SQL (Stored Procedures Advanced Queries Optimization)

3 Years of Experience with ETL Process Development

1 Year of Experience with SQL Server Integration Services (SSIS)

3 Years of Experience with Report Development

3 Years of Experience with Data Warehousing & Relational Databases

1 Year of Experience with HL7 v 2.3.1 - 2.5.1 and ORU Messages

3 Years of Experience with XML

3 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

Ability to manage large data sets (1 TB)

Requirements Gathering & Documentation

Public Health / Disease Surveillance Systems Experience

Statistical Analysis System (SAS)

LOINC / SNOMED

FASTQ Files and Demultiplexing

R&R Studio

Daily Duties / Responsibilities: The candidate will work closely with members of the Systems Integration Health Data Visualizations and Database Administration teams as well as STD / HIV program staff. The candidate should be self-motivated and team-oriented work under limited supervision and respond to priority tasks. The candidate must be able to independently research and design processes create specifications and data flows develop ETL processes make stored procedures advanced queries and reports assist with validations actively engage with the Team and stakeholders attend meetings provide guidance and respond promptly. Participate in a team comprised of DPH and solution implementation staff providing STD HIV system and data migration support data pipeline improvement and monitoring data warehousing and reporting. New solutions for eCR onboarding import and utilization will be included. Work can consist of planning design configuration process development SSIS and script coding and automation of data flows. Will coordinate with the assigned IT Section Manager and Team Lead on daily assignments/tasks. Will coordinate and collaborate with contract and vendor staff existing DPH staff and other I. T. professionals working with the Office of Information Technology. Ensure assignments are completed accurately and on time assist with problem resolution mitigate issues provide solutions communicate and escalate as needed to management and report progress to the manager. Will advise staff on code conversions database and query design optimization process improvements and automation validations reporting and report creation. Work with vendors and staff on deliverables debugging and converting current processes to SSIS and PowerBI. This includes rewriting existing SAS solutions to conform to best practices and updated coding standards and improving efficiency performance and maintenance. Specific duties and responsibilities will include but are not limited to the following: Prepare and maintain process documentation data flows and diagrams for assigned processes (new and existing). Work with end users to perform gap analysis gather and document functional requirements and create necessary processes Assist with project and time management including estimates and status reporting Ability to plan organize review and implement associated project milestones to completion. Process Development Process Automation and ETL Solutions SQL stored procedure creation advanced query design debugging and optimization (MS T-SQL) Rewriting of SAS code into SSIS Packages and Power B.I.; SSIS Debugging Rewriting and optimization of remaining SAS code and queries as needed. Data Pipeline and Reporting Development Modification Improvement and Monitoring Help format and automate data uploads into the Data Warehouse and Disease Surveillance Systems like CDC SAMS / eHARS and the new Electronic Disease Surveillance System (EpiTrax) Parsing of multiple data formats including xml csv SOAP HL7 Assist with system data and database migrations and related changes testing and validation Help with eCR solutions including condition authoring data import and utilization process automation and troubleshooting and data review analysis and reporting Monitor production processing to ensure proper data flow and response times Help to perform and automate daily maintenance processes Debug troubleshoot and optimize new and existing processes. Resolve processing issues. Support related server database software upgrades and new environment configuration Ensure maximum system uptime for critical components to ensure business continuity. Advise the Team on best practice and techniques. Mentor team and staff on advanced topics. Modification / rewrite of existing processes and creation of new processes to be compliant with agency security requirements and following industry best standards SCDPH will utilize this position for 40 hours per week for the projects general standard weekday work hours are expected. The selected candidate may be able to work flexible hours during the week for the purpose of providing coverage on weekends when necessary and preapproved. Total week hours (to include the weekend) should not exceed 40 unless approved in advance (i.e. hours worked on Saturday and/or Sunday would be deducted from hours worked Mon-Fri). This position would need to be available to support critical systems during business hours on off-hours and weekends. The candidate will work closely with the Systems Integration Section Manager and Project Manager(s) to identify prioritize and schedule workload and implementation to I. T. standards and procedures. The candidate will also work closely with customers and subject matter experts on process design migration to the platforms and testing. This will also include compliance with DPH security policy/procedures and integrating systems when possible to streamline staff workflows user security data analytics and reporting. Module support of the project. DPH will require that selected personnel sign the DPH confidentiality agreement and/or Business Associate (BA) agreement if applicable. All web services must be secure. DPH will not accept any offers including an up-lift charge. The rate paid per consultant must not exceed the maximum rate established for this position described in the State contract terms. Follow agency IT Standards policies and procedures to include documentation. All source code (compiled and un-compiled) will become the sole property of the South Carolina Department of Public Health. Any source code data product or functionality resulting from this SOW or previously owned/developed by DPH will remain the sole property of DPH and is not to be incorporated into the core product of any vendors application. Any modifications and interfaces developed under said contract will not be used by the contractor for any independent project of the contractor or published or publicized by the contractor without written permission of DPH. DPH has the final say on all programming choices.