Certified IT Administrator (Database), III

City of New York • New York, NY

14h • $100,743 - $142,460 • Onsite

About The Position

The New York City Police Department (NYPD) is seeking a Certified IT Administrator (Database), III to join its Information Technology Services Division (ITSD). ITSD is responsible for acquiring, distributing, installing, and maintaining the Department's technology infrastructure, including networks, computers, software, and data communications. The division also plans and coordinates the implementation of advanced technology to support the NYPD's mission of enhancing the quality of life in New York City through law enforcement, peace preservation, and public safety.

This role is critical in ensuring the availability, security, efficiency, and recoverability of the NYPD's data platforms. The selected candidate will perform a wide range of database administration functions, collaborate with various teams to deliver robust solutions, and potentially supervise subordinates and lead projects.

Requirements

• ONLY THOSE WHO ARE PERMANENT IN THE 'CERTIFIED IT ADMINISTRATOR' (DATABASE) CIVIL SERVICE TITLE WILL BE CONSIDERED. PLEASE INDICATE YOUR CIVIL SERVICE TITLE ON YOUR RESUME.
• Professional/Vendor Certification(s) in database administration that is required for the position to be filled.
• 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;
• OR 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 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.
• All candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in "1" above.

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.
• Implement and manage 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