SQL Server Database Administrator for the Division of HPDTech (City HAP Program)
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.
- ...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...SuggestedPermanent employmentFull timeWork at officeRemote work
- ...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....SuggestedFull timeWork at officeLocal areaRemote work
- ...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...SuggestedRemote workFlexible hours
$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...SuggestedHourly payTemporary workSummer workInternship$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....SuggestedFull timeTraineeshipInterim roleWork at office- ...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 jobFull timeContract workPart timeLocal areaMonday to FridayFlexible hours
$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 timeContract work- ...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 timeTemporary workWork at officeRemote work
$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$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 workImmediate start$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 workWork at officeVisa sponsorshipFlexible hours$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 timeTemporary workWork at officeRemote work- ...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 contract2 days per week3 days per week
- ...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...
- ...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 timeImmediate start
$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 payRemote work- ...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 payPermanent employmentContract workWork at officeRelocationFlexible hoursWeekend work
- ...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 timeWork at office
$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 workSummer holidayWork at officeLocal areaFlexible hours- ...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 timeFlexible hours
$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 timeWork experience placementWork at officeFlexible hours$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 timeWork at officeRemote workMonday to FridayFlexible hoursAfternoon shift$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- ...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....
$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 payContract workTemporary workWork experience placement$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 payWork experience placementInternshipWork at officeLocal areaMonday to Friday$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 areaVisa sponsorship$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 contractFull timeContract workWork at office$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 payFull timeWork at officeLocal areaMonday to FridayFlexible hours- ...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...
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!
- remote sql server dba New York, NY
- application system administrator New York, NY
- system admin New York, NY
- enterprise administrator New York, NY
- server administrator New York, NY
- work from home systems administrator New York, NY
- IT administrator New York, NY
- remote systems administrator New York, NY
- computer systems administrator New York, NY
- microsoft systems administrator New York, NY






