What are the responsibilities and job description for the Senior Database Developer position at NYC Department of City Planning?
NOTE: This is a temporary funded position through June 30, 2026.
THE AGENCY
The Department of City Planning (DCP) plans for the strategic growth and development of the City through ground-up planning with communities, the development of land use policies and zoning regulations applicable citywide and sharing its perspectives on growth and community needs with sister agencies in collaboration with the Office of Management and Budget (OMB).
DCP is a great place to work – cultivating intellectual inspiration, professional development, and creativity. Visit our website at www.nyc.gov/planning to access the full listing of job opportunities and to learn more about the agency’s services.
THE DIVISION
Information Technology Division’s (ITD) vision is to become a dynamic and vibrant technology delivery organization of the New York City government that leads business transformations and technology innovations to enable citizen-centric smart urban planning, while promoting a culture of collaboration, talent development, and equity. ITD is responsible for developing technology solutions to support agency needs and citywide asks, including City Charter mandates, grant funding requirements, and citywide geospatial services, and maintaining systems infrastructure and endpoint assets, to optimize operational efficiency, promote innovation, and collaborate with other city agencies to enhance service accessibility to citizens. The division provides necessary computing infrastructure and productivity-enhancing technology tools in a hybrid mode (on premise and in the cloud), to support DCP’s interdisciplinary staff across five boroughs, including planners, urban designers, project managers, and executive management. The division is comprised of experienced and talented software engineers, geographic specialists, service engineers, and technology leaders who specialize in managing system infrastructure, cyber security, geospatial data engineering, application services, and portfolio management.
Within ITD, the GeoSupport Services (GSS) unit is responsible for the maintenance and continued enhancement of the GeoSupport system that processes geographic locations in New York City to provide unique geospatial references for city boroughs, community districts, tax blocks, lots, street stretches, intersections, etc., to the rest of the city agencies, partners, and the public. The geo-processed location references are made available to incorporate into internal and external system workflows and data analysis, to represent the geography of locations and assets, enabling map-based visual representation, conflict resolution, and collaboration. The GSS unit is staffed by a team of software engineers specializing in Geographic Information Systems (GIS) and web service design, using a variety of technology stacks and cloud computing infrastructure.
THE ROLE
ITD’s GeoSupport Services (GSS) unit is seeking an experienced and certified Senior Database Developer for Microsoft SQL Server who has strong expertise in data modeling, normalization, ETL processing, integration/reporting services, OLAP data models, ORM tools (Entity Framework), and query performance tuning skills to join our agile development team. This role requires hands-on experience with T-SQL, data modeling, database query optimization, SSIS, SSAS, and SSRS to support enterprise applications and data-driven solutions. The candidate will play a crucial role in designing, developing, and maintaining the next generation GeoSupport system services and applications, collaborate with cross-functional teams to deliver high-quality software solutions that meet business requirements, while ensuring performance, scalability, security, and accessibility to manage nearly 70 billion GeoSupport service calls made each year.
Under supervision and general direction, with considerable latitude for the exercise of independent judgment, the Senior Database Developer’s responsibilities include, but may not be limited to:
Minimum Qualifications
This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.
Public Service Loan Forgiveness
As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/
Residency Requirement
New York City residency is not required for this position.
Additional Information
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.
THE AGENCY
The Department of City Planning (DCP) plans for the strategic growth and development of the City through ground-up planning with communities, the development of land use policies and zoning regulations applicable citywide and sharing its perspectives on growth and community needs with sister agencies in collaboration with the Office of Management and Budget (OMB).
DCP is a great place to work – cultivating intellectual inspiration, professional development, and creativity. Visit our website at www.nyc.gov/planning to access the full listing of job opportunities and to learn more about the agency’s services.
THE DIVISION
Information Technology Division’s (ITD) vision is to become a dynamic and vibrant technology delivery organization of the New York City government that leads business transformations and technology innovations to enable citizen-centric smart urban planning, while promoting a culture of collaboration, talent development, and equity. ITD is responsible for developing technology solutions to support agency needs and citywide asks, including City Charter mandates, grant funding requirements, and citywide geospatial services, and maintaining systems infrastructure and endpoint assets, to optimize operational efficiency, promote innovation, and collaborate with other city agencies to enhance service accessibility to citizens. The division provides necessary computing infrastructure and productivity-enhancing technology tools in a hybrid mode (on premise and in the cloud), to support DCP’s interdisciplinary staff across five boroughs, including planners, urban designers, project managers, and executive management. The division is comprised of experienced and talented software engineers, geographic specialists, service engineers, and technology leaders who specialize in managing system infrastructure, cyber security, geospatial data engineering, application services, and portfolio management.
Within ITD, the GeoSupport Services (GSS) unit is responsible for the maintenance and continued enhancement of the GeoSupport system that processes geographic locations in New York City to provide unique geospatial references for city boroughs, community districts, tax blocks, lots, street stretches, intersections, etc., to the rest of the city agencies, partners, and the public. The geo-processed location references are made available to incorporate into internal and external system workflows and data analysis, to represent the geography of locations and assets, enabling map-based visual representation, conflict resolution, and collaboration. The GSS unit is staffed by a team of software engineers specializing in Geographic Information Systems (GIS) and web service design, using a variety of technology stacks and cloud computing infrastructure.
THE ROLE
ITD’s GeoSupport Services (GSS) unit is seeking an experienced and certified Senior Database Developer for Microsoft SQL Server who has strong expertise in data modeling, normalization, ETL processing, integration/reporting services, OLAP data models, ORM tools (Entity Framework), and query performance tuning skills to join our agile development team. This role requires hands-on experience with T-SQL, data modeling, database query optimization, SSIS, SSAS, and SSRS to support enterprise applications and data-driven solutions. The candidate will play a crucial role in designing, developing, and maintaining the next generation GeoSupport system services and applications, collaborate with cross-functional teams to deliver high-quality software solutions that meet business requirements, while ensuring performance, scalability, security, and accessibility to manage nearly 70 billion GeoSupport service calls made each year.
Under supervision and general direction, with considerable latitude for the exercise of independent judgment, the Senior Database Developer’s responsibilities include, but may not be limited to:
- Perform data modeling and database design for application development and product implementation initiatives under the guidance of database administrator and technical leads.
- Follow best practices in data modeling including use of standard naming conventions, processes and templates to ensure consistency of data models.
- Design and optimize T-SQL queries, stored procedures, functions, and triggers for high performance SQL Server databases.
- Perform data extraction, transformation, and loading (ETL) processes to integrate data from multiple sources.
- Develop, manage, optimize, and automate ETL workflows using SQL Server Integration Services (SSIS) and other ETL tools.
- Design and implement OLAP reporting models, star and snowflake schemas, and optimize data cubes.
- Identify and resolve SQL Server performance bottlenecks, including indexing, query execution plans, and partitioning to ensure availability, performance, reliability, and scalability.
- Ensure data integrity, security, and compliance with industry best practices.
- Collaborate with .NET development teams to ensure database efficiency and scalability.
- Optimize database interactions in .NET/C# web applications, ensuring efficient ORM (Entity Framework) performance.
- Work on data migration strategies for on-premise to cloud (Azure SQL, AWS RDS, etc.) transitions.
- Create reporting solutions using SQL Server Reporting Services (SSRS) by analyzing user needs and information availability.
- Perform data model management and version control using industry standard tools.
- Reverse engineer and document database architecture for business-critical legacy databases.
- Work closely with business analysts, subject matter experts and development teams in design, development, testing, implementation, and support of application projects.
- Facilitate creation, migration and maintenance of database objects across development/QA/production environments.
- Define and implement data testing strategies with business stakeholders, application development teams and QA groups.
- Participate in the software testing process, including identification and resolution of defects.
- Contribute to and support roll-out strategies.
- Participate in and contribute to formal/informal technical reviews and presentations.
- Understand other database platforms like Oracle, MySQL and IBM DB2.
- Understand high level application architecture/design, network design, performance constraints and security frameworks.
- Apply technical knowledge to determine solutions and solve complex problems.
- Estimate time required to complete tasks accurately, prioritize multiple tasks effectively, and ensure issues are identified, tracked, reported, and resolved in a timely manner.
Minimum Qualifications
- A baccalaureate degree in computer science, engineering or a related field from an accredited college and four years of satisfactory full-time experience related to IT automation engineering, monitoring engineering, management of infrastructure; or
- Eight years of satisfactory full-time experience related to IT automation engineering, monitoring engineering, management of infrastructure;
- Education and/or experience which is equivalent to "1" or "2" above.
- 5 years of experience in SQL Server, T-SQL, data modeling, database query optimization, SSIS, SSAS, and SSRS. - 2 years of expertise in MS-SQL Server database administration, utilities and tools. - 4 years of application data modeling experience using tools like ERwin or ER/Studio. - Microsoft/Azure Database Developer certifications. - Proficiency in supporting MS-SQL Server 2017/2019/2022 databases in high availability environments with intimate knowledge of both SQL and T-SQL. - Demonstrated knowledge of designing, developing and integrating databases, data warehouses and multidimensional databases in MS-SQL Server. - Working knowledge on cross-platform databases like MySQL/Oracle/DB2. - Ability to write and optimize complex SQL queries, procedures and functions. - Familiarity with SSRS, SSAS, SSIS and data warehousing concepts like ETL, Dimensions, Facts, Cubes. - Experience with database replication techniques. - Ability to perform both database-level and operating system performance tuning and monitoring. - Experience in code migration, database change management and data management through the various stages of the development life cycle. - Strong analytical, decision-making and problem-solving skills. - Good communication, presentation and leadership skills. - Team player who can establish excellent working relationships with peers and other teams. - Ability to work on multiple projects as team lead or team member. - Ability to understand business requirements and estimate for delivery commitments. - Experience involving all phases of the Software Development Lifecycle and exposure to Agile/Scrum environments. - Experience with version control and release management principles.
This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.
Public Service Loan Forgiveness
As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/
Residency Requirement
New York City residency is not required for this position.
Additional Information
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.
