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:

Design implement and maintain SQL Server database system to meet performance availability and security requirements.
Perform regular database capacity planning and provide recommendations for scalability and optimization.
Install configure and upgrade SQL Server software and related tools.
Monitor database performance using tools like SQL Server Profiler Dynamic Management Views (DMVs) and thirdparty monitoring solutions.
Identify performance bottlenecks by analyzing query execution plans and utilizing performance tuning techniques.
Optimize SQL Server configurations indexes and database structures to enhance system performance.
Implement and manage database backup and recovery strategies to ensure data integrity and availability.
Configure and maintain database mirroring log shipping clustering and AlwaysOn Availability Groups for high availability.
Implement and enforce security policies access controls and authentication mechanisms to protect sensitive data.
Regularly apply security patches and updates to SQL Server environment.
Ensure compliance with industry regulations and best practices related to data security and privacy.
Diagnose and resolve complex database issues including performance problems and data corruption and system failures.
Collaborate with application developers and infrastructure teams to identify root causes and implement effective solutions.
Develop and maintain scripts and automation process to streamline database maintenance tasks and routine operations.
Implement database deployment automation using tool like SQL Server Data Tools (SSDT) or similar technologies.
Create and maintain comprehensive documentation related to database configurations procedures and troubleshooting guidelines.
Generate regular and adhoc reports on database performance maintenance activities and system health.
Provide guidance and mentorship to junior DBAs and team members sharing best practices and promoting continuous learning.
Collaborate with crossfunctional 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 55a Program. Please indicate in your cover letter that you would like to be considered for the position under the 55a Program. For detailed information regarding the 55a Program click on the link below:



Additional Information

1.INTERAGENCY TRANSFERS INTO NYCHA OF THOSE PERMANENT IN TITLE ARE NOT PERMITTED IN THE FACE OF AN ACTIVE AND VIABLE NYCHA PROMOTION LIST OR PREFERRED LIST FOR THE SAME TITLE.
2.NYCHA employees applying for promotional title or level change opportunities must have served a period of one year at current location and in current title and level (if applicable).
3.NYCHA residents are encouraged to apply.

Please read this posting carefully to make certain you meet the minimum qualification requirements before applying to this position.

Qualifications :

1. A masters degree in computer science from an accredited college or university and three (3) years of progressively more responsible fulltime 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 fulltime satisfactory experience as described in 1 above; or

3. A fouryear high school diploma or its educational equivalent and six (6) years of progressively more responsible fulltime 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 fouryear 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.

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 individuals sex race color ethnicity national origin age religion disability sexual orientation veteran status gender identity or pregnancy.

Remote Work :

No

Employment Type :

Fulltime