Database Administrator

City of New York • New York City, NY

13h • $132,170 - $159,151 • Onsite

About The Position

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.

Requirements

• 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.
• (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.

Nice To Haves

• Oracle Enterprise Manager experience preferred

Responsibilities

• 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.

Benefits

• 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 Human Resources Representative to learn more.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level