Data Architect

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) oversees critical projects and technological initiatives within the NYPD. They maintain and enhance the department's IT infrastructure, including networks, servers, and workstations. Notably, ITSD has rolled out various advancements, such as equipping officers with cellular phones applications and digitizing department forms to improve efficiency. Duties ITSD is seeking a qualified candidate in the position of IT Security Specialist to act as a Data Architect who will complete duties including but not limited to the following: 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. WORK LOCATION: 1 POLICE PLAZA To Apply [Removed: Application instructions present in the original text] 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 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. IT SECURITY SPECIALIST - 95622 Minimum Qualifications 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. Preferred Skills 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. Residency Requirement New York City Residency is not required for this position Additional Information 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. #J-18808-Ljbffr