Job Information
City of New York Database Administrator for the Division of HPD Tech in New York, New York
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. HPD Tech is committed 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.
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:
HPD is seeking a SQL Database Administrator. This position will manage the day-to-day operation activities and operating functions with the high degree of administrative responsibilities. This position is a full performance level Database Administration position managing several 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.
Your Role:
The selected candidate will be required to perform, and in some cases, oversee tasks related to database and data transformation activities. Candidate will be responsible for support of the HPD Section 8 Business Unit utilizing Microsoft SQL server environment integrated to an Enterprise Oracle database. The supporting systems application is called Elite created by Emphasys Computer Solutions.
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.
Required Experience:
Database Management: 5 years
Configuration Management: 5 years
Troubleshooting: 5 years
SQL Server: 5 years
Documentation: 4 years
Project Leader: 2 years
Experience with coordinating multiple ongoing projects with a high level of technical complexity
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:
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
May supervise a unit in the temporary absence of the supervisor and may perform the duties of that position.
Routinely serves as in-house expert in specified disciplines.
Preferred Skills:
Microsoft Certified Solutions Associate (MCSA)
More than 7 years of working experience administering complex SQLServer and/or Oracle environment.
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 communication 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.
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.
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.
NOTE: Only those candidates under consideration will be contacted. This position is open to applicants who filed for an exam or those who are already permanent in the Computer Specialist (Software) title.
Please indicate in your cover letter whether you have filed for an exam or are already permanent in the Computer Specialist (Software) title. Applicants who filed for an exam will be required to produce a copy of their Order Confirmation Receipt at time of interview for verification.
This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program agreed to between the City and various unions.
NYC residency is not required.
Qualifications
(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.
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.