Location: New York,NY, USA
Job Description
About the Agency:
The New York City Department of Housing Preservation (HPD) promotes quality and affordability in the city's housing, and diversity and strength in the citys 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 citys history. This investment, coupled with a commitment to reduce administrative and regulatory barriers, is a multi-pronged strategy to tackle New York Citys 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 agencys 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 Chief Technology Officer, within the unit of Infrastructure DBA, you will be the Executive Director 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, judgment, 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 for 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 activities like demolition which are critical to the health, life and safety of the residents on 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.
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:
- 10+ years of working experience administering complex Oracle environments and strong knowledge of Oracle (Ideally 19c).
- Minimum of 10 years of progressive industry experience in the field of database design and data architecture.
- Ability to work with senior project manager, application designers, developers, business analysts and users to define the information needs of the organization.
- Extensive working experience in third normal form (3NF) database normalization modeling.
- Excellent communication skills in both technical and non-technical forms.
- Strong proficiency in a database SQL language.
- Experience in debugging and optimizing SQL queries.
- Knowledge and experience with SQL reporting tools and utilities is a plus.
- Good understanding of ETL concepts and proficient in transformation tools like ODI and/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).
- Knowledge and experience with MS SQL Server, will be preferred.
- Highly self-motivated and directed with keen attention to detail.
- Experience working in a team-oriented, collaborative environment.
- Knowledge of applicable data privacy practices and laws.
- Strong problem-solving skills and decision-making abilities. Willingness to face the challenge of multi-layer complex problems.
- Oracle Certification.
- MS SQL Server certification.
Qualifications
1. A baccalaureate degree from an accredited college and four years of satisfactory full-time experience related to the area(s) required by the particular position; or,
2. Education and/or experience which is equivalent to 1 above.
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.