Spencer - DBA ORACLE

MAIN PROJECTS

UBS - Zurich Jan 2019- Now
ORACLE IAM- OID/OUD ENGINEER
OID Data migration from 10g to 11g & Replication, SSL Configuration on OID/OUD
- Update OID Java plugin and upgrade OID 11.1.1.7 to 11.1.1.9
- Engineering scripts on Linux for ldap migration OID 11g to OUD 12c
- PoC – Enterprise User Security -EUS with ProgreSql and MS SQL
- Migrating IIS Server Applications/AD from Windows 2008 to windows 2012
- Provisioning/Reconciliation of users from AD to OID/OUD/OIM/OEM

UBP - Geneva Jun 2017- Dec 2019
Senior Oracle/IAM Engineer
Database Migration 11g to 12c, 18c, Sqlserver 2008/2012 to 2014
- Maintaining Oracle OID infrastructure, Update access management workflow
- Troubleshooting access management & Upgrading Grid Control 12c to 13c
- Configure SSO between Oracle e-business with AD & OAM , OID

UBS - Zurich Sep 2015- Dec 2016
LDAP IAM OID-OUD ENGINEER
OID Data migration from 10g to 11g & SSL Configuration on OID,OUD
- Update Oracle Waveset Connector with OID 11g
- Migration Oracle Waveset to OIM –Oracle Identity Manager 11g
- Engineering scripts to manage database access on EUS Entreprise User Security
- Oracle Tuning, Audit on OID Databases , Engineering scripts for OUD/OID DBaaS
- Setup OID Replication between UBS Sites, Disaster Recovery plan with Dataguard

Canton de Vaud - Lausanne Jan 2015- July 2015
DATABASE ENGINEER
Installation, Upgrade, Cloning of Oracle E-Business R12.2.4 11gR2 Rac/Linux
- GoldenGate 11g replication from Oracle11g to SqlServer 2008/2012
- Migration Oracle Rac 11gR2 to Oracle 12c Rac, update Rman backup scripts
- Oracle Dba RAC on call support, Support Transition Process
- Optimization & Tuning of Oracle E-Business R12.2.4 on Oracle 11gR2 RAC

Nestle/Nespresso – Lausanne Jan 2011- Dec 2015
SENIOR ORACLE DBA PRODUCTION
Regular Restore & Backup Projects on Oracle 11gR2 AIX / TDP-TSM
- Implementation of Oracle Security Compliance and Transparent Data Encryption
- Designed and implementation of Oracle Streams scripts on AIX
- Oracle Dba 11g RAC and DataGuard support
- Optimization & Tuning Performance analysis for Nespresso Database

International Data Center- Zurich Oct 2010- Mar2011
SENIOR ORACLE DBA
Installation of Oracle E-Business R11 on 11gR2Rac/Linux/ASM
- Implementing Rman script on OEM & DRP with Dataguard
- Configuration of Grid Control 12c& Integration with AD/OID.
- Administration and Tuning Support on Sqlserver 2008

Credit-Suisse –Zurich Sep 2009- Sep 2010
SENIOR ORACLE ENGINEER
Optimization, Support &Installation of Oracle 11g Rac/ASM on Sun Solaris
- Strong Authentication with AD/Kerberos on Oracle 11g/Rac
- Securing database with Oracle Database Vault 11g and Data/Network Encryption
- Support onPKI Infrastructure and on hands Oracle application weblogic issues
- Testing and Configuring Rman compression script on 11gR2
- Configuring SSL with MSCAPI and Enterprise User Security

September 2007- TILL NOW
* S-H Geneva - International Data Center
DBA RAC ORACLE
- Installation of Oracle 10g Rac/Linux/ASM/ SAN 4 nodes for Ebusiness Suite
- Administration, Support on backup/restore Rman/Upstream for 10g Rac
- Installation, Configuration of Grid Control and agent 10g deployment
- Implementing Datavault on PeopleSoft and support on Oracle Application Server
- Configuring Oracle10gRac/ASM for Oracle Applications Release 11i
- Implementation of Oracle Maximum Availability architecture with Rac/Dataguard
- Deployment of Oracle Application Plugin Ebusiness on Grid Control

December 2005 – JULY 2007
* ATOS ORIGIN
DBA RAC ORACLE
- Administration, Support on backup/restore Rman/TDP
- Implementation of monitoring snmp agents via Tivoli Netview and OEM
- Application development of triggers, scripts for Veritas Volme Replicator
- Installation & Support on Oracle 10g RAC 6 nodes on Redhat
- Deployment of Oracle Stream on 10gRac and Tuning Oracle 10g Rac

