Database Support Specialist for the Division of Data Management and Technology (DMT)

About the Agency:

The NYC Department Housing Preservation & Development (HPD) promotes quality and affordability in the city's housing, and diversity and strength in the city’s neighborhoods because every New Yorker deserves a safe, affordable place to live in a neighborhood they love.

- We maintain building and resident safety and health

- We create opportunities for New Yorkers through housing affordability

- We engage New Yorkers to build and sustain neighborhood strength and diversity.


Your Team:


The Office of Enforcement and Neighborhood Services (OENS) leads the agency’s effort to work closely with other HPD divisions and outside community partners to identify buildings in distress, assess and develop appropriate strategies to address those properties and work closely with responsible owners to develop a plan to improve conditions and return buildings to firm financial footing and physical health. OENS uses enforcement tools within its Division of Code Enforcement, Housing Litigation Division, Emergency Operations and Enhanced Enforcement, and the Division of Neighborhood Preservation to ensure compliance with legal and regulatory obligations.


The Office of Enforcement and Neighborhood Services is composed of seven divisions: Data Management & Technology (DMT), Division of Neighborhood Preservation (DNP), Administration & Internal Compliance (AIC), Housing Litigation Division (HLD), Division of Code Enforcement (DCE), and Emergency Operations and Enhanced Enforcement Division (EOD) and Division of Emergency Housing Services (EHS).


Your Impact:


The Data Management and Technology Unit (DMT) is a vital part of the Office of Enforcement and Neighborhood Services, actively supporting all reporting functions. Through data collection, studies, and analyses, the DMT unit continually formulates strategies to assist the office in meeting its responsibilities. It leads the development and oversight of analysis and preservation planning across all operations and initiatives. By leveraging performance-based indicators, the unit performs strategic management assessments and forecasting, which inform the refinement and redesign of program plans to further the Enforcement and Neighborhood Services mission.


The Database Support Specialist/Certified IT Administrator (Database) will contribute to enhancing HPD’s effectiveness by developing, analyzing and optimizing ENS operations. This involves analyzing data to provide actionable insights for ENS divisions and strengthening the agency’s overall capacity to utilize data effectively.


As a Database Support Specialist/Certified IT Administrator (Database), you will deploy data tools that enhance ENS capacity to operate as a data-driven division. Your work will help cultivate a robust, wide data culture one where insights are actively used to strengthen Enforcement and Neighborhood Services (ENS) operations and drive improved outcomes.


Your Role:


The Database Support Specialist/Certified IT Administrator (Database) is a highly technical role responsible for the planning, design, configuration, testing, troubleshooting, integration, performance monitoring, enhancement, and overall support of complex database systems. Includes technical writing, end user support, and participation in group projects.


Your Responsibilities:


- Plan, design, configure, test, troubleshoot, integrate, and maintain database systems and related components.

- Monitor database performance and implement enhancements to ensure optimal system functionality.

- Conduct data auditing, and documentation of database environments.

- Identify, track, and resolve database-related incidents and service requests.

- Provide technical support to end users and collaborate with cross-functional teams.

- Prepare technical documentation, reports, and procedural guidelines.

- Develop and maintain dashboards that deliver critical insights into ENS' ERP Lead Paint Removal-LL #1 operations and outcomes, partnering closely with ERP program teams to grasp their goals and data requirements.

- Work alongside ENS' ERP Lead Paint Removal-LL #1program and technical staff to plan and support the advancement of Lead Paint Removal intelligence initiatives.

- Lead special projects focused on analyzing data pertinent to ENS' ERP Lead Paint Removal-LL #1 programs.


Preferred Skills:


The ideal candidate will be an inquisitive self-starter, collaborator, and problem-solver with the following skills:


- Strong technical and analytic skills and comfort working with data.

- Experience with business intelligence tools, experience with visualizing data or building dashboards.

- Strong attention to detail, with the ability to maintain a comprehensive project view while also keeping an eye on details.

- Strong interpersonal and communication skills, comfortable working with staff at all levels and asking thoughtful questions to ensure understanding.

- Collaborative, team player with the ability to also drive projects forward independently.

- Enthusiastic about using data to improve government programs and policies.

- Must have advanced Microsoft Excel skills, experience with SQL developer, and Microsoft Access.

Authorization to work in the United States is required for this position. The NYC Department of Housing Preservation and Development does not provide sponsorship for international employees for visa applications, extensions, or status changes, including H-1B visas. Applicants are responsible for ensuring that they meet all qualifying requirements for this position at the time of application.

CERT IT ADMINISTRATOR (DB) - 13644

Professional/Vendor Certification(s) in database administration that is required for the position to be filled. In addition, you must have one of the following:
1. A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management;

2. A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience (IT) of which at least two years must have been database administration experience as described in "1" above; OR

3. A satisfactory equivalent of education and/or experience equivalent to “1” or “2” above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from
an accredited college or university is equivalent to 6 months of information technology experience, but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college or university may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in "1" 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.