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.
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:
1. Perform SQL Server database administration functions, including maintenance of multiple environments (development, testing, and production), patching, troubleshooting, SSIS & SSRS deployments and security management.
2. Monitor and analyze data platforms to ensure database is available, secure, healthy, efficient and recoverable as per expectations.
3. Implement and manage the physical databases of mission critical systems capacity planning to determine future storage needs.
4. Collaborate with application owners to develop a seamless process to migrate their schema and data to data platform.
5. Partner with development and quality assurance teams to deliver robust, quality and on-time solutions.
6. Build and manage HA & DR architecture like Clustering, Replication and Always on.
WORK LOCATION:
1 POLICE PLAZA
TO APPLY:
To apply, please visit: https://cityjobs.nyc.gov and search for Job ID #771240
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
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.
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.
Skills Required
- Baccalaureate degree from an accredited college or equivalent experience
- Four years of related full-time experience or equivalent
- SQL Server database administration across development, test, and production environments
- SSIS and SSRS deployment and security management
- Database monitoring, performance analysis, backup and recovery, and security
- Capacity planning and management of physical databases and storage needs
- Schema and data migration planning and execution in collaboration with application owners
- Experience designing and managing HA and DR architectures (Clustering, Replication, Always On)
- Ability to collaborate with development and QA teams to deliver solutions
.png)
