SQL Developer, Bureau of IT Application and Platform Engineering at CityOfNewYork

ONLY PERMANENT EMPLOYEES IN THE TITLE OF THE CERTFIED IT ADMINISTRATOR DB AND THOSE THAT ARE REACHABLE ON the CIVIL SERVICE LIST ARE ELIGIBLE TO APPLY. Division/Program Summary: The Division of Information Technology's mission and vision is to promote and protect the health of all New Yorkers through the use of innovative technology and health information that is useful and available. 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. Position Summary: The Certified IT Administrator/(DB)SQL Developer will work closely with our data analysts, software developers, and IT teams to create efficient and scalable databases that meet business requirements. Job Duties and 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. Why you should work for us: - Benefits: City employees are entitled to unmatched benefits such as: o a premium-free health insurance plan that saves employees over $10K annually, per a 2024 assessment. o additional health, fitness, and financial benefits may be available based on the position’s associated union/benefit fund. o a public sector defined benefit pension plan with steady monthly payments in retirement. o a tax-deferred savings program and o a robust Worksite Wellness Program that offers resources and opportunities to keep you healthy while serving New Yorkers. - Work From Home Policy: Depending on your position, you may be able to work up to two days during the week from home. - Job Security - you could enjoy more job security compared to private sector employment and be able to contribute to making NYC a healthy place to live and work. Established in 1805, the New York City Department of Health and Mental Hygiene (NYC Health Department) is the oldest and largest health department in the U.S., dedicated to protecting and improving the health of NYC. Our mission is to safeguard the health of every resident and cultivate a city where everyone, regardless of age, background, or location, can achieve their optimal health. We provide a wide array of programs and services focused on food and nutrition, anti-tobacco support, chronic disease prevention, HIV/AIDS treatment, family and child health, environmental health, mental health, and social justice initiatives. As the primary population health strategist and policy authority for NYC, with a rich history of public health initiatives and scientific advancements, from addressing the 1822 yellow fever outbreak to the COVID-19 pandemic, we serve as a global leader in public health innovation and expertise. Come join us and help to continue our efforts in making a difference in the lives of all New Yorkers! The NYC Health Department is an inclusive equal opportunity employer committed to providing access and reasonable accommodation to all individuals. To request reasonable accommodation to participate in the job application or interview process, contact Sye-Eun Ahn, Director of the Office of Equal Employment Opportunity, at [Upgrade to PRO to see contact] or 347-396-6549. CERT IT ADMINISTRATOR (DB) - 13644