Back to jobs

SQL Server Database Administrator for the Division of HPDTech (City HAP Program)

New York City, NY, United States

Actively hiring, first seen by us 1 day ago
Pay
Pay not listedSimilar roles state $127K–$189K
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Administer SQL Server installs, upgrades, patching, and maintenance

  • Run backups, recovery, and disaster recovery planning and testing

  • Tune performance, indexes, and queries; troubleshoot blocking and deadlocks

  • Develop and maintain T-SQL stored procedures, functions, triggers, and views

  • Build and maintain SSIS packages for data migration and integration

From the employer’s posting
Perform day-to-day Microsoft SQL Server database administration, including installation, configuration, upgrades, patching, and maintenance.
Perform database backup and recovery operations, develop recovery strategies, and support disaster recovery planning and testing.
Monitor database performance and troubleshoot issues related to queries, indexes, blocking, deadlocks, resource utilization, and database connectivity.
Develop, optimize, and maintain complex T-SQL queries, stored procedures, user-defined functions, triggers, and views.
Develop, deploy, troubleshoot, and maintain complex SQL Server Integration Services (SSIS) packages for data migration, transformation, and integration.

What you’ll bring

All qualifications

Core experience

  • Strong hands-on experience with Microsoft SQL Server and T-SQL development
  • Experience with stored procedures, functions, views, indexing, and query optimization
Qualification wording
The candidate must have strong hands-on experience with Microsoft SQL Server and T-SQL development
including stored procedures, functions, views, indexing, and query optimization

About City of New York

The Department of Housing Preservation and Development (HPD) oversees housing standards across all 3.7 million homes in New York City.

In the employer’s words · Read in context

Apply at City of New York

Posting record

Report an error

Actively hiringFirst seen by us 1 day ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 20, 20261 day ago
Recorded sightings
2
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$127K–$189K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 1

Early. Similar jobs usually come down between day 6 and day 56.

At City of New York, jobs usually come down by about day 13.

From 14,766 similar postings that came down, and 355 of City of New York’s. Coming down is not always a hire.

City of New York is hiring

44 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring at a steady pace
  • Takes jobs down quickly
  • 36% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • C#
  • SQL
  • T-SQL
  • Oracle
  • SQL Server
  • SSIS
