Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

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

Full-time

City of New York

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.

Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the SQL Server Database Administrator for the Division of HPDTech (City HAP Program) in New York, NY vacancy
  •  ...million homes in New York City. As the...  ...Levy and the Mamdani Administration, HPD is pursuing an ambitious...  ...HAS”) consists of the divisions of Housing Opportunity...  ...Stability, Budget and Program Operations, and...  ...Oracle Analytics, Excel, SQL, and other various analytical... 
    Suggested
    Permanent employment
    Full time
    Work at office
    Remote work

    City of New York

    New York, NY
    1 day ago
  •  ...from the MTA 12 months Local to New York City Rate: 50.00 an hour c2c : *PLEASE...  ...CONSULTANT TO WORK REMOTELY. HOWEVER AS A Database Administration DUTIES WILL OCCASSIONALLY NESSITATE...  ..., implement, and maintain Microsoft SQL Server and Azure Managed Instance databases.... 
    Suggested
    Full time
    Work at office
    Local area
    Remote work

    3B Staffing LLC

    New York, NY
    2 days ago
  •  ...recruiters. Job Description RESPEC is seeking a hands-on Senior SQL Server Database Administrator / Windows Systems Administrator to support the NPIRS...  ...and Training Tuition Reimbursement Employee Assistance Program Medical/Dental/Vision Insurance Plans All your... 
    Suggested
    Remote work
    Flexible hours

    Respec

    New York, NY
    2 days ago
  • $72.12 per hour

     ...Morgan Stanley’s Institutional Equity Division (IED) is a world leader in the origination,...  ...Institutional Equity Division’s Summer Associate Program is a 10-week program that begins with one...  ...coding languages such as Python, Q, R, SQL, or VBA Strong verbal and written... 
    Suggested
    Hourly pay
    Temporary work
    Summer work
    Internship

    Morgan Stanley

    New York, NY
    3 days ago
  • $101.49k - $125k

     ...our team as a Senior Program Manager, Research. We...  ...Emergency Medicine, Research Division. In this role, the...  .... Facilitates the administration of departmental activities...  ..., and monitors staff CITI trainingsReports: Prepares...  ...software such as R or SQL is preferred.... 
    Suggested
    Full time
    Traineeship
    Interim role
    Work at office

    NYU Langone Medical Center

    New York, NY
    2 days ago
  •  ...Title : Part-time and Remote MS SQL Server Admin Location: Remote (U.S...  ...Client: Federal Government Programs Employment Type: Part-Time...  ...Microsoft SQL Server Administrator (MSSQL DBA) to manage, maintain...  ...and optimize our SQL Server database environments. The ideal candidate... 
    Remote job
    Full time
    Contract work
    Part time
    Local area
    Monday to Friday
    Flexible hours

    Wintrio LLC

    New York, NY
    2 days ago
  • $60 per hour

     ...Interview is Required Senior SQL Server DBA Job Summary We are...  ...-site contract in New York City. This role focuses on...  ...business-critical SQL Server databases, production environments, performance...  .... Automate database administration using PowerShell, T-SQL, and... 
    Full time
    Contract work

    VSG Business Solutions LLC

    New York, NY
    3 days ago
  •  ...Information Technology and Communications (ITC) Division of the Task Force Support Office (TFSO)...  ...IT and Information Management system administration and management for the assigned site....  ...and manages major communications programs for the division. Qualification Summary... 
    Full time
    Temporary work
    Work at office
    Remote work

    Defense Logistics Agency

    New York, NY
    5 hours ago
  • $70k - $80k

    Job Category: Administration & Human Resources Salary Band: $70,000 to...  ...units of the New York City Human Resources Administration...  ...and data on social service programs administered by NYC’s Human...  ...querying from various Agency databases using SQL. Assist with report... 
    Work at office

    City of New York

    New York, NY
    12 hours ago
  • $122.9k - $204.9k

     ...that will assist them in evolving and sustaining a risk management program through transformation. You will support EY teams responsible...  ...at ey.com/us/careers.The salary range for this job is:New York City, Boston, and Washington DC Metro Areas, Washington State, and Southern... 
    Contract work
    Immediate start

    EY (Ernst & Young)

    New York, NY
    3 days ago
  • $290k - $365k

     ...Technical Program Manager, Security San Francisco, CA | New York City, NY | Seattle, WA About Anthropic Anthropic's mission is to create reliable, interpretable...  ...through data-driven benchmarks, including writing SQL queries. Have strong interpersonal skills that... 
    Contract work
    Work at office
    Visa sponsorship
    Flexible hours

    Anthropic

    New York, NY
    2 days ago
  • $216k

     ...301681Category: ScienceLocation: New York City, NY, United StatesSchedule: Full time, Level...  ...As a Staff Scientist working on Earner Program Logistics, you will solve high-stakes optimization...  ...cluster-randomized trials).Proficiency in SQL and Python to work efficiently with large-... 
    Full time
    Temporary work
    Work at office
    Remote work

    Uber

    New York, NY
    3 days ago
  •  ...Job Description Job Title: Senior Associate/Manager – Agile Program Manager Location: New York, NY (1NYP) Work Arrangement: Hybrid...  ...Business Analysis and Agile project/program delivery, hands-on SQL and BI reporting experience, familiarity with AI tools, and an... 
    Long term contract
    2 days per week
    3 days per week

    enableIT

    New York, NY
    2 days ago
  •  ...Senior SQL Server Database Administrator (Senior DBA)Location: New York, NY (4 Irving Place)Work Arrangement: 100% Onsite – 5 Days a WeekInterview: Video followed by mandatory in-person interviewJob DescriptionSeeking an experienced Senior SQL Server DBA with strong hands... 

    InstantServe LLC

    New York, NY
    5 days ago
  •  ...Database Administrator (DBA)Our direct client based in NYC (midtown) is seeking a full-time DBA to manage PostgreSQL and MSSQL databases. This...  ...designing complex stored procedures, developing and optimizing SQL queries and ensuring the efficient installation,... 
    Full time
    Immediate start

    MoneyLine Group LLC.

    New York, NY
    1 day ago
  • $35 - $45 per hour

     ..., well-established law firm in New York City, known for its fast-paced, highly professional...  ...seeking a detail-oriented IT Systems Administrator to support internal technology...  ...upon eligibility (including healthcare plans, discount programs, and paid time off).... 
    Hourly pay
    Remote work

    Atrium

    New York, NY
    5 days ago
  •  ...Description Job Description Our enterprise-level client is seeking to add an IT Asset Management Specialist to the team in New York City. Please see below for full details- Job Notes: -- 6+-month contract / extensions and perm conversion are possible but not... 
    Hourly pay
    Permanent employment
    Contract work
    Work at office
    Relocation
    Flexible hours
    Weekend work

    Merge IT

    New York, NY
    5 days ago
  •  ...homes in New York City. As the nation...  ...and the Mamdani Administration, HPD is pursuing...  ...part of OPS, the Division of Strategic Operations...  ...clarifying HPD program missions,...  ...and data flows in SQL Server and building reusable...  ...with relational databases (e.g., SQL Server... 
    Full time
    Work at office

    City of New York

    New York, NY
    1 day ago
  • $125k - $145k

     ...compensation package for employees. New York City: $125,000 – $145,000 This job may also...  ...in product management, technical program management, business systems analysis, or...  ...another regulated industry. Familiarity with SQL or data analysis tools sufficient to self-... 
    Temporary work
    Summer holiday
    Work at office
    Local area
    Flexible hours

    Betterment

    New York, NY
    5 days ago
  •  ...SQL DBA / Systems AnalystEmployment Type: Full Time, Mid-levelCGS...  ....- Assists in administering database organizations, standards,...  ...Certification in an eDiscovery program or related software package (...  ...achieve Relativity Certified Administrator credential within 6 months of... 
    Full time
    Flexible hours

    Contact Government Services LLC

    New York, NY
    2 days ago
  • $117.58k - $154.32k

    Hi, we're Oscar. We're hiring a Technical Program Manager, Data to join our Technical PMO team...  ...: This position is based in our New York City office, requiring a hybrid work schedule...  ...experience using coding languages such as SQL to analyze project performance and risks and... 
    Full time
    Work experience placement
    Work at office
    Flexible hours

    Oscar Health Insurance

    New York, NY
    3 days ago
  • $112.5k - $134.17k

     ...responsible for:The Senior IT Systems Administrator is a key, hands-on role based onsite at Circle's New York City office, Monday through Friday...  ...; identify gaps; and restore servers, networks, and applications....  ...participates in the E-Verify Program in certain locations, as... 
    Full time
    Work at office
    Remote work
    Monday to Friday
    Flexible hours
    Afternoon shift

    Circle

    New York, NY
    3 days ago
  • $171.2k - $273k

     ...productive.We are seeking a Staff Technical Program Manager to run our Growth pillar programs...  ...their own manual work, such as scripts, SQL dashboards, AI agents and skills (e.g.,...  ...$171,200 - $273,000 annually. In select cities within the San Francisco and New York City... 
    Full time

    Salesforce

    New York, NY
    4 days ago
  •  ...which is comprised of our Technology Division and global strategist groups, is at...  ...is a key component of SMA expansion program. The aim of this portal is to provide...  ...such as agile, waterfall etc.Strong SQL skills in relational databases as well as familiarity with MongoDB.... 

    Goldman Sachs

    New York, NY
    12 hours ago
  • $70 - $72 per hour

     ...summary: Experience: 8+ years overall, with strong hands-on SQL Server administration and production support experience Summary: A support-...  ...and supports new and existing SQL Server (or equivalent) databases and the Windows servers they run on across internal networks... 
    Hourly pay
    Contract work
    Temporary work
    Work experience placement

    Randstad

    New York, NY
    2 days ago
  • $20 - $30 per hour

     ...that attracts the industry’s brightest talent. The FOX Internship Program offers an exciting opportunity for you to gain practical...  ...applicable to your areas of placement. For example HTML, Python, Java, SQL, Tableau PROGRAM FEATURES: FOX Master Classes: A variety... 
    Hourly pay
    Work experience placement
    Internship
    Work at office
    Local area
    Monday to Friday

    FOX Corporation

    New York, NY
    2 days ago
  • $105.4k - $207.8k

     ...access management, and authentication use casesSupporting client programs to improve joiner-mover-leaver processes, access certification,...  ...including the Los Angeles County Fair Chance Ordinance for Employers, City of Los Angeles’s Fair Chance Initiative for Hiring Ordinance,... 
    Local area
    Visa sponsorship

    Deloitte

    New York, NY
    2 days ago
  • $108k - $127k

    Senior Salesforce Administrator (Contract) Duration: 8 month contract Location: Hybrid in New York City (3 day in-office requirement) Qualifications...  ...query fluency, including SQL and SOQL, with the ability...  ...workshops, mentorship programs, and team building activities... 
    Ongoing contract
    Full time
    Contract work
    Work at office

    Melio

    New York, NY
    2 days ago
  • $21.33 per hour

     ...Program Associate (Aging Services) Senior Center...  ...We are two of New York City's leading human services...  ...responsible for the administrative tasks of the Food and...  ...results as needed Update databases or records with new...  ...of Peerplace and SQL a plus Strong attention... 
    Hourly pay
    Full time
    Work at office
    Local area
    Monday to Friday
    Flexible hours

    Goddard Riverside Community Center

    New York, NY
    1 day ago
  •  ...Job Description Job Description ~5+ years of hands-on experience as a SQL Server Database Administrator. ~ Bachelor's degree in Computer Science, IT, or equivalent experience. ~ Expert knowledge in Windows Server, SQL Server, Azure cloud platform and specifically... 

    The Dignify Solutions, LLC

    New York, NY
    25 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to SQL Server Database Administrator for the Division of HPDTech (City HAP Program). Be the first to apply!