Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The Information Technology Services Division (ITSD) supports the Department by acquiring, distributing, installing and maintaining Local Area Networks, personal 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, patching, troubleshooting, SSIS and SSRS deployments, and security management.

Responsibilities

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.

Requirements

Only permanent employees in the title and those that are reachable on the civil service list are eligible to apply.
Must indicate if permanent or include Civil Service List # in cover letter.
Must verify identity and eligibility to work in the United States.
Must complete required employment eligibility verification document form upon hire.
Professional/Vendor Certification(s) in database administration required.
Must have at least one year of satisfactory full-time (not classroom based) database administration experience.

Skills

SQL Server database administration
SSIS
SSRS
Clustering
Replication
Always on
Database design
Database configuration
Database installation
Database troubleshooting
Database integration
Database performance monitoring
Database maintenance
Database enhancement
Database security management

Location

New York City

Work Type

Full-time

Experience Level

Two years of satisfactory full-time experience in database administration (if applicable)
Six years of satisfactory full-time information technology experience, with at least two years in database administration (if applicable)

Education Level

Baccalaureate degree from an accredited college or university
Four-year high school diploma or its educational equivalent
Masters degree in computer science or a related field

Salary/Compensations

$125,000 to $150,000
USD 100743 - USD 142460

Benefits

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
Pension
Optional savings and pre-tax programs such as Deferred Compensation, IRA, and a flexible spending account

About the Company

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 by incorporating Neighborhood Policing into all facets of Department operations, and solve the problems that create crime and disorder through an interdependent relationship between the people and its police, and by pioneering strategic innovation.
Agency: POLICE DEPARTMENT
Job Category: Technology, Data & Innovation

Equal Opportunity

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.