SQL Database Developer

Job Title: Senior Database Developer (SQL) – Project Lead (W2 Only)Location: Columbia, SC (Hybrid/Onsite as required)Duration: 12 Months (No Extension)Employment Type: W2 OnlyWork Authorization: U.S. Citizens (USC) and Green Card (GC) Holders OnlyClient: South Carolina Department of Public Health (DPH)Job SummaryWe are seeking an experienced Senior Database Developer (SQL) – Project Lead to support mission-critical public health initiatives, including data migration, ETL development, data warehousing, reporting, and Electronic Disease Surveillance System (EDSS) modernization. The ideal candidate will have strong expertise in Microsoft SQL Server, T-SQL, SSIS, ETL processes, and healthcare/public health data integration.Required Qualifications3+ years of experience with MS SQL Server (2016+)3+ years of experience with T-SQL, including Stored Procedures, Advanced Queries, and Query Optimization3+ years of experience developing ETL/Data Pipeline solutions3+ years of experience in Data Warehousing and Relational Databases3+ years of experience with Report Development3+ years of experience working with XML1+ year of experience with SQL Server Integration Services (SSIS)1+ year of experience with HL7 v2.x (2.3.1–2.5.1) ORU Messages1+ year of experience with HIPAA, PHI, PII, CDC security standards, or similar healthcare data compliancePreferred QualificationsExperience handling large datasets (1TB+)Requirements gathering and technical documentationPublic Health or Disease Surveillance SystemsSAS development/migrationPower BI reportingLOINC/SNOMEDR & RStudioFASTQ files and demultiplexingKey ResponsibilitiesDesign, develop, and optimize SQL databases, stored procedures, and ETL processes.Develop and maintain SSIS packages and data pipelines.Build reports and dashboards using SQL and Power BI.Support data migration, validation, testing, and deployment.Work with XML, HL7, CSV, and healthcare data integrations.Monitor, troubleshoot, and optimize production database processes.Collaborate with business stakeholders to gather requirements and deliver technical solutions.Mentor team members and promote database development best practices.Required SkillsMS SQL Server 2016+T-SQLSSISETL DevelopmentData WarehousingSQL Performance TuningXMLHL7Power BIHealthcare Data IntegrationAdditional Information40 hours/weekBackground check and E-Verify requiredGovernment/Public Sector experience preferredImportant Note✅ W2 Candidates Only✅ Work Authorization: U.S. Citizens (USC) and Green Card (GC) Holders Only❌ No C2C, No 1099, No Third-Party Vendors❌ H1B, OPT, CPT, EAD, TN, or other visa holders will not be considered.