Certified IT Administrator (Database), II

City of New York - New York, NY

Full-time - Mid Level

New York, NY

Executive, Legislative, and Other General Government Support

About the position

The Certified IT Administrator (Database), II position at the New York City Police Department involves leading a team responsible for SQL Server database administration functions. The role focuses on maintaining multiple database environments, ensuring data security, availability, and integrity, and collaborating with various teams to implement robust database solutions. The position is critical in supporting the IT Services Division's mission to enhance the quality of life in New York City through effective technology management.

Responsibilities

• Leads a team performing SQL Server database administration functions, including maintenance of multiple environments (development, testing, production), patching, troubleshooting, SSIS & SSRS deployments, and security management.
• Supervises database administration duties, including installations, patching, backup and recovery management, schema management, startup, and shutdown.
• Designs and implements redundant systems, policies, and procedures for database recovery and data archiving to ensure effective protection, maximum availability, and integrity of data assets.
• Monitors and analyzes data platforms to ensure databases are available, secure, healthy, efficient, and recoverable as per expectations.
• Builds and manages HA & DR architectures like Clustering, Replication, and Always On.
• Implements and manages the physical databases of mission-critical systems to determine future storage needs.
• Collaborates with application owners to develop a seamless process to migrate their schema and data to the data platform.
• Partners with development and quality assurance teams to deliver robust, quality on-time solutions.
• Directs, provides guidance, and assists subordinates in testing, developing, and troubleshooting database applications.

Requirements

• Professional/Vendor Certification(s) in database administration required for the position.
• 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.
• A four-year high school diploma or its educational equivalent and six years of satisfactory full-time IT experience, with at least two years in database administration as described above.
• A satisfactory equivalent of education and/or experience equivalent to the above, with specific substitutions allowed for undergraduate education and master's degrees.

Benefits

• Health insurance for the employee and their 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.
• Pension plan.
• Optional savings and pre-tax programs such as Deferred Compensation, IRA, and flexible spending account.