Oracle DBA - Database Administrators x 2

Oracle DBA x2

+ London based roles

+ 6 month initial duration

+ £450-£550 per day - currently outside IR35 regulations

+ SC Cleared role - HMPO

The client requires its Oracle environment to be maintained at a serviceable level. You will assist to upgrade the Oracle database environment from Oracle 11r1 to Oracle 11r2 to maintain this serviceable state.

Project requires an HMPO SC security cleared Oracle DBA (Database Administrator) resources to perform the Oracle 11r2 and Oracle Warehouse Builder upgrade work.

Objectives:

Phase 1:

• PoC and DDT upgrade work - prepare and test Veritas Cluster, GRID and Oracle DB Upgrade work in a sandpit environment

• DDT Upgrade - upgrade DDT Oracle DB environments

• Phase 2 planning - all planning activities inclusive of required testing approach

Phase 2:

• Pre-Production upgrade - Upgrade Veritas Clusters, GRID and Oracle Databases in IL3 and IL5. SIT1 then Pre-Prod

• Test Plan creation to support the detailed Testing and acceptance of Pre-Prod environment

• Production upgrade - Upgrade Veritas Clusters, GRID and Oracle Databases in IL3 and IL5 in Prod over agreed weekends

• Remaining Upgrade Tasks - Upgrade Veritas Clusters, GRID and Oracle Databases in IL3 and IL5 in SIT2 and SIT3

• Oracle Warehouse Builder - Upgrade OWB in IL3 and IL5 across SIT1, Pre-Prod, Prod, SIT2 and then SIT3

Required Skills:

• ORACLE v10, 11g, 12C

• ORACLE Warehouse Builder

• SQL SERVER

• ORACLE SQL PL/SQL

• ORACLE SQL loader

• UNIX and LINUX shell programming

• ORACLE RAC, ASM, OCFS, streams, ORACLE Database Appliances (ODA), ORACLE Enterprise Manager, Data guard

• UNIX, REDHAT Linux, IBM AIX

• ITIL v2/3 principles