Certified IT Administrator (Database), III

City of New York; New York (NY); On-site; USD 125,000 - 150,000; Full time

Benefits offered by this job

Health insurance

Pension plan

Paid leave

Job summary

The City of New York Department seeks a Certified IT Administrator (Database) to manage SQL Server environments across development, testing and production. You will ensure availability, security and recoverability while implementing HA/DR strategies and leading multi-team efforts.

The role requires a CS/IT background with relevant DB administration experience and a focus on performance, patching and backup management as part of a broad IT services function.

Qualifications

• Bachelor's degree in a related field and 2+ years of database administration experience.
• Alternate path: high school diploma with 6+ years IT experience, 2+ in DB admin.
• Master's degree can substitute for up to 1 year of DB admin experience.

Responsibilities

• Perform SQL Server database administration across development, testing and production environments.
• Monitor and analyze data platform health, security, and recoverability.
• Build and manage HA and DR architectures (Clustering, Replication, Always On).
• Plan capacity for future storage needs of mission-critical databases.
• Collaborate with application owners to migrate schemas and data to the data platform.
• Coordinate with development and QA to deliver robust solutions.
• Supervise staff and lead multi-team projects.
• Oversee SQL Server installation, configuration, patching and backups.

Skills

SQL Server administration

Patch & security management

HA/DR planning

Team leadership

Education

Bachelor's degree in CS/IT

4-year high school diploma + 6 years IT exp.

Master's degree substitute for experience

Tools

SSIS

SSRS

Always On/Clustering

Job description

Certified IT Administrator (Database), III

• Full-time
• Agency: POLICE DEPARTMENT
• Salary Band: $125,000 to $150,000
• Compensation: USD 100,743 - USD 142,460

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.

The mission of the New York City Police Department is to enhance the quality of life in New York City by working in partnership with the community to enforce the law, preserve peace, protect the people, reduce fear, and maintain order. The New York City Police Department strives to foster a safe and fair city through the strategic deployment of resources, focusing on both crime prevention and addressing quality-of-life concerns while building lasting community relationships.

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

ADDITIONAL INFORMATION

In compliance with Federal Law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

The City of New York offers a comprehensive benefits package including 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, and optional savings and pre‑tax programs such as Deferred Compensation, IRA, and a flexible spending account.

CERT IT ADMINISTRATOR (DB) - 13644

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