Oracle Database Services: Sr Tech Specialist

TITLE OF POSITION

Oracle Database Services: Sr Tech Specialist

PERIOD OF PERFORMANCE

1 Year

REFERENCES

Three

INTERVIEW

Virtual or Client location (As client's Discretion)

PLACE OF PERFORMANCE

Offsite (Consultant may be required to report to CalPERS Headquarters location)

SCOPE OF WORK

The consultant(s) 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 myCalPERS, PeopleSoft, Business Intelligence and Actuarial Valuation System. The consultant(s) 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(s) 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(s) may be involved in performing a range of work from moderate to highly complex, time sensitive, and critical for the database environments. The consultant(s) 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.

*Mandatory Experience

Please see attachment A- Evaluation Criteria- Separately attached (Candidate needs to fill out the form)

Role and Responsibilities

Deliverable 1: Analysis and Design Support for the myCalPERS, 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 CalPERS best practices. Lead and perform database upgrades from Oracle versions 12c to 19c (and RAC), including but not limited to support, design, and configuration. Provide 2nd and 3rd tier support to DBA personnel. 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 etc. will have the following components:

1. Planning and execution proposal
2. Documentation
3. Knowledge transfer to take place via regular scheduled meetings which include, review, cross training, and job shadowing. On an ongoing basis through the end of the contract all work products and deliverables (project status reports, business process, triage incident reports with resolution, meeting minutes, test cases, test outcomes) details have to be discussed with the contract manager to ensure that all of the information is documented and placed in a file share. The contract manager will schedule knowledge transfer sessions at regular intervals to ensure that all of the work production details have been documented and the knowledge has been transferred to the state personnel.

Minimum Requirements

Candidate Remarks

Qualifications

1. Fifteen (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.

1. Five (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.

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

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

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

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

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

1. Five (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.

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

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

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