December 2002 – JUNE 2005
* IBM GLOBAL SERVICES – e-Business Web Hosting
DBA-PRODUCTION TEAM ORACLE
- Administration and Monitoring via Patrol Bmc and Tivoli
- Backup/Recovery procedures via Rman /TDP
- Implementation Tivoli Netview and Patrol alerts on Sqlserver and Oracle
- Users Support and patchs maintenance
- Migration sqlserver2000 to Oracle9i
- Configuration and Administration of Oracle Failsafe
- Tuning data warehouses queries on Oracle and Partitioning

AVRIL 2002- December 2002 MDBINFORMATIQUE FRANCE
* CARREFOUR
DBA ORACLE DATAWAREHOUSE
- Designed of the Mandala Datawarehouse architecture on AMC designer
- Implementing data loading via SQL*LOADER and data transformations via PL/SQL
- Auditing and Optimising of Oracle instances
- Partitioning of Aggregation data tables
- Optimisation of SQL query generated by MicroStrategy
- Monitoring, tuning and Sizing per month/per store of Oracle Databaseses
- Implementing Database Security mesures and Backup Procedures
- Installation and Configuration of Oracle9i on Mandrake Linux 8.1/Redhat 7

JANVIER 2000 – MARS 2002 ALEXSYS FRANCE/BELGIUM
DBA ORACLE/ SQLSERVER
• Designed and analysis of mybooster database on AMC designer
• Installation, Network configuration of NT, IIS and DNS Servers
• Administration and Tuning on sqlserver2000
• Implementing NT and Oracle backup procedures .
• Migration of Oracle database to Microsoft SQLSERVER .
• Migration of data from SQLSERVER7 to SQLSERVER2000.
• Conversion of Oracle Forms and Reports to Visual basic /ASP web forms.
• Development of new triggers and stored procedures on SQLSERVER200.
• Analysis and Implementation of datawarehouse in commercial depart with Olap.
• Implementing Backup and replication procedures on SQLSERVER2000 .
• Development of DTS packages on SQLSERVER2000 with Visual Basic.
• Installation and Configuration of Biztalk Server
• Creation of Biztalk messaging and XML specification on BiztalkServer.
• Development of Biztalk AICcomponent (ApplicationIntegrationComponents)with VB
• Building of ASP components Com+/DLL with Visual Basic .
Technical Environment: Oracle 8i, 9i, , Sql*Loader, PL*SQL, Hp Unix 11i, AIX Unix 3.4, Windows 2000 advanced Server, MicroStrategy, Mandrade Linux 8.1, AMC*Designer, Solaris , BMCPatrol, Redhat , sqlserver

*STIME INTERMARCHE : DBA – ORACLE
• Oracle Support and Tuning
• Migration of data from Oraclev7 to Oraclev8
• Installation and configuration of Oracle Parallel server and Cluster
• Analysis and Designed of datawarehouse system
• Development of Reports on Oracle Reports 6i

*CONTENT EUROPE (********): DBA – Oracle
• Installation and network configuration of Oracle8i database Server
• Auditing and Tuning Oracle for Oracle Application
• Migration of data from Oracle 8.05 to Oracle 8.1.5
• Creation of web-forms and reports with Oracle Webdb & Forms6i
• Analysis of the context cartridge engine (Intermedia) on Oracle 8 (8i)

*HUBWOO ( ******** ) : DBA – Oracle/SAP
• Administration, Tuning and Optimisation of Oracle database for SAP
• Installation, configuration of SAP B2B and Requisite Catalog 2.5/2.8
• Technical Support on Requisite and Jrun
• Developed of new backup and Tuning procedures

JUIN 1999 - DECEMBRE 1999
*Ares France : Software Engineer
• Application Development ARCOLRH(Human ressources, Payroll) with OracleForms
• Building of object components for ARCOLE-RH using C/C++ PL/SQL Oracle 7.3
• Implementation of OCI d’Oracle and conversion of Cprograms from Oracle 6.5 to 7.3

JUIN 1998 - DECEMBRE 1998
*Sociéte Générale Bank France : Analyste - Developer Vocational Training of 6 months
• System designed in the Accountancy department with Amcdesigner
• Analysis and Test in the context of year 2000, ISO 9000 and EURO
• Feasibility study on the implementation of a Financial DataWarehouse

JUIN 1997 - SEPTEMBRE 1997
*Institut National des Télécomunications France : Database Developer
• Application development on School Enrolment, Registration, NPS scheme
• Migration of DBASE IV data to Oracle 7 data and development of stored procedures

JUILLET 1993 - AOUT 1996
*Administrators & Consultants : Database Analyste – Developer
• Designed and development of « Insurance Medical Scheme » with Visual