Oracle DBA - Database Administrators x 2
-
Job ref:
1169820/004_1570540282
-
Location:
London, England
-
Sector:
-
Job type:
-
Salary:
£450 - £550 per day
-
Contact:
Phil Johnson
-
Email:
-
Published:
over 1 year ago
-
Duration:
31/03/2020
-
Start date:
October 2019
-
Consultant:
#
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
