You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
Company hidden

SQL Server Database Administrator for the Division of HPDTech

  • Office
  • 3-6 years

Salary

Not stated

Similar roles pay $80K - 170K a year · our estimate

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

The city's housing agency oversees housing standards across 3.7 million homes in New York City and is the largest municipal housing agency in the country.

The agency builds and preserves affordable housing, protects tenants from harassment and displacement, and holds landlords accountable in all five boroughs.

The Office of Housing Access and Stability includes five divisions: Housing Opportunity, Tenant and Owner Resources, Housing Stability, Budget and Program Operations, and Program Policy and Innovation. The office provides subsidies, placement services, and tools that link New Yorkers to affordable housing.

The IT division uses technology to cut manual processing, lower costs, speed up work, and give decision makers complete and accurate information.

Eligible households generally contribute 30% of their adjusted monthly income toward rent.

This is a full-performance-level database administration role centered on Microsoft SQL Server, with Oracle support as needed, covering the support, maintenance, security, and optimization of enterprise database environments.

Responsibilities

  • Serve mainly as a Microsoft SQL Server DBA, handling installation, configuration, administration, maintenance, performance tuning, and support of enterprise SQL Server environments.
  • Provide Oracle database administration support when needed.
  • Manage installations, upgrades, patching, backups, disaster recovery, security, capacity planning, and performance so databases stay available, intact, reliable, and fast.
  • Work with developers, infrastructure teams, business analysts, and other technical staff to design, build, maintain, and troubleshoot database solutions, including data modeling, data integration, ETL, and database object development.
  • Maintain and optimize T-SQL queries, stored procedures, user-defined functions, triggers, and views.
  • Run daily SQL Server administration, including installation, configuration, upgrades, patching, and maintenance.
  • Monitor, support, and tune SQL Server environments for availability, reliability, disaster recovery readiness, and speed, including execution plan analysis, indexing, and statistics upkeep.
  • Run backup and recovery operations, build recovery strategies, and support disaster recovery planning and testing.
  • Manage SQL Server Agent jobs and automate DBA tasks with PowerShell and T-SQL.
  • Diagnose issues with queries, indexes, blocking, deadlocks, resource use, and connectivity.
  • Design, implement, and maintain SQL Server databases, schemas, tables, relationships, and objects.
  • Build, deploy, troubleshoot, and maintain SQL Server Integration Services packages for migration, transformation, and integration. Experience with SSIS and linked server administration is highly desirable.
  • Handle data imports, exports, file processing, and ETL while keeping data accurate and intact.
  • Track capacity, storage, space allocation, and growth for enterprise applications.
  • Manage user accounts, roles, permissions, authentication, and access controls, and apply data masking and encryption to sensitive data.
  • Run health checks, routine maintenance, and proactive monitoring to catch problems early.
  • Support migrations, upgrades, and integrations across SQL Server and Oracle.
  • Review database designs and application requirements for efficient structures and performance.
  • Write and maintain technical documentation, standards, procedures, and operating guidelines.
  • Recommend changes to database architecture, capacity, performance, and technology upgrades.
  • Take part in production support, incident resolution, root cause analysis, and change management.
  • Working knowledge of Oracle administration, including maintenance, backup and recovery, performance monitoring, and troubleshooting, is strongly preferred.

Requirements

  • At least 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 T-SQL skills, including complex queries, stored procedures, functions, triggers, and views.
  • Solid grasp of performance tuning, execution plans, indexing, statistics, and query optimization.
  • Experience with full, differential, and transaction log backup and recovery strategies.
  • Experience resolving performance, blocking, deadlock, and connectivity problems.
  • Hands-on SSIS experience covering package development, deployment, scheduling, and troubleshooting.
  • Familiarity with SQL Server Agent jobs, maintenance plans, monitoring, and automated maintenance.
  • Experience managing database security, users, permissions, and roles.
  • Experience with database design, implementation, data modeling, and relational concepts.
  • Clear communication with both technical and non-technical staff about business needs.
  • Strong people skills and a collaborative approach to teamwork.
  • Ability to make independent decisions and judgments.
  • Ability to juggle several tasks in a busy, high-volume setting and adjust plans when things change.
  • A bachelor's degree from an accredited college and 4 years of satisfactory full-time experience in the required areas, or education and experience that is equivalent.
  • Preferred: working knowledge and hands-on experience with Oracle administration.
  • Preferred: experience with.NET (C) application environments.
  • Preferred: experience supporting enterprise applications and production databases.
  • Preferred: knowledge of database migration, data conversion, and cross-platform integration.
  • Preferred: experience with Windows Server and basic networking.
  • Preferred: familiarity with high availability and disaster recovery solutions.
  • Preferred: PowerShell scripting or other database automation tools.
  • Preferred: strong analytical, troubleshooting, documentation, and communication skills.

Conditions

Posted as IT Project Specialist, code 06797.

The role is based in New York City.

The city is an equal opportunity employer that is committed to a workforce free from discrimination and harassment based on any legally protected status.

Where you’d work

From the office

The office

About the company

Company hidden

Office in New York City, United States

Your chances

Likely still hiring, not crowded yet, and you'd be among the first.

  • 15 checks run
  • 4 good signs
  • 1 red flag

Still hiring?

10 checks

Likely active

In its favour2

  • Still on the company's own careers site, checked 1 h agoModerate evidence
  • Found in the last 48 hours, before the big job boardsModerate evidence

Against it1

  • No salary stated, though New York asks most employers to post oneModerate evidence

How crowded?

5 checks

Low

In its favour2

  • In its Early Window: not on the big job boards yetStrong evidence
  • In the office in New York City: only people nearby can take itSlight evidence

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details10 facts · Role, Location, Compensation, Employment
Tech stack
  • SQL
Type
Full-time
Specialty
Data Engineering
Region
United States
Pay period
Annual
Show 5 more factsShow less

Role

Category
Data & Analytics
Specialty
Data Engineering
Experience
5+ years
Tech stack
  • SQL

Location

Work model
Office
Region
United States
Office
  • New York City, United States

Compensation

Salary
Salary by agreement
Pay period
Annual

Employment

Type
Full-time

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason