"Alerted.org

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. Please visit us at www.nyc.gov/nycppf 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.

We are seeking a highly experienced Director of Database Administration to lead both the development and oversight of mission-critical systems, including the ongoing enhancement of the Comprehensive Officers Pension System (COPS) 2.0 and other legacy applications. This is a hybrid role that requires a unique blend of technical leadership and team management.

The ideal candidate is comfortable diving deep into code, databases, and legacy platforms, while also managing a development team, aligning technical efforts with strategic goals, and ensuring the reliability and performance of critical systems.

Duties and responsibilities of this candidate will include, but are not limited to, the following:

- Lead the development and maintenance of Java and web-based applications;

- Perform hands-on programming using Java SE/EE, JavaScript, JSON, SQL, HTML, CSS, and frameworks;

- Maintain and enhance Oracle SQL-based systems and databases, including:

- Writing complex SQL queries;

- Supporting Oracle Forms, WebLogic, and Database Application tasks.

- Support and maintain legacy applications, particularly Microsoft (MS) Access databases using Visual Basic (VB);

- Collaborate with the Freedom of Information Law (FOIL) unit to extract, format, and deliver data requests using SQL;

- Manage both Linux (preferably Red Hat) and Windows environments, including:

- Overseeing patching schedules;

- Performing shell scripting tasks.

- Configure and manage tools such as TOAD, PL/SQL, and IBM DB2 Connect;

- Partner with the Management, Analysis, and Planning (MAP) Unit and Actuarial teams to prepare yearly processing environments and annual statement infrastructure;

- Maintain a hands-on presence within the team to troubleshoot and optimize system performance;

- Support the Chief Technology Officer (CTO) with special initiatives and assignments as needed.

Managerial Requirements:

- Minimum of 10 years of managerial experience in environments centered around Oracle technologies;

- Demonstrated success in leading teams responsible for the development and support of Java and web-based applications;

- Strong analytical skills and a proactive approach to problem-solving in both legacy and modern systems;

- Hands-on leadership approach with the ability to actively contribute to technical tasks.

Technical Requirements:

- 5-10+ years of hands-on Java programming experience including Java SE/EE, JavaScript, JSON, HTML, CSS, Web development frameworks, and GUI development tools (e.g., SQL Developer or equivalent);

- Proficiency in Oracle SQL programming;

- Strong experience working within Linux (Red Hat preferred) and Windows environments;

- Familiarity with patch management and shell scripting on both Linux and Windows platforms;

- Must be capable of writing SQL queries and supporting FOIL data requests;

- Comfortable maintaining legacy MS Access systems;

- Experience working with and modifying MS Access databases, including using VB.

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#: 749523

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 $150,000. 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 onsite 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 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 individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

Salary Min: $150,000.00

Salary Max: $159,151.00