Oracle DBA

Job Title: Oracle Database Administration

Location : Sacramento CA (Hybrid)

Experience: 15 Years

Duration: Long Term

Job Summary:

The consultant will undertake duties and responsibilities as a Senior DBA providing expert technical support for over 400 databases housing critical data for enterprise applications such as PeopleSoft Business Intelligence and Actuarial Valuation System.

The consultant will have a specific focus on the Business Intelligence (BI) application database to troubleshoot develop and enhance further on its functionality.

We are also looking for experience with Oracle Golden Gate and Oracle Data Integrator.

The consultant will act as the technical SME on complex projects and/or may participate with other team members on work efforts of a complex nature and broad scope.

The consultant may be involved in performing a range of work from moderate to highly complex time sensitive and critical for the database environments.

The consultant will also act as a subject matter expert (SME) for new database technology research on-prem and cloud-based database infrastructure database migrations database disk cloning and automation backup process improvements Disaster Recovery advanced programming and scripting to automate processes and leverage advanced technologies.

The scope of this project encompasses the following deliverable base tasks:

Deliverable 1:

Analysis and Design Support for the Client Business Intelligence and other enterprise application databases and Knowledge transfer.

Consultant will participate in analysis and design efforts for enhancing various enterprise system(s) and sub-systems(s) with focus around Business Intelligence (BI) Application database stack.

Provide Database administration for enterprise databases including ensuring high availability monitor database performance implement changes and apply new patches and versions when required.

Work closely with DBAs and customers evaluating requirements and advise on the best architecture that will meet the needs of the business while adhering to client best practices.

Lead and perform database upgrades from Oracle versions 12c to 19c (and RAC) including but not limited to support design and configuration.

All analysis design support and database administration including but not limited to scripts that are created modified tuning of custom scripts stored procedures and packaged data fixes.

Provide 2nd and 3rd tier support to DBA personnel.

Mandatory Skills:

15 years of experience as a Database Administrator (DBA) on Oracle database version 12c or above to include hands-on with Golden Gate or Oracle Data Integrator.

5 years (within last 10 years) of expert experience as a Senior DBA supporting databases on Red Hat Linux 7.x or higher and performing Unix shell scripting.

5 years (within last 10 years) of expert experience performing Oracle database upgrades and migrations to latest Oracle supported version.

5 years (within last 10 years) of experience supporting Oracle databases on ASM (Automatic Storage Management).

5 years (within last 10 years) of experience with Oracle Real Application Clusters (RAC) database version 12c or higher.

5 years (within last 10 years) of expert experience as a DBA supporting databases with a size of at least 10 TB.

5 years (within last 10 years) of experience writing documentation (standards best practices procedures).

5 years (within last 10 years) of experience with Oracle 12c or higher:

Using Tuning Pack Diagnostics Pack and Change Management Pack and/or Automatic workload Repository (AWR).

Writing and tuning PL/SQL objects.

Supporting Oracle databases that utilize the RMAN backups to disk or other mediums.

Supporting Oracle databases using replication/materialized views.

Supporting Oracle databases using triggers.

Implementing Oracle database auditing facilities.

5 years (within last 10 years) of experience as a DBA supporting government retirement and benefits database systems similar to CalPERS.

3 years (within last 5 years) of experience supporting Oracle databases in VMWare and Cohesity environment.

Oracle DBA 11g or higher Certified Professional (must provide proof of certification).