Senior Database Manager - Street Furniture Unit

The Office of Livable Streets (OLS) is tasked with prioritizing strategic planning community engagement research policy design implementation and longterm management. Their goal is to create streets that are livable supporting safety accessibility inclusion resiliency active modes community cohesion and economic vitality citywide. Additionally they aim to enhance New York Citys pedestrian bicycle and micromobility networks providing comfortable connected green and reliable transportation options across the five boroughs. They place special emphasis on Priority Investment Areas mode shift and reimagining streets. The office also develops innovative new programs design typologies project delivery and analysis tools to meet the demands of a rapidly changing population with evolving needs and technologies. SFU manages the procurement planning installation and maintenance of bike parking benches leaning bars and wayfinding signage for pedestrians cyclists and transit riders throughout New York City. The goal of these programs is to make the city more walkable bikeable and vibrant. SFU tracks the locations conditions planning and maintenance records for all street furniture and adjacent spaces in Microsoft Access and in GIS datasets records information about the elements using SharePoint forms and custom field applications with the support of NYC DOT IT.

OLS is seeking a talented and motivated individual to serve as a Senior Data Manager within the SFU. Under general supervision from the SFU Deputy Director of Data & Design with wide latitude for independent initiative and judgement the Senior Data Manager will manage the SFUs Microsoft Access and other database management systems including maintenance and cybersecurity of existing databases; integrate SharePoint lists and forms and PowerBi visualizations; coordinate with NYC DOT IT to lead secure expansion transition or integration of other database systems including the Microsoft Dataverse; and work with the Senior Project Manager and NYC DOT IT on coordination with SFUs geospatial data. The Senior Data Manager will be responsible for troubleshooting daytoday database issues; building custom queries forms and reports to assist staff with daily tasks; training and guiding staff on workflows and best data practices; working with staff to identify and implement system enhancements and cyber defense tools; streamlining and integrating the units independent databases into a unified database; adding new integrated processes for tracking assets and inventory and other needs as they arise; scripting and automating for improved efficiency; collaborating with the Senior Project Manager for ongoing integration with GIS geospatial datasets and software systems (e.g. ArcGIS desktop ArcGIS Pro ArcGIS Online QGIS et al); staying updated with emerging software development trends technologies cybersecurity tools and best practices to enhance skills and knowledge; working with NYC DOT IT on licensing software and other needs as they arise; providing unit support of these and all additional technologies and serving as a liaison on these matters with NYC DOT IT; documenting database systems programs and procedures manuals; supervising data entry and analysis including general queries using Microsoft Access Microsoft PowerApps and other software as needed to support tracking inspecting and reporting; working with NYC DOT IT on analyzing network traffic to identify anomalous activity and potential threats; performing special project work of complex technical difficulty; advising and assisting other units within the Office of Livable Streets (OLS) on database matters as subject matter expert.

The Division of Transportation Planning and Management (TPM) is responsible for the safe efficient and environmentally responsible movement of people and goods on the Citys streets supporting the larger goals of economic and social vitality for people living working and doing business in New York City. The Divisions responsibilities include planning street design technical analysis signs transit development freight mobility and markings ensuring the safety of motor vehicle occupants pedestrians and cyclists. The Department of Transportations (DOT) mission is to provide for the safe efficient and environmentally responsible movement of people and goods in the City of New York and to maintain and enhance the transportation infrastructure crucial to the economic vitality and quality of life of our primary customers City residents. DOT is an equal opportunity employer committed to recruiting and maintaining a diverse workforce in an open and inclusive environment.

Preferred Skills
Demonstrated expertise building and maintaining Microsoft Access databases including tables forms queries; experience working with relational databases similar to Microsoft Access such as PostgreSQL; experience building migrating and managing data in the Microsoft Dataverse and using PowerApps for building custom tools; experience automating data processes using VBA Macros Python etc.; experience working with GIS software (ArcGIS Pro AGOL QGIS et al) and integration with relational databases; excellent organizational skills and an ability to focus on details and respond quickly to requests; strong analytical/critical thinking skills and the ability to troubleshoot and solve problems with innovative solutions; detail orientated with a commitment to writing and maintaining clear system documentation; excellent timemanagement skills

Additional Information
This position may be eligible for remote work up to 2 days per week pursuant to the Remote Work Pilot Program agreed to between the City and DC37.

Work Location:
55 Water St NY NY 10041

Hours/Shift:
35 hrs. per week / 9am5pm

To Apply
All resumes are to be submitted electronically using one of the following methods:
Current city employees please log on into Employee Self Service at follow the Careers Link. Job ID #: 689520
All other applicants please go to and search for the Job ID #: 689520
No phone calls faxes or personal inquiries permitted.
Only applicants under consideration will be contacted.
Most public libraries have computers available for use.
For more information about DOT visit us at:

Qualifications :

1. A baccalaureate degree from an accredited college including or supplemented by twentyfour (24) semester credits in cyber security network security computer science computer programming computer engineering information technology information science information systems management network administration or a pertinent scientific technical or related area; or

2. A fouryear high school diploma or its equivalent approved by a States department of education or a recognized accrediting organization and three years of satisfactory experience in any of the areas described in 1 above; or

3. Education and/or experience equivalent to 1 or 2 above. College education may be substituted for up to two years of the required experience in 2 above on the basis that sixty (60) semester credits from an accredited college is equated to one year of experience. In addition twentyfour (24) credits from an accredited college or graduate school in cyber security network security computer science computer programming computer engineering information technology information science information systems management network administration or a pertinent scientific technical or related area; or a certificate of at least 625 hours in computer programming from an accredited technical school (post high school) may be substituted for one year of experience.

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