Senior Back-End Developer Sr. Database Developer

The NYC Department of Health and Mental Hygiene (DOHMH) seeks a Senior Back-End Developer to support the maintenance enhancement and performance optimization of the eSHARE systema centralized data capture and reporting platform that facilitates the collection of HIV-related services data under Ryan White Prevention Testing Housing and Clinical operations programs.

The Senior Back-End Developer will be responsible for developing and optimizing SQL-based back-end systems designing complex stored procedures and managing data warehousing and reporting processes that ensure data accuracy reliability and scalability. This role requires deep technical expertise in Microsoft SQL Server and experience supporting public health or healthcare data systems with strong data governance and compliance requirements.

KEY RESPONSIBILITIES

• Database Development & Maintenance - Design develop and maintain complex stored procedures functions and triggers to support data collection validation and reporting functions within the eSHARE system.
• Performance Optimization - 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.
• ETL and Data Integration - 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.
• Reporting & Data Warehousing - Design and maintain database schemas and data marts to support complex reporting dashboards and analytics requirements across multiple HIV-related programs.
• Quality Assurance & Data Validation - 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).
• Security & Compliance - Implement secure database access controls and support data governance activities to maintain HIPAA and CJIS compliance for health data.
• Collaboration & Documentation - 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.

REQUIRED SKILLS & QUALIFICATIONS

Microsoft SQL Server (2016 or later)

PREFERRED QUALIFICATIONS

If you are interested in getting more information about this opportunity please contact Irina Rozenberg at your earliest convenience.

At Ariel Partners we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions so when they have their biggest challenges we are on their short list. We are looking for team members who share our values of : Integrity to do the right thing even when it hurts; Commitment to the long-term success and happiness of our customers our people and our partners; Courage to take on difficult challenges accept new ideas and accept incremental failure; and the constant pursuit of Excellence. Ariel Partners is an Equal Opportunity Employer in accordance with federal state and local laws.

Required Experience :

Senior IC

Key Skills

Databases,SQL,Database Development,PL / SQL,Microsoft SQL Server,ssrs,Database Design,SSIS,T Sql,Sybase,Data Warehouse,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1