Data Architect

Overview

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 NYPD 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) oversees critical projects and technological initiatives within the NYPD. They maintain and enhance the department’s IT infrastructure, including networks, servers, and workstations. ITSD has rolled out various advancements, such as equipping officers with cellular phone applications and digitizing department forms to improve efficiency.

• Perform SQL Server database administration functions, including maintenance of multiple environments (development, testing, and production), patching, troubleshooting, SSIS & SSRS deployments and security management.
• Monitor and analyze data platforms to ensure database is available, secure, healthy, efficient and recoverable as per expectations.
• 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 and on‑time solutions.
• Build and manage HA & DR architecture like Clustering, Replication and Always on.

1 Police Plaza

To apply, please visit: (Use the "Apply for this Job" box below). and search for Job

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 un‑emancipated 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.

A baccalaureate degree from an accredited college and four years of satisfactory full‑time experience related to projects and policies required by the particular position; or, education and/or experience which is equivalent to "1" above.

• Strong understanding of database structures, principles and practices. Working knowledge of Microsoft SQL Server 2016/2017/2019/20202.
• Proficiency in SQL Server installation, configuration, patching and database back‑up/recovery.
• Knowledgeable with Windows server, Security delegation, Storage components.
• Solid knowledge of SQL Server HADR Solution, Data Replication, SSIS and SSRS.

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.