Apply

Salary range: $137,807.00 – $147,807.00

About the Agency:
The New York City Department of 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.

HPD is entrusted with fulfilling these objectives through the goals and strategies of “Housing Our Neighbors: A Blueprint for Housing and Homelessness,” Mayor Adams’ comprehensive housing framework. To support this important work, the administration has committed $5 billion in new capital funding, bringing the 10-year planned investment in housing to $22 billion the largest in the city’s history. This investment, coupled with a commitment to reduce administrative and regulatory barriers, is a multi-pronged strategy to tackle New York City’s complex housing crisis, by addressing homelessness and housing instability, promoting economic stability and mobility, increasing homeownership opportunities, improving health and safety, and increasing opportunities for equitable growth.
Your Team:
Housing Preservation & Development Technology (HPD Tech) is the IT division within HPD. The Office of HPD Tech leads the agency’s effort to transform HPD through technology by promoting productivity and eliminating manual processing, shrinking costs, and increasing the pace of work. HPD Tech works to improve effectiveness of business processes using core applications for flawless execution. HPD Tech empowers decision makers with access to quality (complete and accurate) information to anticipate and pro-actively react to building, neighborhood and market conditions.
The Office of HPDTech is composed of 7 units: CIO (Chief Information Office), CTO (Chief Technology Office), CPO (Chief Product Office), Budget, Enterprise Architecture, Planning & Compliance and Information Security.
Your Impact:
Under the supervision of the Associate Commissioner and the Chief Technology Officer, within the unit of Infrastructure DBA, you will be the Executive Director of Database Administration for the Division of HPD TECH. The candidate will be under varying levels of managerial or executive direction, with varying degrees of latitude for independent initiative, judgement, and decision-making, you will perform complex professional managerial tasks in supervising and guiding the database administration team in day-to-day operations of all database and data transformation activities in both Oracle and MS SQL Server platforms to HPD.
The Infrastructure Database Administration (DBA) is responsible for databases related to health, life and safety applications and plays a critical role in ensuring the integrity, security, and performance of these databases. Some of the applications (but not limited to) are critical to the agency in collecting Heat and Emergency Complaints from the residents is the 311 systems. In addition, HPDInfo and Real-Time Field Force (RTFF) applications are responsible for Lead and Heat Inspections, capturing and certification violations and tracking of activities like demolition which are critical to the health, life and safety of the residents of the city. There are a multitude of applications that support mandates for which the agency has to comply. Since the underlying database that supports all the above applications are under the domain of the DBA, the position is very critical to the ongoing operations of the agency and continued support to the health and safety of NYC residents.
Your Role:
Your role will include, but are not limited to, be to oversee installation, maintenance, and configuration of database servers, new software installations, organization, and support of enterprise relational database systems, both internal and external applications, and multiple environments including hardware, network, and interface implications. Supervise and direct database creation, maintenance, performance tuning, advanced backup, recovery, and database upgrade efforts. Lead the team through SDLC phases as per application design specifications. Lead the team proactively analyze, identify, and implement performance improvements. Collaborate with stakeholders of the subject matters and other teams and support database application development and postproduction enhancement. Explore new ideas and initiatives that encourage innovations.
Your Responsibilities:
The responsibilities for this position include project managing, researching, planning and executing database, server and storage upgrades. You will be expected to prepare, update and maintain technical and non-technical documentation, storage diagrams for both ASM and non-ASM environments, and performance reports. The candidate will install/configure new databases in both RAC and non-RAC environments. You will have to troubleshoot database problems in both production/non-production environments, lead Root cause analysis (RCA) process and ensure all fixes are fully implemented. You will use appropriate tuning methodology and tools (such as AWR, ADDM, ASH, autotrace) to triage and resolve performance problems. The candidate will collaborate with subject stakeholders, application teams and administration teams to design, size and plan new environments. Additionally, you must support standard mailbox type requests, scheduled and emergency maintenance events.
Required Skills

• Database administration and maintenance: 10 years.
• Database configuration: 10 years.
• Troubleshooting: 10 years.
• Oracle database administration: 10 years.
• MS SQLServer database administration: 10 years.
• Technical and non-technical documentation: 10 years.
• Prior work experience with database design, implementation, and administration using Oracle 19c (or higher) in both production and non-production environments.
• Technical expertise in writing PL/SQL and T-SQL, packages, stored procedures, user defined functions, triggers, and/or views.
• Prior experience with file processing/data import/export between different environments with a keen eye to accuracy.
• Through understanding of database maintenance practices including index management, backup strategies and disk space requirements.

Preferred Skills

• Extensive working experience in third normal form (3NF) database normalization modeling.
• Good understanding of ETL concepts and proficient in transformation tools like ODI an/or Informatica.
• Considerable working knowledge/experience in data integration tools (SSIS etc.), data modeling tools (ERWIN, TOAD, SSMS, etc), and reporting tools (SSRS, PowerBI, etc.).
• Oracle & MS SQL Server Certification.

Minimum Qualifications

55a Program

Public Service Loan Forgiveness

Residency Requirement

Additional Information