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 groundup 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/planning to access the full listing of job opportunities and to learn more about the agencys services.

THE DIVISION
Information Technology Divisions (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 citizencentric 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 productivityenhancing technology tools in a hybrid mode (on premise and in the cloud) to support DCPs 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 geoprocessed 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 mapbased 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
ITDs 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 handson experience with TSQL data modeling database query optimization SSIS SSAS and SSRS to support enterprise applications and datadriven solutions. The candidate will play a crucial role in designing developing and maintaining the next generation GeoSupport system services and applications collaborate with crossfunctional teams to deliver highquality 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 Developers 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 TSQL 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 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 onpremise 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 businesscritical 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 rollout 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

Qualifications :

1. A baccalaureate degree in computer science engineering or a related field from an accredited college and four years of satisfactory fulltime experience related to IT automation engineering monitoring engineering management of infrastructure; or

2. Eight years of satisfactory fulltime experience related to IT automation engineering monitoring engineering management of infrastructure;

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

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 individuals sex race color ethnicity national origin age religion disability sexual orientation veteran status gender identity or pregnancy.

Remote Work :

No

Employment Type :

Fulltime