RIT Solutions, Inc. ยท 2 months ago
Sr. Database Developer
NYC, NY
Full-time
Hybrid
Senior Level
7+ years expRIT Solutions, Inc. is seeking a Senior Back-End Developer for the NYC Department of Health and Mental Hygiene (DOHMH) to enhance and optimize the eSHARE system for HIV-related services data. The role involves developing SQL-based systems, managing data warehousing, and ensuring data accuracy and compliance with health regulations.
Staffing & Recruiting
Responsibilities
Design, develop, and maintain complex stored procedures, functions, and triggers to support data collection, validation, and reporting functions within the eSHARE system
Analyze, troubleshoot, and resolve performance bottlenecks in SQL queries, indexes, and execution plans. Implement database tuning and query optimization strategies to ensure efficient data processing at scale
Develop and manage ETL workflows for data ingestion and transformation between eSHARE and other systems, ensuring data integrity and consistency across multiple health program databases
Design and maintain database schemas and data marts to support complex reporting, dashboards, and analytics requirements across multiple HIV-related programs
Create and maintain data validation routines to ensure completeness and accuracy of public health data in compliance with federal reporting requirements (e.g., Ryan White Services Report [RSR])
Implement secure database access controls and support data governance activities to maintain HIPAA and CJIS compliance for health data
Work closely with application developers, data analysts, and program managers to design back-end solutions that meet program needs. Document database designs, ETL logic, and operational processes for ongoing maintenance and audits
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, or a related field
7+ years of experience in database design, development, and performance optimization
Strong expertise in: Microsoft SQL Server (2016 or later)
Advanced T-SQL programming, including complex stored procedures, functions, triggers, and query logic
Query optimization, index tuning, and performance troubleshooting
Database design and normalization principles
Data extraction, transformation, and loading (ETL) workflows
Experience with data warehousing, reporting, and health data systems supporting large-scale public health or clinical programs
Demonstrated experience working with data privacy and security standards, including HIPAA and PII data handling
Strong analytical, diagnostic, and problem-solving abilities
Preferred
Experience with eSHARE, AIRS, or other public health data management systems
Familiarity with HL7, FHIR, or other healthcare data exchange standards
Experience using Azure SQL Database, SSIS, or Data Factory for ETL and integration
Proficiency with Power BI, SSRS, or other reporting and visualization tools
Knowledge of data warehouse modeling (star/snowflake schemas) and performance tuning for large data sets
Experience in Agile environments supporting continuous integration and delivery
Company
RIT Solutions, Inc.
Jobdiva Job Portal: https://www1.jobdiva.com/candidates/myjobs/searchjobsdone.jsp?a=xbjdnwgjodtga1y1im2g881fkkeiwd0775lbvq8yqgps8vb2q36w2vj1ga6xxork&compid=-1 Recruitment (contingency search and campus selection).
201-500 employees
H1B Sponsorship
RIT Solutions, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2023 (2)
Funding
Current Stage
Growth StageCompany data provided by crunchbase