Job Description :
Note: Candidate Must have Oracle DBA 11g or higher Certified Professional (provide proof of certification)

DESIRED QUALIFICATIONS


INTRODUCTION
To provide support the current Actuarial (ACTO) environments, both production and non-production, as well as participate in the database design and analysis of the ACTO database.
This Letter of Engagement details the services to be provided by one Database Administrator (“DBA”; “consultant” or “key personnel”) in support of all (non-production and production) environments. Work will include supporting, tuning refresh and backup of the PeopleSoft Oracle environments.
This consultant DBA will provide services for, but not limited to, the Actuarial Oracle databases.

PROJECT SCOPE/TASKS
The scope of this project encompasses the following tasks in Oracle 11g /12c; Red Hat Linux 5.x/6.x, Exadata and Windows environment for Actuarial environments:
Designing a database from a logical data model
Creating the DDL to implement and modify a database using ERwin
Sizing database tables and indexes
Designing a physical database, capacity planning, ASM storage requirements
Generating views
Optimizing and tuning SQL statements using hints, explain plan, TKPROF, StatsPack, ADDM and AWR
Writing PL/SQL objects including database triggers
Executing customer created scripts, i.e. stored procedures, packages, data fixes, etc.
Setting up database replication
Setting up partitioned tables/indexes
Installing Oracle software
Creating Oracle instances
Creating and recovering Oracle databases from a variety of sources: RMAN, “cold” and “hot” backups
Monitoring Oracle databases using Oracle Grid Control
Creating/maintaining Unix Shell scripts
Documenting procedures and best practices
Responding to help desk tickets
Following established change control procedures
Setting up Oracle Data Guard or Standby databases
Supporting Oracle RAC 11gR2 databases
Supporting databases on Oracle Exadata and ZFS appliances
Automation of ZFS cloned Oracle databases
Automation of ZFS backups and restores for the Enterprise Oracle databases
Migration of databases to VMWare platform
The consultant DBA will also be required to provide weekly written status reports and timesheets. All work products will follow internal standards and procedures.

KNOWLEDGE TRANSFER
Throughout this contract’s duration, the consultant will coach and mentor Oracle Database Administration staff to broaden their exposure to and increase their hands-on experience. Where applicable, the contractor will transfer knowledge as follows:
Knowledge transfer by documentation (i.e. procedures and best practices Document any procedures created for monitoring and/or supporting Oracle databases. Document any process created or changed to provide support in maintaining and enhancement of the Oracle databases.
Knowledge transfer by job shadowing. Train staff on new and changed Oracle technology and/or processes.

MINIMUM QUALIFICATIONS
1. Five (5) years of experience as an Oracle Database Administrator (DBA) on Oracle database version 11g or above.
2. Five (5) years of experience as a DBA supporting databases on Red Hat Linux 5.x or higher.
3. Five (5) years of experience writing Unix Shell scripts.
4. Five (5) years of experience as a DBA supporting databases with a size of at least 7 TB.
5. Five (5) years of experience with Oracle 11g or higher:
o Using Tuning Pack, Diagnostics Pack, Change Management Pack and/or Automatic Workload Repository (AWR)
o Writing PL/SQL objects.
o Supporting Oracle databases that utilize the RMAN backups to disk and tape.
o Supporting Oracle databases using replication/materialized views.
o Supporting Oracle databases using triggers.
o Using Oracle database auditing utilities.
6. Five (5) years of experience writing documentation (standards, best practices, procedures
7. Five (5) years of experience designing a database from a logical data model using ERWin and creating a physical database from a logical model.
8. Five (5) years of experience supporting Oracle databases on ASM (Automatic Storage Management
9. Three (3) years of experience with Oracle Exadata and Oracle ZFS storage appliance with Oracle databases.
10. Five (5) years of experience with Oracle Real Application Clusters (RAC) database version 11g or higher.
11. Five (5) years of experience as a DBA supporting actuarial systems.
12. Oracle DBA 11g or higher Certified Professional (provide proof of certification

DESIRED QUALIFICATIONS
1. Experience as a DBA supporting government retirement database systems.
2. Experience with virtualizing Oracle databases.
3. Experience working (i.e. database design, SQL scripting and tuning, SDLC processes) in an actuarial environment.