Unit Head - Asset Management

OFFICE OF MANAGEMENT & BUDGET; New York (NY); Hybrid; USD 103,000 - 140,000; Full time

Job summary

The Mayor’s Office of Management and Budget (OMB) in New York City is seeking a Unit Head to lead the database administration for the Asset Inventory Management System (AIMS). You will ensure reliable day-to-day operations, maintain access controls, and collaborate with central IT on server-level tasks.

Ideal candidates have a CS or related degree and at least four years of DB administration or software engineering experience, with strong SQL Server skills and a track record of clear

Qualifications

• A baccalaureate degree from an accredited college in computer science, software engineering, or a related field.
• Four years of relevant experience in database administration or software engineering, or a master's degree in computer science, software engineering, or a related field.
• Strong SQL Server and relational database experience in production environments.
• Clear written communication and documentation discipline for stakeholders.
• Familiarity with application development concepts and collaboration with software developers.
• Proficiency in Python.
• Proficiency in Microsoft Excel and Access.

Responsibilities

• Administer the AIMS SQL Server database to support reliable day-to-day operations and required outputs.
• Create and maintain clear documentation for core database operations, including runbooks and recovery steps.
• Partner with central IT on security and operational controls, including access provisioning and backup/restore validation.
• Support required AIMS deliverables and stakeholder requests by troubleshooting issues and maintaining data quality checks.
• Improve reliability and reduce manual effort by designing and optimizing database structures and queries, and by implementing automation.
• Stay current on relevant database and data reliability practices and propose improvements.

Skills

SQL Server

Documentation

App development concepts

Python proficiency

Excel & Access

Public sector interest

Education

CS/SE related degree

4+ years experience or MS

Tools

SSMS

Python

Excel/Access tooling

Job description

TASK FORCE: Value Engineering and Asset Management
UNIT: Asset Management
JOB TITLE: One (1) Unit Head (Database Administration)
CONTROL CODE: TVA-27-01
SUMMARY:
The Mayor’s Office of Management and Budget (OMB) is New York City’s chief financial agency. OMB’s staff of analysts and technical experts assemble and oversee the Mayor’s expense and capital budgets, which fund the services and activities of approximately 90 City agencies and entities. The Asset Inventory Management System (AIMS) program is a Charter-mandated function that maintains the City’s capital plant inventory and condition information, along with agency maintenance schedules and cost estimates. This work is designed to create public accountability for keeping major City assets from buildings to bridges to roads in good repair, strengthening how NYC tracks, maintains, and invests in the assets our communities depend on every day. You will be the database-layer operational owner for AIMS. The role will focus on reliable day-to-day support, clear documentation, and operational continuity through secure access pathways, written runbooks, and repeatable data operations. You will administer the AIMS database and its access controls, and partners with central IT for server-level operations (patching, infrastructure, and enterprise monitoring). We are looking for someone who is motivated by public-service outcomes and enjoys making complex systems more reliable, understandable, and well-documented. This role fits someone who learns quickly, communicates clearly, and takes ownership of getting important work across the finish line.
JOB DESCRIPTION:
The duties of the position include the following:

• Administer the AIMS SQL Server database to support reliable day-to-day operations and required outputs.
• Create and maintain clear documentation for core database operations, including runbooks for access checks, common failure modes, recovery steps, and recurring reporting workflows.
• Partner with central IT on security and operational controls, including database access provisioning, role design, periodic access reviews, and backup/restore validation.
• Support required AIMS deliverables and stakeholder requests by troubleshooting issues, maintaining data quality checks, and making key workflows more repeatable.
• Improve reliability and reduce manual effort by designing and optimizing database structures and queries, and by implementing pragmatic automation (e.g., using Python or SQL).
• Stay current on relevant database and data reliability practices, and propose improvements that fit within enterprise constraints.

EXPERIENCE AND QUALIFICATIONS:
Minimum Qualification Requirements:

• A baccalaureate degree from an accredited college in computer science, software engineering, or a related field.
• Four years of relevant experience in database administration or software engineering, or a master's degree in computer science, software engineering, or a related field.

Preferred Skills:

• Strong SQL Server and relational database experience in production environments, including database-layer administration and access controls.
• Clear written communication and documentation discipline (runbooks, diagrams, and “what changed and why”) for both technical and non-technical stakeholders.
• Familiarity with application development concepts, and the ability to partner with, or manage, software developers building user-facing tools on top of SQL Server.
• Proficiency in at least one general-purpose programming language (e.g., Python).
• Proficiency in Microsoft Excel and Access.
• Interest in public-sector infrastructure and asset condition data is a plus.

Unit Head ($121,768): A baccalaureate degree from an accredited college in computer science, software engineering, or a related field. A minimum of four years of relevant experience in database administration or software engineering, or a master's degree in computer science, software engineering, or a related field.
THE OFFICE OF MANAGEMENT AND BUDGET AND THE CITY OF NEW YORK ARE INCLUSIVE EQUAL OPPORTUNITY EMPLOYERS 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.
You must be a City resident within 90 days of the date of appointment and you must be legally eligible to work in the United States.
This is a hybrid position with in-person days located at OMB’s offices at 255 Greenwich Street
BUDGET ANALYST (OMB) - 06088

Minimum Qualifications

1. A baccalaureate degree from an accredited college.

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 generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.

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.