Job Description 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 third-party 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 ad-hoc 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 cross-functional teams to influence architectural decisions and drive technical excellence. NOTE: Due to the necessary support duties of this position in a 24/7 operation, candidate may be required to work various shifts such as weekends and/or nights/evenings. Additional Information 1. Candidates with permanent civil service status in the title of Computer Systems Manager (NM) 1 will also be considered. 2. NYCHA employees applying for transfer, 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. 4. NYCHA provides benefits that include a choice of medical coverage plans, deferred compensation plans and a defined pension benefit plan as a member of the New York City Employees’ Retirement System (NYCERS). Please read this posting carefully to make certain you meet the minimum qualification requirements before applying to this position. IT INFRASTRUCTURE ENGINEER - 95714 Qualifications 1. A baccalaureate degree from an accredited college in computer science, engineering or a related field and four years of satisfactory full-time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering; or, 2. A baccalaureate degree from an accredited college and eight years of satisfactory full-time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering; or, 3. Education and/or experience which is equivalent to "1" or "2" 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 individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.