Director Of Database Administration

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.

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#: 717170. Candidates must be permanent or reachable on a viable civil service list in the Computer Systems Manager 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 $170,000. The salary is non-negotiable. Additional Information: NOTE: This is a full-time on-site position. The incumbent will be required to report to the office on a regular basis. 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.

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.