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

City of New York•New York, NY
•$125,000 - $150,000

About The Position

The Department of Housing Preservation and Development (HPD) is seeking an experienced SQL Server Database Administrator (DBA) for HPD Tech, supporting the City Housing Assistance Program (CHAP). The role is a full-performance-level database administration position responsible for supporting, maintaining, securing, and optimizing enterprise database environments. The selected candidate will primarily administer Microsoft SQL Server environments and provide Oracle database administration support as needed. The DBA is responsible for SQL Server installation, configuration, administration, maintenance, performance tuning, and support. The role includes managing upgrades, patching, backups, disaster recovery, security, capacity planning, and performance optimization to ensure database availability, integrity, reliability, and performance for enterprise applications and business operations. The position collaborates with application developers, infrastructure teams, business analysts, and other technical staff to design, implement, maintain, and troubleshoot database solutions. Work also includes database modeling, data integration, ETL processes, and developing and maintaining database objects. Strong hands-on SQL Server and T-SQL experience is required. Oracle database administration knowledge and experience are strongly preferred. The City Housing Assistance Program provides rental assistance to eligible low-income households at risk of homelessness, helping them maintain stable, permanent housing.

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 knowledge, 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 SSIS 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, including the ability to discuss business needs with technical and non-technical staff.
  • Excellent people skills and ability to work collaboratively in a team-driven environment.
  • Independent thinking and decision-making skills.
  • Ability to manage multiple tasks in a fast-paced, high-volume environment and adapt plans to unexpected changes.
  • A baccalaureate degree from an accredited college and four years of satisfactory full-time experience related to the position, or equivalent education and/or experience.

Nice To Haves

  • 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.
  • Experience developing, deploying, and maintaining SSIS packages and administering linked servers.

Responsibilities

  • Perform day-to-day Microsoft SQL Server database administration, including installation, configuration, upgrades, patching, and maintenance.
  • Administer, monitor, and support SQL Server 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 queries, indexes, blocking, deadlocks, resource utilization, and connectivity issues.
  • Develop, optimize, and maintain complex T-SQL queries, stored procedures, user-defined functions, triggers, and views.
  • Tune database performance through 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 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 for 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.
  • Recommend database architecture, capacity planning, performance improvements, and technology upgrades.
  • Participate in production support, incident resolution, root cause analysis, and change management activities.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service