Current jobs related to Database Administrator for the Division of HPD Tech - New York - City of New York
-
Software Engineer
7 days ago
New York, New York, United States City of New York Full timeAbout the Organization:The New York City Department of Housing Preservation (HPD) is dedicated to enhancing the quality and affordability of housing across the city, fostering diversity and resilience in neighborhoods, as every resident deserves a secure and affordable home in a community they cherish.Our mission includes maintaining the safety and health of...
-
New York, United States City of New York Full timeJob DescriptionAbout 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...
-
New York, United States City of New York Full timeJob 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 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...
-
Attorney for the Housing Litigation Division
2 weeks ago
New York, United States City of New York Full timeJob Description About the Agency: The New York City Department of Housing Preservation and Development (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...
-
New York, United States City of New York Full timeJob 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...
-
New York, United States City of New York Full timeJob 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...
-
New York, New York, United States City of New York Full timeAbout the RoleThe City of New York is seeking a highly skilled Agency Attorney L2 to join the Housing Litigation Division. As a key member of the team, you will play a critical role in enforcing the NYC Housing Maintenance Code and NYS Multiple Dwelling Law in the Housing Part of New York City Civil Court and on occasion in NYS Supreme Court.Key...
-
New York, United States City of New York Full timeJob 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...
-
Technology Trainer
2 months ago
New York, United States City of New York Full timeJob 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 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...
-
New York, United States City of New York Full timeJob Description About the Agency: The New York City Department of Housing Preservation and Development (HPD) is the nations largest municipal housing preservation and development agency. Its mission is to promote quality housing and diverse, thriving neighborhoods for New Yorkers through loan and development programs for new affordable housing, preservation...
-
Housing Incentives Intake Coordinator
5 days ago
New York, New York, United States City of New York Full timePosition Overview:The New York City Department of Housing Preservation and Development (HPD) is dedicated to ensuring quality and affordability in housing across the city, fostering diversity and resilience in neighborhoods, as every resident deserves a secure and affordable home in a community they cherish.We prioritize the safety and health of buildings...
-
Housing Incentives Intake Coordinator
1 week ago
New York, New York, United States City of New York Full timePosition Overview:The City of New York's Department of Housing Preservation and Development (HPD) is dedicated to ensuring quality and affordability in housing across the city, fostering diversity and resilience in neighborhoods, as every resident deserves a secure and affordable home in a community they cherish. We prioritize the safety and health of...
-
Housing Incentives Intake Coordinator
1 week ago
New York, New York, United States City of New York Full timePosition Overview:The City of New York's Department of Housing Preservation and Development (HPD) is dedicated to enhancing the quality and affordability of housing across the city, fostering vibrant and diverse neighborhoods, as every resident deserves a secure and affordable home in a community they cherish.We prioritize the safety and health of buildings...
-
Database Administrator
7 days ago
New York, United States Lynx Technology Partners Full timeJob DescriptionJob DescriptionThis is a remote position. Summary:Lynx Technology Partners is seeking an experienced and skilled Database Administrator to manage and optimize our clients' database systems. The ideal candidate will have over 5 years of hands-on experience with SQL Server, a deep understanding of database technical design, storage...
-
Family Self Sufficiency Case Manager
2 months ago
New York, United States City of New York Full timeCompany DescriptionJob Description About HPD: The New York City Department of Housing Preservation and Development (HPD) is the nation's largest municipal housing preservation and development agency. Its mission is to promote quality and affordability in the city's housing, and diversity and strength in the city's neighborhoods because every New Yorker...
-
Maintenance Coordinator
2 months ago
New York, United States PROMESA R.H.C.F. Full timeJob DescriptionJob DescriptionPOSITION OVERVIEW: The Maintenance Coordinator is the point person for all Municipal Violations within the affordable housing division. Duties will include coordination between residents and the staff that are assigned to address the violation, including handling administrative processes required for removal from municipal...
-
Maintenance Coordinator
3 months ago
New York, United States PROMESA R.H.C.F. Full timeJob DescriptionJob DescriptionPOSITION OVERVIEW: The Maintenance Coordinator is the point person for all Municipal Violations within the affordable housing division. Duties will include coordination between residents and the staff that are assigned to address the violation, including handling administrative processes required for removal from municipal...
-
Database Administrator
5 months ago
New York, United States ragns Full timeJob descriptionPosition summaryA MS SQL Database Engineer w ho is comfortable working within a matrixed environment and is focused on providing operational excellence within the MS SQL platform this experienced database administrator will possess broad technical knowledge and bring an established work history with Microsoft SQL S erver to a...
-
Database Administrator
3 months ago
New York, United States Stone Search Full timeJob DescriptionJob DescriptionDatabase Administrator*US Citizens or GC HoldersLocation: NYC- hybrid remote- a few days on-siteSkills:Develop, modify, and implement changes as needed to resolve user-reported issues (critical and non-critical basis).Manage and monitor database performance, functionality, and capacity. Provide suggestions to optimize...
-
Database Administrator
1 month ago
New York, United States Michael Page Full timeFull time opportunity offering competitive base and discretionary bonus.Join an established law firm! About Our Client The client is an established law firm. Job DescriptionInstall and upgrade database servers and application tools, and plan system storage requirements.Enroll users, maintain system security, and control user access to the database.Monitor...
Database Administrator for the Division of HPD Tech
1 month ago
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.
