SQL Developer, Bureau of IT Application and Platform Engineering
About the position
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. 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.
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
• 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.
• Professional/Vendor Certification(s) in database administration that is required for the position to be filled.
• A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management
• A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience (IT) of which at least two years must have been database administration experience as described in above
• A satisfactory equivalent of education and/or experience equivalent to above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from an accredited college or university is equivalent to 6 months of information technology experience, but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college or university may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in above.
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.
• 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.
Apply Now
Apply Now
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. 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.
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
• 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.
• Professional/Vendor Certification(s) in database administration that is required for the position to be filled.
• A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management
• A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience (IT) of which at least two years must have been database administration experience as described in above
• A satisfactory equivalent of education and/or experience equivalent to above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from an accredited college or university is equivalent to 6 months of information technology experience, but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college or university may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in above.
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.
• 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.
Apply Now
Apply Now