Database Administrator

Job Description

About the New York City Police Pension Fund
The New York City Police Pension Fund (NYCPPF or the “Fund”) is dedicated to providing superior service to its 33,000 active members and 53,000 retired members of the New York City Police Department. We remain committed to providing courteous, professional service by providing customized attention throughout our lifelong partnership with the uniformed staff of the NYPD and their families. We are looking for individuals with passion, dedication and commitment to excellence and innovation who are interested in adding to our dynamic and collaborative work environment. Visit the NYC PPF Website to learn more.

Job Description
Our IT Department, comprising of 14 dedicated professionals, is the backbone of support for the New York City Police Pension Fund. Leveraging a diverse range of expertise, we ensure seamless integration of cutting-edge technology solutions, guaranteeing the Fund's digital infrastructure remains robust and secure.

The Fund is seeking a full-time Oracle Database Administrator / Oracle PL/SQL Developer to join the IT Development Operations (DevOps) team. This role is responsible for the administration, performance, security, and availability of enterprise Oracle database environments, as well as the development and maintenance of PL/SQL database objects.

The ideal candidate will possess strong technical expertise in Oracle 19c and higher, demonstrate excellent problem-solving skills, and have hands-on experience supporting mission-critical database systems in both Linux and Windows environments. This role plays a key part in ensuring optimal database performance, reliability, and scalability.

Duties and responsibilities include, but are not limited to, the following:
- Lead the installation, configuration, upgrading, and patching of Oracle databases (19c and above);
- Architect, implement, and manage high-availability and disaster recovery solutions, including RAC, ASM, and Data Guard;
- Perform advanced database performance tuning, including SQL tuning, AWR/ASH analysis, and wait event analysis;
- Design, implement, and maintain enterprise backup and recovery strategies using RMAN;
- Manage database security, including encryption, auditing, compliance, roles, and access controls;
- Proactively monitor database environments to prevent performance or availability issues (Oracle Enterprise Manager experience preferred);
- Lead major database upgrades, migrations, and consolidation initiatives;
- Automate DBA operational tasks using Shell scripting, SQL, PL/SQL, and/or Python;
- Develop and maintain complex SQL and PL/SQL code, including stored procedures, packages, triggers, views, and functions;
- Work with Data Warehouse components, including LOBs and external tables;
- Provide 24x7 production support and lead root-cause analysis for critical incidents;
- Collaborate closely with application development, infrastructure, and information security teams;
- Mentor junior DBAs and review operational procedures for accuracy and effectiveness;
- Maintain database standards, best practices, and comprehensive technical documentation, including data dictionaries and data mappings;
- Coordinate project activities with internal teams and external consultants, including estimating timelines and resource requirements and contributing to project plans.

Work Location: 233 Broadway, New York, NY 10279
Shift: 8:00 AM – 4:00 PM

HOW TO APPLY
Go to https://cityjobs.nyc.gov and search for Job ID#: 768964

Candidates must be permanent or reachable on a viable civil service list in the Computer Specialist (Software) title to be considered for this position unless you are applying through the 55-a program.

This position is open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate in your cover letter that you would like to be considered for the position under the 55-a Program.

Salary: The hiring rate being offered for this position is $132,170. If you possess the preferred skills above, consideration will be given to offer you a maximum annual salary of no more than $159,151. The salary is non-negotiable.

Additional Information

NOTE: This is a full-time on-site position where you will be required to report to the office five (5) days a week for training purposes. After successfully completing training, you may be considered for telework.

A career with the New York City government provides employees with a comprehensive benefits package. As a City employee, you and your family will have access to a range of benefits that are designed to make your City career very rewarding, including a Pension Plan with the New York City Employee’s Retirement System that offers health insurance benefits upon retirement. Please speak with your