Oracle Database Administrator III

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. Acts as a Subject Matter Expert, serves as a resource and mentor for other staff. 

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 well 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 L.A. 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.

Applies subject expertise in evaluating business operations and processes. Identifies areas where technical solutions would improve business performance. Consults across business operations, providing mentorship, and contributing specialized knowledge. Ensures that the facts and details are correct so that the project’s/program's deliverable meets the needs of the department, organization and legislation's policies, standards, and best practices. Provides training, recommends process improvements, and mentors junior level staff, department interns, etc. as needed.

Perform other duties as assigned.

Duties Continued

Education Required

Education Preferred

Experience

Required:

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

At least 5 years of technical hands on experience.

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.

Extensive experience with Oracle Database architecture, including RAC, Data Guard, ASM, and Oracle Grid Infrastructure.

Experience with scripting languages such as Shell, Python, or Perl for automation of database tasks.

Experience in managing large-scale databases and mission-critical systems.

Preferred:

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

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

Skills

Required:

Proficiency in working with Unix/Linux and Windows operating systems for database management and scripting.

Knowledge of data modeling techniques, database schema design, and normalization.

Proficiency in database installation, configuration, upgrading, and patching.

Advanced knowledge of SQL and PL/SQL programming for database querying, scripting, and stored procedure development.

Ability in tuning and optimizing database performance using tools like Oracle Enterprise Manager (OEM), AWR, ADDM, and SQL Trace.

Excellent written and verbal communication skills to interact with team members, stakeholders, and users.

Ability in creating and maintaining comprehensive documentation for database configurations, processes, and procedures.

High level of accuracy and attention to detail in managing database configurations and performance tuning.

Ability in implementing and managing high availability solutions like Oracle RAC and Data Guard, and disaster recovery planning.

Ability to manage and execute database projects, including upgrades, migrations, and new implementations.

Ability in working in cross-functional teams and collaborating with developers, system administrators, and other IT professionals.

Licenses/Certifications Required

Licenses/Certifications Preferred

Required Training

Physical Requirements

Additional Information