Senior Database Developer

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:

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

IT AUTOMATION AND MONITORING E - 95712

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

2. Eight years of satisfactory full-time experience related to IT automation engineering, monitoring engineering, management of infrastructure;

3. Education and/or experience which is equivalent to "1" or "2" above.

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.