Certified IT Administrator (Database), III

City of New York • New York City, NY

1d • Onsite

About The Position

The New York City Police Department's Information Technology Services Division (ITSD) supports the Department by acquiring, distributing, installing, and maintaining Local Area Networks, personal computers, mainframe computers, software, and data communications networks. ITSD also plans and coordinates the implementation of advanced technology. The selected candidate will perform SQL Server database administration functions, including maintenance of multiple environments (development, testing, and production), patching, troubleshooting, SSIS and SSRS deployments, and security management. Responsibilities include monitoring and analyzing data platforms to ensure database availability, security, health, efficiency, and recoverability. The role involves building and managing High Availability (HA) and Disaster Recovery (DR) architectures such as Clustering, Replication, and Always On. Additionally, the candidate will implement and manage physical databases for mission-critical systems, perform capacity planning, and collaborate with application owners for schema and data migration. The position requires partnering with development and quality assurance teams, supervising subordinates, leading projects, and coordinating multi-team operations. Key tasks also include monitoring SQL Server installation, configuration, patching, database backup and recovery, performance tuning, and maintenance.

Requirements

• Permanent in the 'CERTIFIED IT ADMINISTRATOR' (DATABASE) Civil Service Title.
• Professional/Vendor Certification(s) in database administration.
• A baccalaureate degree from an accredited college or university, and two years of satisfactory full-time experience in database administration (including database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management).
• OR A four-year high school diploma or its educational equivalent and six years of satisfactory full-time information technology experience, of which at least two years must have been database administration experience as described above.
• At least one year of satisfactory full-time database administration experience is required for all candidates, even those with a Master's degree.

Nice To Haves

• 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.

Responsibilities

• Perform SQL Server database administration functions, including maintenance of multiple environments (development, testing and production), patching, troubleshooting, SSIS and SSRS deployments and security management.
• Monitor and analyze data platform to ensure database is available, secure, healthy, efficient and recoverable as per expectations.
• Build and manage HA and DR architectures like Clustering, Replication and Always on.
• Implementing and managing the physical databases of mission critical systems capacity planning to determine future storage needs.
• Collaborate with application owners to develop a seamless process to migrate their schema and data to data platform.
• Partner with development and quality assurance teams to deliver robust, quality, on-time solutions.
• Supervise subordinates, lead projects and coordinating multi-team operations.
• Monitor the installation of SQL Server, configuration, patching and database back-up recovery, database performance tuning and maintenance.

Benefits

• Health insurance for the employee and his or her spouse or domestic partner and unemancipated children under age 26
• Union benefits such as dental and vision coverage
• Paid annual leave and sick leave
• Paid holidays
• A pension
• Optional savings and pre-tax programs such as Deferred Compensation, IRA, and a flexible spending account.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level