Job Description
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.
Qualifications
1. A master’s degree in computer science from an accredited college or university and three (3) years of progressively more responsible, full-time, satisfactory experience in Information Technology (IT) including applications development, systems development, data communications and networking, database administration, data processing, or user services. At least eighteen (18) months of this experience must have been in an administrative, managerial or executive capacity in the areas of applications development, systems development, data communications and networking, database administration, data processing or in the supervision of staff performing these duties; or
2. A baccalaureate degree from an accredited college or university and four (4) years of progressively more responsible, full-time, satisfactory experience as described in "1" above; or
3. A four-year high school diploma or its educational equivalent, and six (6) years of progressively more responsible, full-time, satisfactory experience as described in "1" above; or
4. A satisfactory combination of education and experience equivalent to "1", "2" or "3" above. However, all candidates must have at least a four-year high school diploma or its educational equivalent and must possess at least three (3) years of experience as described in "1" above, including the eighteen (18) months of administrative, managerial, executive or supervisory experience as described in "1" above.
In the absence of a baccalaureate degree, undergraduate credits may be substituted for a maximum of two (2) years of the required experience in IT on the basis of 30 semester credits for six (6) months of the required experience. Graduate credits in computer science may be substituted for a maximum of one (1) year of the required experience in IT on the basis of 30 graduate semester credits in computer science for one (1) year of the required IT experience. However, undergraduate and/or graduate credits may not be substituted for the eighteen (18) months of experience in an administrative, managerial, executive, or supervisory capacity as described in "1" above.