Database Manager, OLS

Job Description

**To be considered for this position, candidate must be serving permanently in the title of Cyber Security Analyst, be reachable on civil service list #5061, or be eligible under the 55a program. **

Transportation Planning and Management (TPM) is responsible for the safe, efficient, and environmentally responsible movement of people and goods on the City's streets, supporting the larger goals of economic and social vitality for people living, working, and doing business in New York City. The Division’s 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 Office of Livable Streets (OLS) is tasked with prioritizing strategic planning, community engagement, research, policy, design, implementation, and long-term 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 City's 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.

OLS is seeking a Cyber Security Analyst to serve as a Database Manager within the Street Furniture Unit (SFU). 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 works closely with other units within TPM to plan, install, and maintain these street furniture elements throughout the five boroughs. SFU tracks the locations, conditions, planning, and maintenance records for all street furniture and adjacent spaces in Microsoft Access and in GIS datasets, Increasingly, SFU records information about the elements using SharePoint forms and custom field applications with the support of NYC DOT IT.

Under general supervision from the SFU Deputy Director of Data & Design, with latitude for independent initiative and judgement, the Database Manager will work to manage SFU’s Microsoft Access and other databases; integrate SharePoint lists and forms; create Power BI dashboards; and coordinate with NYC DOT IT on secure expansion, transition, and/or integration with other Microsoft data systems. The Database Manager will primarily be responsible for helping manage existing databases and optimizing our systems and processes. This entails troubleshooting day-to-day 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; streamlining and integrating the unit’s 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 closely 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); document database systems, programs, and procedures manuals; update and maintain new and existing documentation; perform data entry and analysis including general queries using Microsoft Access, Microsoft PowerApps, and other software as needed to support tracking, inspecting, and reporting; 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; provide unit support of these and all additional technologies and serve as a liaison on these matters with NYC DOT IT; working with NYC DOT IT on analyzing network traffic to identify anomalous activity and potential threats; perform special project work of complex technical difficulty; advise and assist other units within the Office of Livable Streets (OLS) on database matters. The candidate will work collaboratively and inclusively.

The Department of Transportation’s (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 emp