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 HPD Tech is composed of 9 units: CIO, Budget, Enterprise Architecture, Ideation, Infrastructure Network and Systems, Planning & Compliance, Product Area, Release & Security Management, and Security.

Your Impact:

As the Database Administrator for Division of HPD Tech, you will be required to perform, and in some cases, oversee tasks related to database and data transformation activities for Department of Tenant Resource. Duties include, but are not limited to; modeling, developing, designing, implementing, enhancing, maintaining, and analyzing databases for multiple software systems and legacy applications. Ensure that data model and database design conform to the overall data modeling standards, guidelines, best practices and approved modeling techniques and approaches. Assist in maintaining an enterprise-level data dictionary by documenting all entities, their relationships, and all data attributes for the agency. Work jointly with the team in developing the data objects and data models to support data services under a service-oriented architecture approach.

Your Role:

Your role will be to manage several Department of Tenant Resource databases within Housing Preservation and Development’s operating systems environment. This position will serve as Database Administrator for the development and production of SQL Databases and be responsible for new software installs, organization, installation and support of enterprise relational database management systems, multiple applications, and multiple environments including hardware, network, and interface implications. Duties include database creation, maintenance, tuning, advanced backup, and recovery.
Required Experience:

- Database Management: 5 years
- Configuration Management: 5 years
- Troubleshooting: 5 years
- SQL Server: 5 years
- Documentation: 4 years
- Prior work experience with database design, implementation and administration; using MS SQL Server 2005 (or higher) in production environment.
- Technical expertise in writing optimal T-SQL queries, stored procedures, user defined functions/views.
- In-depth knowledge and hands-on developing, deploying, and maintaining complex Server Integration Services (SSIS) packages.
- Prior experience with file processing/data imports into databases with a keen eye to accuracy.
- Through understanding of database maintenance practices, including index management, backup strategies and disk space requirements.
Your Responsibilities:
- Provide significant security policy direction to protect the organizations' digital assets.
- Designs logical and physical databases or reviews description of changes to database to understand how changes to be made affect physical database. Communicates with managerial, administrative, and technical staff to determine information needs data flows and systems definitions.
- Manages the distribution and retention of data on various storage devices.
- Provides day to day advice to users on data structures and terminology and develops policies and procedures related to the support and maintenance of database applications.
- Provides input for strategic planning.
- Performs database administration duties, including installation, patching, backup and recovery management, space management, schema management, startup, and shutdown.

(1) A baccalaureate degree from an accredited college, including or supplemented by twenty-four (24) semester credits in computer science or a related computer field and two (2) years of satisfactory full-time software experience in designing, programming, debugging, maintaining, implementing, and enhancing computer software applications, systems programming, systems analysis and design, data communication software, or database design and programming, including one year in a project leader capacity or as a major contributor on a complex project; or
(2) A four-year high school diploma or its educational equivalent and six (6) years of full-time satisfactory software experience as described in “1" above, including one year in a project leader capacity or as a major contributor on a complex project; or
(3) A satisfactory combination of education and experience that is equivalent to (1) or (2) above. College education may be substituted for up to two years of the required experience in (2) above on the basis that sixty (60) semester credits from an accredited college is equated to one year of experience. A masters degree in computer science or a related computer field may be substituted for one year of the required experience in (1) or (2) above. However, all candidates must have a four year high school diploma or its educational equivalent, plus at least one (1) year of satisfactory full-time software experience in a project leader capacity or as a major contributor on a complex project.
NOTE: In order to have your experience accepted as Project Leader or Major Contributor experience, you must explain in detail how your experience qualifies you as a project leader or as a major contributor. Experience in computer operations, technical support, quality assurance (QA), hardware installation, help desk, or as an end user will not be accepted for meeting the minimum qualification
requirements.
Special Note
To be eligible for placement in Assignment Level IV, in addition to the Qualification Requirements stated above, individuals must have one year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration, database management systems, operating systems, data communications systems, capacity planning, and/or on-line applications programming.

- Microsoft Certified Solutions Associate (MCSA). - More than 7 years of working experience administering complex SQL Server and/or Oracle environments - Minimum of 8 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 verbal and writing skills. - Possess proficiency in a database SQL language. - Experience in debugging and optimizing SQL queries. - Proficiency in PL/SQL - Knowledge and experience with SQL reporting tools and utilities is a plus. - Good understanding of ETL concepts and proficient in transformation tools in Server Integration Services (SSIS). - Considerable working knowledge with Erwin Data Modeler. - Ability to communicate ideas in both technical and non-technical forms. - 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. - Efficient problem solving and decision-making abilities - we often work on problems that have multiple layers of complexity and are looking for someone who likes a challenge. - Strong knowledge of SQL Server (Ideally 2017+) - Tuning queries to improve performance.

This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.

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/

New York City Residency is not required for this position

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.