SQL Developer

$100,000 - $100,000/Yr

Public Health Solutions - Long Island City, NY

Full-time - Mid Level

Long Island City, NY

5,001-10,000 employees

Ambulatory Health Care Services

About the position

The SQL Developer position at the New York City Department of Health and Mental Hygiene (NYC DOHMH) involves designing, developing, and maintaining SQL databases to support public health initiatives. The role is critical in the agency's data modernization initiative, which aims to enhance data infrastructure and improve public health outcomes. The ideal candidate will collaborate with various teams to create efficient database solutions, ensuring data integrity and performance while adhering to security and compliance standards.

Responsibilities

• 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.

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.

Nice-to-haves

• 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.

Benefits

• Salary of $100,000 per year.
• Temporary grant-funded position until November 2027.
• Hybrid work environment with Monday-Friday schedule.
• Encouragement of applications from diverse backgrounds.