Senior Engineer, SQL Server DBA

NYCHA IT Infrastructure and Operations (I&O) unit serves as the backbone of the Information Technology division. The unit ensures the Housing Authority has a strong, stable, and secure technology environment that enables the business to deliver services to New Yorkers effectively and efficiently. I&O strives to use innovative ideas to optimize and manage its environment, implementing industry standard best practices and automated processes. Reporting to the IT Infrastructure Management department within the I&O unit, Database Engineering team is responsible for the administration support of SQL Server databases for various applications.

Under direction of the Senior Manager of IT Infrastructure Management, with broad latitude for independent action or decision, the Database Engineering team seeks a highly motivated individual with the following specifications to lead and provide SQL server administration support. Responsibilities will include:

1. Design, implement and maintain SQL Server database system to meet performance, availability, and security requirements.
2. Perform regular database capacity planning and provide recommendations for scalability and optimization.
3. Install, configure, and upgrade SQL Server software and related tools.
4. Monitor database performance using tools like SQL Server Profiler, Dynamic Management Views (DMVs), and third-party monitoring solutions.
5. Identify performance bottlenecks by analyzing query execution plans and utilizing performance tuning techniques.
6. Optimize SQL Server configurations, indexes, and database structures to enhance system performance.
7. Implement and manage database backup and recovery strategies to ensure data integrity and availability.
8. Configure and maintain database mirroring, log shipping, clustering, and AlwaysOn Availability Groups for high availability.
9. Implement and enforce security policies, access controls, and authentication mechanisms to protect sensitive data.
10. Regularly apply security patches and updates to SQL Server environment.
11. Ensure compliance with industry regulations and best practices related to data security and privacy.
12. Diagnose and resolve complex database issues, including performance problems and data corruption and system failures.
13. Collaborate with application developers and infrastructure teams to identify root causes and implement effective solutions.
14. Develop and maintain scripts and automation process to streamline database maintenance tasks and routine operations.
15. Implement database deployment automation using tool like SQL Server Data Tools (SSDT) or similar technologies.
16. Create and maintain comprehensive documentation related to database configurations, procedures and troubleshooting guidelines.
17. Generate regular and ad-hoc reports on database performance, maintenance activities and system health.
18. Provide guidance and mentorship to junior DBAs and team members, sharing best practices and promoting continuous learning.
19. Collaborate with cross-functional teams to influence architectural decisions and drive technical excellence.

NOTE: Due to the existence of a civil service list, candidates must have permanent civil service status in the title of Computer Systems Manager to be considered.

NOTE: This position is open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate in your cover letter that you would like to be considered for the position under the 55-a Program. For detailed information regarding the 55-a Program, click on the link below:

55-a Program Information

Minimum Qualifications

1. A master’s degree in computer science from an accredited college or university and three (3) years of progressively more responsible, full-time, satisfactory experience in Information Technology (IT) including applications development, systems development, data communications and networking, database administration, data processing, or user services. At least eighteen (18) months of this experience must have been in an administrative, managerial or executive capacity in the areas of applications development, systems development, data communications and networking, database administration, data processing or in the supervision of staff performing these duties; or

2. A baccalaureate degree from an accredited college or university and four (4) years of progressively more responsible, full-time, satisfactory experience as described in „1“ above; or

3. A four-year high school diploma or its educational equivalent, and six (6) years of progressively more responsible, full-time, satisfactory experience as described in „1“ above; or

4. A satisfactory combination of education and experience equivalent to „1“, „2“ or „3“ above. However, all candidates must have at least a four-year high school diploma or its educational equivalent and must possess at least three (3) years of experience as described in „1“ above, including the eighteen (18) months of administrative, managerial, executive or supervisory experience as described in „1“ above.

In the absence of a baccalaureate degree, undergraduate credits may be substituted for a maximum of two (2) years of the required experience in IT on the basis of 30 semester credits for six (6) months of the required experience. Graduate credits in computer science may be substituted for a maximum of one (1) year of the required experience in IT on the basis of 30 graduate semester credits in computer science for one (1) year of the required IT experience. However, undergraduate and/or graduate credits may not be substituted for the eighteen (18) months of experience in an administrative, managerial, executive, or supervisory capacity as described in „1“ above.

Preferred Skills

We are looking for candidates who not only have the required experience and skills but can demonstrate a level of professionalism and customer service we expect from top-tier consultants in the private sector. If you are an IT professional who combines high business acumen with technical expertise and team collaboration, you are strongly encouraged to apply. The preferred candidate should possess the following:

1. 10+ years of hand-on with SQL Server administration, with focus on managing enterprise-level databases.
2. Strong knowledge in SQL Server features, versions, and editions.
3. Proficiency in database performance tuning and optimization.
4. Experience with high availability and disaster recovery solutions for SQL Server.
5. Solid understanding of database security principles and best practices.
6. Proficiency in T-SQL and scripting and automation.
7. 5+ years of experience in working in a Hybrid Multi-cloud, Active Directory, Azure, AWS and OCI.
8. Deep understanding of cloud architectures on Azure, AWS and/or OCI.
9. Strong knowledge and of experience architecting complex large-scale systems incorporating packaged and custom applications.
10. Knowledge of common technology methodologies, including TOGAF and ITIL.
11. Strong managerial and leadership capabilities.
12. Strong interpersonal skills and ability to work well in a team environment.
13. Understanding of DevOps concepts and tools.
14. Passionate and enthusiastic about modern technologies, industry trends and new opportunities.

55a Program

This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at Public Service Loan Forgiveness .

Residency Requirement

NYCHA has no residency requirements.

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.

#J-18808-Ljbffr