Company Overview: With an annual budget of $2.3 billion and more than 7,000 employees throughout the five boroughs, the New York City Department of Health and Mental Hygiene (NYC DOHMH) is one of the largest public health agencies in the world, serving 8 million New Yorkers from diverse ethnic and cultural backgrounds. We're tackling a broad range of public health issues with innovative policies and programs and getting exceptional results, but our work is never finished. The breadth of our innovative programs provides the widest range of choices for every member of our team. With grant funds from the Centers for Disease Control and Prevention (CDC), DOHMH is undertaking a new initiative that will meet critical infrastructure needs and make possible strategic investments that will have lasting effects on public health. Investments and improvements through this initiative will help modernize DOHMH's foundational capabilities and data infrastructure, enabling it to partner in complex health and health care environments and, in turn, support better public health outcomes, including COVID-19. This initiative supports larger efforts to rebalance investments in public health and more equitably serve communities and populations. Program Description: The agency is embarking on a data modernization initiative to accelerate its data strategy. During the COVID-19 pandemic, data was the life blood of the agency's response to making informed data-driven decisions and policies that directly impacts the lives of New Yorkers. These included operational data in our vaccination campaign at the Vaccine Hubs, distribution strategy throughout the city's vaccine infrastructure, as well as health equity data breaking down lab tests, positive cases, hospitalizations, deaths, and vaccination rates by age, place, and race. With grant funding support from the Centers for Disease Control (CDC), DOHMH is embarking on a data modernization initiative to move from siloed and brittle public health data systems to connected, resilient, adaptable, and sustainable systems. This initiative is not just about technology, but also about putting the right people, processes, and policies in place. NYC DOHMH's modernization strategy focuses on key areas in data collection, storage, processing (including transformation, standardization, matching, deduplication), data integration and exchange, data analysis and data reporting and visualization The DMI initiative will allow DOHMH to build up foundational technology capabilities within the Division of Information Technology. This includes increasing capacity, knowledge, and experience with Azure cloud technologies within the broader NYC cloud and cybersecurity infrastructure and all within the context of public health. Summary of Position: We are seeking a talented and detail-oriented SQL Developer to join our team. The ideal candidate will have strong skills in database design, development, and optimization. You will work closely with our data analysts, software developers, and IT teams to create efficient and scalable databases that meet business requirements. Job Duties:
- Design, develop, and maintain SQL databases to support applications and data analysis.
- Write complex SQL queries, stored procedures, triggers, and scripts to ensure data integrity and performance.
- Optimize database performance by tuning queries and designing indexing strategies.
- Collaborate with cross-functional teams to define and implement database solutions.
- Monitor, troubleshoot, and resolve database issues in a timely manner.
- Perform database migrations, upgrades, and backup/restoration processes.
- Analyze and improve existing database systems for scalability and performance.
- Ensure database security and data privacy compliance.
Qualifications and Requirements:
- Bachelor's degree in Computer Science, Information Systems, or related field.
- Proven experience as an SQL Developer, Database Developer, or similar role.
- Strong proficiency in SQL and relational databases (e.g., MySQL, PostgreSQL, MS SQL Server).
- Experience with database design, normalization, and performance tuning.
- Familiarity with ETL processes and data integration.
- Understanding of data security best practices and compliance standards.
- Ability to work independently as well as collaboratively in a team environment.
- Strong analytical and problem-solving skills
- Salary - $100,000 - $100,000
Preferred Skills:
- Experience with cloud databases (e.g., AWS RDS, Azure SQL).
- Knowledge of data warehousing and big data technologies.
- Familiarity with reporting tools (e.g., Power BI, Tableau) and their integration with SQL databases.
- Certifications in database technologies (e.g., Microsoft SQL Server, Oracle) are a plus.
Additional Information:
- This is a temporary grant-funded position ending in November 2027.
- This individual must reside in the tri-state area (NY, NJ, CT) by their confirmed start date.
- Preference may be given to individuals residing in New York City (5 boroughs) or surrounding New York State counties.
- This individual will be expected to work non-business hours during emergencies.
PHS is proud to be an equal opportunity employer and encourages applications from women, people of color, persons with disabilities, LGBTQIA+ individuals, and veterans. Monday-Friday Hybrid 35 Hours Per week