The company protects children and families through child welfare, juvenile justice, foster care and subsidized childcare voucher services. Child protection staff respond to reports of child maltreatment.
The IT group keeps the agency's technology running for the families it serves, along with vendor partners and other city agencies. Its Production Support unit runs the database environment behind critical applications.
This senior technical role focuses on keeping a secure, resilient Oracle database platform running. You will manage complex environments largely on your own and work with internal teams and vendors.
Responsibilities
Run Oracle RAC 19c and 23ai databases on Exadata and across hybrid multi-cloud setups.
Design and carry out Oracle database builds and migrations to OCI, AWS and Microsoft Azure.
Manage Exadata, RAC, ASM, Grid Infrastructure and Data Guard, including upgrades and lifecycle work.
Watch performance and resource use, and fix performance, capacity and availability problems.
Plan, test and apply quarterly Oracle patches, security updates and other maintenance.
Set up and maintain database security and encryption with Oracle Key Vault, following security standards.
Build and maintain backup, recovery and disaster recovery plans using Oracle tools and Veeam.
Run disaster recovery and database recovery tests on a regular schedule and keep recovery procedures written down.
Set up and monitor Oracle database jobs, alerts and automated processes.
Keep critical databases highly available and provide 24x7 support for them and for production incidents.
Troubleshoot complex database and infrastructure faults and work with Oracle and other vendors to fix them.
Follow change management, incident management and outage communication procedures.
Write and update technical documentation, operating procedures and disaster recovery documents.
Work with application, infrastructure, security, cloud and vendor teams to keep database services reliable and secure.
Look for ways to improve database performance, availability, security, automation and efficiency.
You may need to work after hours and weekends when required.
Requirements
Hold a database administration professional or vendor certification that the position requires.
Meet one of the following education and experience routes:
A bachelor's degree from an accredited college or university, plus 2 years of full-time, non-classroom database administration experience covering design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement and security management.
A 4-year high school diploma or equivalent, plus 6 years of full-time, non-classroom IT experience, with at least 2 years of database administration experience as described above.
An equivalent combination of education and experience to either route above. 30 undergraduate semester credits from an accredited college or university count as 6 months of IT experience but cannot replace the required database administration experience. A master's degree in computer science or a related field can replace 1 year of database administration experience. All candidates still need at least 1 year of full-time, non-classroom database administration experience.
Conditions
Pay is between $135,000.00 and $145,000.00.
Only candidates who hold permanent, not provisional, status in the Certified IT Administrator (Database) title can apply.
Under Section 424-A of the New York Social Services Law, the agency must ask whether candidates for child-caring roles have been the subject of a child abuse and maltreatment report.
The city is an equal opportunity employer and bars discrimination and harassment based on any legally protected status.