Where the posting names them
Preferred Skills: - Working knowledge and hands-on experience with Oracle database administration. - Experience with .NET (C#) application environments. - Experience supporting enterprise applications and production database environments. - Knowledge of database migration, data conversion, and cross-platform database integration. - Experience with Windows Server environments and basic networking concepts. - Familiarity with database high availability and disaster recovery solutions. - Experience with PowerShell scripting or other database automation tools. - Strong analytical, troubleshooting, documentation, and communication skills. IT PROJECT SPECIALIST - 06797
The City Housing Assistance Program (CHAP) is a City funded rental assistance program administered by the New York City Department of Housing Preservation and Development (HPD). The program provides rental assistance to low-income households with incomes at or below 50% of Area Median Income (AMI) who are at risk of homelessness, including eligible rent-stabilized households facing eviction for nonpayment of rent and certain households residing in shelter who do not qualify for existing rental assistance programs. CityHAP helps eligible households maintain stable, permanent housing by subsidizing their rent, with the household generally contributing 30% of its adjusted monthly income toward rent. The program provides targeted assistance to New Yorkers facing housing instability while helping preserve rent-stabilized housing and prevent homelessness. HPD is seeking an experienced SQL Server Database Administrator (DBA) with additional knowledge and experience in Oracle database administration. This is a full-performance-level database administration position responsible for supporting, maintaining, securing, and optimizing enterprise database environments. Your Role:
Your Role: The selected candidate will primarily serve as a Microsoft SQL Server Database Administrator, responsible for the installation, configuration, administration, maintenance, performance tuning, and support of enterprise SQL Server database environments. The candidate will also provide database administration support for Oracle environments as needed. Your Responsibilities:
The selected candidate will work closely with application developers, infrastructure teams, business analysts, and other technical staff to design, implement, maintain, and troubleshoot database solutions. The role will also involve database modeling, data integration, ETL processes, and the development and maintenance of database objects. The candidate must have strong hands-on experience with Microsoft SQL Server and T-SQL development, including stored procedures, functions, views, indexing, and query optimization. Experience developing, deploying, maintaining SQL Server Integration Services (SSIS) packages and linked server administration is highly desirable. Working knowledge of Oracle database administration, including database maintenance, backup and recovery, performance monitoring, and troubleshooting, is strongly preferred.
Working knowledge of Oracle database administration, including database maintenance, backup and recovery, performance monitoring, and troubleshooting, is strongly preferred. - Perform day-to-day Microsoft SQL Server database administration, including installation, configuration, upgrades, patching, and maintenance. - Administer, monitor, and support SQL Server database environments to ensure high availability, reliability, disaster recovery and optimal performance. - Perform database backup and recovery operations, develop recovery strategies, and support disaster recovery planning and testing. - Manage SQL Server Agent jobs and automate DBA activities using PowerShell and T-SQL. - Monitor database performance and troubleshoot issues related to queries, indexes, blocking, deadlocks, resource utilization, and database connectivity. - Develop, optimize, and maintain complex T-SQL queries, stored procedures, user-defined functions, triggers, and views. - Perform database performance tuning, including execution plan analysis, indexing strategies, statistics maintenance, and query optimization. - Design, implement, and maintain SQL Server databases, schemas, tables, relationships, and database objects. - Develop, deploy, troubleshoot, and maintain complex SQL Server Integration Services (SSIS) packages for data migration, transformation, and integration. - Manage data imports, exports, file processing, and ETL operations while ensuring data accuracy and integrity. - Monitor database capacity, storage utilization, space allocation, and growth to support enterprise applications. - Implement and maintain database security, including user accounts, roles, permissions, authentication, and access controls. - Implement and manage data masking and encryption techniques to protect sensitive and confidential data - Perform database health checks, routine maintenance, and proactive monitoring to identify and resolve potential issues. - Support database migrations, upgrades, and integrations involving SQL Server and Oracle environments. - Collaborate with developers, infrastructure teams, and application support personnel to resolve database-related issues. - Review database designs and application requirements to ensure efficient data structures and database performance. - Develop and maintain technical documentation, database standards, procedures, and operational guidelines. - Provide recommendations for database architecture, capacity planning, performance improvements, and technology upgrades. - Participate in production support, incident resolution, root cause analysis, and change management activities. Required Skills:
Required Skills: - Minimum of 5 years of hands-on experience administering Microsoft SQL Server 2012 or later. - Strong experience with SQL Server installation, configuration, maintenance, upgrades, and patching. - Advanced knowledge of T-SQL, including complex queries, stored procedures, functions, triggers, and views. - Strong understanding of database performance tuning, execution plans, indexing, statistics, and query optimization. - Experience with SQL Server backup and recovery strategies, including full, differential, and transaction log backups. - Experience troubleshooting database performance issues, blocking, deadlocks, and connectivity problems. - Hands-on experience with SQL Server Integration Services (SSIS), including package development, deployment, scheduling, and troubleshooting. - Knowledge of SQL Server Agent jobs, maintenance plans, database monitoring, and automated maintenance processes. - Experience with database security, user management, permissions, and role administration. - Experience with database design, implementation, data modeling, and relational database concepts. - Excellent communication skills, particularly being able to discuss business needs to both technical and non-technical staff - Excellent people skills and the ability to work with a collaborative, team-driven approach - Independent thinking and decision-making skills - Capable of managing multiple tasks in a fast paced, high-volume environment and the ability to adapt plans to unexpected changes Preferred Skills:
The candidate must have strong hands-on experience with Microsoft SQL Server and T-SQL development, including stored procedures, functions, views, indexing, and query optimization. Experience developing, deploying, maintaining SQL Server Integration Services (SSIS) packages and linked server administration is highly desirable. Working knowledge of Oracle database administration, including database maintenance, backup and recovery, performance monitoring, and troubleshooting, is strongly preferred. - Perform day-to-day Microsoft SQL Server database administration, including installation, configuration, upgrades, patching, and maintenance. - Administer, monitor, and support SQL Server database environments to ensure high availability, reliability, disaster recovery and optimal performance. - Perform database backup and recovery operations, develop recovery strategies, and support disaster recovery planning and testing. - Manage SQL Server Agent jobs and automate DBA activities using PowerShell and T-SQL. - Monitor database performance and troubleshoot issues related to queries, indexes, blocking, deadlocks, resource utilization, and database connectivity. - Develop, optimize, and maintain complex T-SQL queries, stored procedures, user-defined functions, triggers, and views. - Perform database performance tuning, including execution plan analysis, indexing strategies, statistics maintenance, and query optimization. - Design, implement, and maintain SQL Server databases, schemas, tables, relationships, and database objects. - Develop, deploy, troubleshoot, and maintain complex SQL Server Integration Services (SSIS) packages for data migration, transformation, and integration. - Manage data imports, exports, file processing, and ETL operations while ensuring data accuracy and integrity. - Monitor database capacity, storage utilization, space allocation, and growth to support enterprise applications. - Implement and maintain database security, including user accounts, roles, permissions, authentication, and access controls. - Implement and manage data masking and encryption techniques to protect sensitive and confidential data - Perform database health checks, routine maintenance, and proactive monitoring to identify and resolve potential issues. - Support database migrations, upgrades, and integrations involving SQL Server and Oracle environments. - Collaborate with developers, infrastructure teams, and application support personnel to resolve database-related issues. - Review database designs and application requirements to ensure efficient data structures and database performance. - Develop and maintain technical documentation, database standards, procedures, and operational guidelines. - Provide recommendations for database architecture, capacity planning, performance improvements, and technology upgrades. - Participate in production support, incident resolution, root cause analysis, and change management activities.

Your next step

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

Job Description

About The Agency:

The Department of Housing Preservation and Development (HPD) oversees housing standards across all 3.7 million homes in New York City.

As the nation’s largest municipal housing agency, HPD is responsible for building and preserving affordable housing, protecting tenants from harassment and displacement, and holding landlords accountable across the five boroughs. Under Commissioner Dina Levy and the Mamdani Administration, HPD is pursuing an ambitious housing agenda focused on the needs of New York’s tenants. With a broad set of tools including standards enforcement, tenant resources, and the creation of new affordable housing, HPD is committed to making New York City a more affordable place for renters and homeowners alike.

Your Team:

The Office of Housing Access and Stability (“HAS”) consists of the divisions of Housing Opportunity, Tenant and Owner Resources, Housing Stability, Budget and Program Operations, and Program Policy and Innovation. The mission of the office is to ensure fair, efficient, and transparent access to affordable housing. The Office provides subsidies, placement services, and tools that connect New Yorkers to affordable housing and ensures vulnerable households in subsidized housing have the support they need to be safely housed. Housing Access is committed to expanding housing choices, affirmatively furthering fair housing, and stabilizing the financial health of buildings.

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. HPD Tech empowers decision makers with access to quality (complete and accurate) information to anticipate and proactively react to building, neighborhood and market conditions.


Your Impact:

The City Housing Assistance Program (CHAP) is a City funded rental assistance program administered by the New York City Department of Housing Preservation and Development (HPD). The program provides rental assistance to low-income households with incomes at or below 50% of Area Median Income (AMI) who are at risk of homelessness, including eligible rent-stabilized households facing eviction for nonpayment of rent and certain households residing in shelter who do not qualify for existing rental assistance programs. CityHAP helps eligible households maintain stable, permanent housing by subsidizing their rent, with the household generally contributing 30% of its adjusted monthly income toward rent. The program provides targeted assistance to New Yorkers facing housing instability while helping preserve rent-stabilized housing and prevent homelessness.

HPD is seeking an experienced SQL Server Database Administrator (DBA) with additional knowledge and experience in Oracle database administration. This is a full-performance-level database administration position responsible for supporting, maintaining, securing, and optimizing enterprise database environments.

Your Role:

The selected candidate will primarily serve as a Microsoft SQL Server Database Administrator, responsible for the installation, configuration, administration, maintenance, performance tuning, and support of enterprise SQL Server database environments. The candidate will also provide database administration support for Oracle environments as needed.

Your Responsibilities:

Responsibilities include managing database installations, upgrades, patching, backups, disaster recovery, security, capacity planning, and performance optimization. The DBA will ensure high database availability, integrity, reliability, and optimal performance while supporting enterprise applications and business operations.

The selected candidate will work closely with application developers, infrastructure teams, business analysts, and other technical staff to design, implement, maintain, and troubleshoot database solutions. The role will also involve database modeling, data integration, ETL processes, and the development and maintenance of database objects.

The candidate must have strong hands-on experience with Microsoft SQL Server and T-SQL development, including stored procedures, functions, views, indexing, and query optimization. Experience developing, deploying, maintaining SQL Server Integration Services (SSIS) packages and linked server administration is highly desirable.

Working knowledge of Oracle database administration, including database maintenance, backup and recovery, performance monitoring, and troubleshooting, is strongly preferred.


- Perform day-to-day Microsoft SQL Server database administration, including installation, configuration, upgrades, patching, and maintenance.
- Administer, monitor, and support SQL Server database environments to ensure high availability, reliability, disaster recovery and optimal performance.
- Perform database backup and recovery operations, develop recovery strategies, and support disaster recovery planning and testing.
- Manage SQL Server Agent jobs and automate DBA activities using PowerShell and T-SQL.
- Monitor database performance and troubleshoot issues related to queries, indexes, blocking, deadlocks, resource utilization, and database connectivity.
- Develop, optimize, and maintain complex T-SQL queries, stored procedures, user-defined functions, triggers, and views.
- Perform database performance tuning, including execution plan analysis, indexing strategies, statistics maintenance, and query optimization.
- Design, implement, and maintain SQL Server databases, schemas, tables, relationships, and database objects.
- Develop, deploy, troubleshoot, and maintain complex SQL Server Integration Services (SSIS) packages for data migration, transformation, and integration.
- Manage data imports, exports, file processing, and ETL operations while ensuring data accuracy and integrity.
- Monitor database capacity, storage utilization, space allocation, and growth to support enterprise applications.
- Implement and maintain database security, including user accounts, roles, permissions, authentication, and access controls.
- Implement and manage data masking and encryption techniques to protect sensitive and confidential data
- Perform database health checks, routine maintenance, and proactive monitoring to identify and resolve potential issues.
- Support database migrations, upgrades, and integrations involving SQL Server and Oracle environments.
- Collaborate with developers, infrastructure teams, and application support personnel to resolve database-related issues.
- Review database designs and application requirements to ensure efficient data structures and database performance.
- Develop and maintain technical documentation, database standards, procedures, and operational guidelines.
- Provide recommendations for database architecture, capacity planning, performance improvements, and technology upgrades.
- Participate in production support, incident resolution, root cause analysis, and change management activities.

Required Skills:

- Minimum of 5 years of hands-on experience administering Microsoft SQL Server 2012 or later.
- Strong experience with SQL Server installation, configuration, maintenance, upgrades, and patching.
- Advanced knowledge of T-SQL, including complex queries, stored procedures, functions, triggers, and views.
- Strong understanding of database performance tuning, execution plans, indexing, statistics, and query optimization.
- Experience with SQL Server backup and recovery strategies, including full, differential, and transaction log backups.
- Experience troubleshooting database performance issues, blocking, deadlocks, and connectivity problems.
- Hands-on experience with SQL Server Integration Services (SSIS), including package development, deployment, scheduling, and troubleshooting.
- Knowledge of SQL Server Agent jobs, maintenance plans, database monitoring, and automated maintenance processes.
- Experience with database security, user management, permissions, and role administration.
- Experience with database design, implementation, data modeling, and relational database concepts.
- Excellent communication skills, particularly being able to discuss business needs to both technical and non-technical staff
- Excellent people skills and the ability to work with a collaborative, team-driven approach
- Independent thinking and decision-making skills
- Capable of managing multiple tasks in a fast paced, high-volume environment and the ability to adapt plans to unexpected changes

Preferred Skills:

- Working knowledge and hands-on experience with Oracle database administration.
- Experience with .NET (C#) application environments.
- Experience supporting enterprise applications and production database environments.
- Knowledge of database migration, data conversion, and cross-platform database integration.
- Experience with Windows Server environments and basic networking concepts.
- Familiarity with database high availability and disaster recovery solutions.
- Experience with PowerShell scripting or other database automation tools.
- Strong analytical, troubleshooting, documentation, and communication skills.

IT PROJECT SPECIALIST - 06797

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.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

New York City, NY, United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.