*ONLY PERMANENT EMPLOYEES IN THE TITLE OF CERTIFIED IT ADMINISTRATOR (DATABASE) OR THOSE THAT ARE REACHABLE ON EXAM# 0112 ARE ELIGIBLE TO APPLY. *

The New York City Administration for Children’s Services of Office of Information Technology (OIT) department has the responsibility to provide high quality, reliable, sustainable technology services and support to meet the needs of the families and children we serve through ACS and its vendor partners and other city agencies.

Under supervision, with latitude for independent action and the exercise of independent judgment, the Database Administrator is responsible for managing and maintaining all Microsoft SQL Servers database environments. The selected candidate specific duties will include:

- Plan, design, install, configure, secure, maintain, and support all versions of Microsoft SQL Database Servers on Windows OS environment.
- Analyze, monitor the resource utilization, and tune the performance of the SQL and associated components, monitor thread usage, CPU and memory usage.
- Analyze the log files, thread dumps, exception stack traces.
- Implement and maintain security access (Users, logins, schemas) - Provision and de-provision user accounts and access privileges and perform periodic validation.
- Experience with MSSQL High Availability, always on and Replication.
- Design and implement databases in accordance to user requirements and views.
- Develop, validate, and implement an overall strategy to patch server environments including security updates on a regular schedule.
- Ensure that all changes to the environment adheres to established Change Management policies and procedures.
- Perform regular SQL Server backup and restore/recover when needed.
- Perform periodic disaster recovery test for the database/application server environments and maintain disaster recovery documentation and procedures in support of these systems.
- Collaborate with application developers, database administrators and system administrators for configuration and integration of database and application components.
- Evaluate new systems and applications requirements for resource planning.
- Setup and monitor the scheduled batch jobs.
- Setup and monitor system alerts to provide 24x7 support and high availability.
- Liaise with Microsoft, and other vendors to troubleshoot technical issues.
- Follow communications protocol for system failures/outages and file incident reports.
- Respond to Service Desk tickets for technical support ensuring timely follow up and resolution.
- Prepare system configurations and management/support documentation and provide training and knowledge transfer to other team members as needed.
- Create and maintain infrastructure/Architecture diagrams.
- Available to work after hours and weekends as needed.

Professional/Vendor Certification(s) in database administration that is required for the position to be filled. In addition, you must have one of the following:
1. A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management;

2. A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience (IT) of which at least two years must have been database administration experience as described in "1" above; OR

3. A satisfactory equivalent of education and/or experience equivalent to “1” or “2” above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from
an accredited college or university is equivalent to 6 months of information technology experience, but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college or university may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in "1" above.

The preferred candidate should possess the following: - Preferably 5 years’ proven experience as database administrator managing a large scale of Microsoft SQL databases in windows OS environment. - Certification in MSSQL Server Database Administration preferred. - Experience to install, configure, manage, monitor, and troubleshoot Microsoft SQL Server 2019/2022 database environment, and Third-Party COTS windows products. - Experience with ETL tool Microsoft SQL Server Integration Services (SSIS). - Experience in MS SQL Server Job System. - Network Topology - Transmission Control Protocol (TCP) / Internet protocol suite (IP) - (TCP/IP). - Knowledge of virtual servers and storage area network (SANs) related to capacity planning, security, and performance tuning. - Experience in IIS, SSL/HTTPS, Windows OS Server environment, MS Visio, SQL performance monitoring tool Idera. - Expert level proficiency in TSQL, experience in SQL code deployment using change management process. - Knowledge of Azure SQL database services. - Knowledge of approaches, tools, and techniques for recognizing and resolving technical issues related to database environment. - Strong interpersonal and problem-solving skills. - Ability to multitask and perform in a high-paced/high-pressure environment. - Ability to work independently or within a group to resolve issues. - Ability to communicate with different levels of the organization. - Strong team player with service-oriented attitude and customer focus.

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.

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 https://studentaid.gov/pslf/

New York City Residency is not required for this position

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.