Full Job Description
THE SELECTED CANDIDATE WILL BE OFFERED A SALARY BETWEEN $135,000.00-$145,000.00.
THIS POSITION IS ONLY OPEN TO CANDIDATES WHO ARE PERMANENT (NOT PROVISIONAL) IN THE CERTIFIED IT ADMINISTRATOR (DATABASE) TITLE.
The Senior Oracle Database Administrator will provide technical leadership in maintaining a secure, highly available, high-performing, and resilient Oracle database infrastructure supporting ACS's mission-critical applications. The position requires strong problem-solving skills, sound technical judgment, and the ability to independently manage complex database environments while collaborating effectively with internal teams and technology vendors.
Key responsibilities:
- Administer, configure, maintain, and support Oracle RAC 19c and 23ai databases hosted on Exadata and across hybrid multi-cloud environments.
- Design and implement Oracle database solutions and migrations across Oracle Cloud Infrastructure (OCI), AWS, and Microsoft Azure.
- Administer Oracle Exadata, RAC, ASM, Grid Infrastructure, and Data Guard environments, including upgrades and lifecycle management.
- Monitor database performance and resource utilization; identify and resolve performance, capacity, and availability issues.
- Plan, test, and implement quarterly Oracle patches, security updates, and other database maintenance activities.
- Implement and maintain database security and encryption using Oracle Key Vault and established security standards.
- Develop and maintain backup, recovery, and disaster recovery solutions using Oracle technologies and Veeam.
- Conduct periodic disaster recovery and database recovery tests and maintain documented recovery procedures.
- Configure, schedule, and monitor Oracle database jobs, alerts, and automated processes.
- Maintain high availability and provide 24x7 support for critical database environments and production incidents.
- Troubleshoot complex database and infrastructure issues and coordinate with Oracle and other technology vendors to resolve them.
- Follow established change management, incident management, and database outage communication procedures.
- Maintain accurate technical documentation, operational procedures, and disaster recovery documentation.
- Collaborate with application, infrastructure, security, cloud, and vendor teams to ensure reliable and secure database services.
- Identify opportunities to improve database performance, availability, security, automation, and operational efficiency.
Special note:
- The candidate may be required to work after hours and at weekends as needed.
TO APPLY
Please go to www.cityjobs.nyc.gov and search for Job ID #803201.
No phone calls, faxes or personal inquiries permitted.
Note: Only candidates under consideration will be contacted.
CERT IT ADMINISTRATOR (DB) - 13644
Qualifications
Professional/Vendor Certification(s) in database administration that is required for the position to be filled. In addition, you must have one of the following:
1. A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management;
2. A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience (IT) of which at least two years must have been database administration experience as described in "1" above; OR
3. A satisfactory equivalent of education and/or experience equivalent to "1" or "2" above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from
an accredited college or university is equivalent to 6 months of information technology experience, but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college or university may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in "1" above.