About The Position

The Department of Housing Preservation and Development (HPD) is seeking an experienced SQL Server Database Administrator for HPD Tech, supporting the City Housing Assistance Program (CHAP). This 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 and provide Oracle database administration support as needed. The role covers installation, configuration, administration, maintenance, performance tuning, and support of SQL Server environments. The DBA will help ensure database availability, integrity, reliability, security, and performance in support of enterprise applications and business operations. The position works 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 development and maintenance of database objects. The position requires hands-on SQL Server and T-SQL experience, including stored procedures, functions, views, indexing, and query optimization. Experience developing, deploying, maintaining, and troubleshooting SSIS packages is highly desirable. Working knowledge of Oracle database administration 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 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 the 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, including maintenance, backup and recovery, performance monitoring, and troubleshooting.
  • 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.
  • Experience with linked server administration.

Responsibilities

  • Perform day-to-day Microsoft SQL Server administration, including installation, configuration, upgrades, patching, and maintenance.
  • Administer, monitor, and support SQL Server environments to ensure 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.
  • Develop, optimize, and maintain complex T-SQL queries, stored procedures, user-defined functions, triggers, and views.
  • Tune database performance using 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 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.
  • 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 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.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service