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.

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.

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.