Oracle Database Administrator III

Salary Range: $105,267.00 (Min.) - $139,478.00 (Mid.) - $156,000.00 (Max.)

Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation’s largest publicly operated health plan. Serving more than 2 million members in five health plans, we make sure our members get the right care at the right place at the right time.

Mission: L.A. Care’s mission is to provide access to quality health care for Los Angeles County's vulnerable and low-income communities and residents and to support the safety net required to achieve that purpose.

Job Summary

The Oracle Database Administrator III is responsible for providing oversight in all aspects of Oracle database systems design, implementation, troubleshooting, and administration. Oversee all aspects of Oracle database system design, implementation, troubleshooting, and administration. Provide tier 2 and 3 support for all corporate Oracle database systems and services to meet or exceed service level agreements. Develop, install, maintain and monitor company databases in a high performance/high availability environment while supporting enterprise projects. Provide general database design, implementation and administration to assure highest reliability and availability of IT services. Maintain database backup/recovery procedures and disaster recovery database environment.

Duties

Develop and support procedures for database security. Implement and support database software upgrade and patch management procedures.

Develop processes, procedures and guidelines for troubleshooting database events and performing tasks.

Evaluate and seek solutions to production issues as wells as new projects. Work closely with application developers and project managers in solving production issues.

Work on Oracle help desk tickets using foot print and resolve the issues and request in timely fashion as defined in SLA.

Work with system admins, storage admins and network admins for getting necessary resources for building databases.

Deploy codes from version control when approved by the IT release management.

Monitor and fix any issues with the daily jobs, and report to production support team as required.

Provide on call support to support databases during maintenance and other necessary periods as defined by LA care policy.

Install and configure Oracle Goldengate and maintain the existing setups.

Manage and monitor more than 100 Oracle databases in various environments such as Dev, QA, and UAT, pre-prod and prod environments.

Perform other duties as assigned.

Duties Continued

Education Required

Bachelor's Degree

In lieu of degree, equivalent education and/or experience may be considered.

Experience

Education Preferred

Required

At least 10 years experience in the design, administration and support of Oracle databases in one or more client server environments (e.g. LINUX, UNIX).

Experience in Oracle 10g/11g/12c.

Experience in Installation and configuration of Oracle database 12c in RHEL.

Experience in applying CPU and PSU patches.

Experience with Oracle ASM and ASM (Automatic Storage Management) disk group management.

Preferred

Experience working with Oracle RAC solutions (Real Application Clusters).

Knowledge and experience in RMAN backup and recovery and Oracle EXPDP and IMPDP.

Skills

Licenses/Certifications Required

Licenses/Certifications Preferred

Required Training

Physical Requirements

Light

Additional Information

Salary Range Disclaimer: The expected pay range is based on many factors such as geography, experience, education, and the market. The range is subject to change.

L.A. Care Offers a Wide Range Of Benefits Including

Paid Time Off (PTO)Tuition ReimbursementRetirement PlansMedical, Dental and VisionWellness ProgramVolunteer Time Off (VTO)