SQL Database Developer

Hi Candidates,

I've a immediate requirement of SQL Database Developer candidate. Please note this position is only for W2 candidates, C2C and 1099 candidates are not acceptable.

email me on

Job Description:

Job Title: SQL Database Developer
Client: State of South Carolina
Location: Columbia, SC
Work mode: Remote

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

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.

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

1. 3+ Years of Experience with MS T SQL (Stored Procedures, Advanced Queries, Optimization)

2. 3+ Years of Experience with ETL Process Development

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

4. 3+ Years of Experience with Report Development

5. 3+ Years of Experience with Data Warehousing & Relational Databases

6. 1+ Year of Experience HL7 v 2.3.1 - 2.5.1 and ORU Messages

7. 3+ Years of Experience with XML

8. 3+ Years of Experience with MS SQL Server 2016+

9. 1+ Year of Experience with security and data classification related to CDC, HIPAA, CJIS, PHI, PII

1. Ability to manage large data sets (1 TB+)

2. Requirements Gathering & Documentation

3. Public Health / Disease Surveillance Systems Experience

4. Statistical Analysis System (SAS)

5. LOINC / SNOMED

6. FASTQ FILES AND DEMULTIPLEXING

7. R & RStudio

Microsoft SQL Server (2016+), T SQL, SSMS

SQL Server Integration Services (SSIS) and ETL/Data Pipeline development

Data Warehousing environments and reporting tools (e.g., Power BI)

HL7 v2.x (including ORU), XML, CSV, and other structured data formats

Healthcare/public health data systems (e.g., EDSS, eHARS, CDC reporting systems)

Electronic Case Reporting (eCR) and data exchange integrations

SAS (legacy processes) and scripting for data transformation

HIPAA, PHI/PII, and CDC data standards and security compliance