Database Administrator

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 33000 active members and 53000 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 Funds 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 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 $132170. If you possess the preferred skills above consideration will be given to offer you a maximum annual salary of no more than $159151. 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 Employees Retirement System that offers health insurance benefits upon retirement. Please speak with your Human Resources Representative to learn more.

COMPUTER SPECIALIST (SOFTWARE) - 13632

Qualifications :

(1) A baccalaureate degree from an accredited college including or supplemented by twenty-four (24) semester credits in computer science or a related computer field and two (2) years of satisfactory full-time software experience in designing programming debugging maintaining implementing and enhancing computer software applications systems programming systems analysis and design data communication software or database design and programming including one year in a project leader capacity or as a major contributor on a complex project; or
(2) A four-year high school diploma or its educational equivalent and six (6) years of full-time satisfactory software experience as described in 1 above including one year in a project leader capacity or as a major contributor on a complex project; or
(3) A satisfactory combination of education and experience that is equivalent to (1) or (2) above. College education may be substituted for up to two years of the required experience in (2) above on the basis that sixty (60) semester credits from an accredited college is equated to one year of experience. A masters degree in computer science or a related computer field may be substituted for one year of the required experience in (1) or (2) above. However all candidates must have a four year high school diploma or its educational equivalent plus at least one (1) year of satisfactory full-time software experience in a project leader capacity or as a major contributor on a complex project.
NOTE: In order to have your experience accepted as Project Leader or Major Contributor experience you must explain in detail how your experience qualifies you as a project leader or as a major contributor. Experience in computer operations technical support quality assurance (QA) hardware installation help desk or as an end user will not be accepted for meeting the minimum qualification
requirements.
Special Note
To be eligible for placement in Assignment Level IV in addition to the Qualification Requirements stated above individuals must have one year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration database management systems operating systems data communications systems capacity planning and/or on-line applications programming.

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 individuals sex race color ethnicity national origin age religion disability sexual orientation veteran status gender identity or pregnancy.

Remote Work :

No

Employment Type :

Full-time

Key Skills
Databases,Disaster Recovery,SQL,High Availability,Microsoft SQL Server,ssrs,Database Design,Performance Tuning,SSIS,Database Administration,Sybase,Oracle
Experience: years
Vacancy: 1