Alain Duron Oracle Consulting Services
Professional Experience
Professional Experience <ul><li>EXPERT CONSULTANT ON ORACLE TECHNOLOGY </li></ul><ul><li>  </li></ul><ul><li>Design, exper...
Professional Experience <ul><li>EXPERT CONSULTANT ON ORACLE TECHNOLOGY </li></ul><ul><li>  </li></ul><ul><li>Definition a...
Professional Experience <ul><li>CONSULTANT ON OEM GRID CONTROL TECHNOLOGY   </li></ul><ul><li>Setup & configuration of Ora...
Professional Experience <ul><li>CONSULTANT ON OEM GRID CONTROL TECHNOLOGY   </li></ul><ul><li>Management, comparison, clon...
Professional Experience <ul><li>CONSULTANT ON ORACLE DATAGUARD TECHNOLOGY   </li></ul><ul><li>Definition of High Availabil...
Projects & Expertise
Projects & Expertise <ul><li>BNP Personal Finance – Oracle 8/9/10, 10gR2 RAC, Grid Control, Advanced Replication,…   </li...
Projects & Expertise <ul><li>CMA-CGM Systems : Projet MLR – architecture RAC 10g – AIX </li></ul><ul><li>RAC 10g on AIX /...
Projects & Expertise <ul><li>ORANGE Caraïbe – Oracle 10g R2, Real Application Cluster, OIM, grid Control </li></ul><ul><...
Projects & Expertises <ul><li>FRANCE TELECOM : ORANGE UK-SCOUT Project – Oracle 10g R2, Real Application Cluster – PeopleS...
Technical skills
Technical skills <ul><li>Databases </li></ul><ul><li>Oracle Database 8i, 9iR2, 10G, 11g </li></ul><ul><li>Oracle Real Appl...
Technical skills <ul><li>Operating systems </li></ul><ul><li>UNIX (SUN Solaris - HP/UX - AIX) </li></ul><ul><li>MS-WINDOWS...
Technical skills <ul><li>Languages </li></ul><ul><li>Java – C – C++ – SHELL </li></ul><ul><li>SQL – PL/SQL </li></ul><ul>...
Technical skills <ul><li>Monitoring tools </li></ul><ul><li>Oracle Database Control </li></ul><ul><li>Oracle Enterprise Ma...
of 17

Prez Aduron

Published on: Mar 4, 2016
Source: www.slideshare.net


Transcripts - Prez Aduron

  • 1. Alain Duron Oracle Consulting Services
  • 2. Professional Experience
  • 3. Professional Experience <ul><li>EXPERT CONSULTANT ON ORACLE TECHNOLOGY </li></ul><ul><li>  </li></ul><ul><li>Design, expertise and advices regarding Database architecture </li></ul><ul><li>Analysis and solution study to consolidate servers and Oracle databases </li></ul><ul><li>Database design and modeling </li></ul><ul><li>Audit and tuning of Oracle instances </li></ul><ul><li>Audit and performance improvement of SQL activity. </li></ul><ul><li>Benchmarks et Stress tests on Oracle databases </li></ul><ul><li>Definition and implementation of Backup/Restore procedures : SQL scripts and RMAN technology </li></ul>
  • 4. Professional Experience <ul><li>EXPERT CONSULTANT ON ORACLE TECHNOLOGY </li></ul><ul><li>  </li></ul><ul><li>Definition and implementation of High Availability : RAC, Dataguard </li></ul><ul><li>Monitoring and administration of go-live databases </li></ul><ul><li>SQL & PL/SQL development. </li></ul><ul><li>Migration of Oracle Environments </li></ul><ul><li>Expertise, skills transfer and Technical Support to Project teams and DBA </li></ul><ul><li>Implementation and admin of identity management (OIM) </li></ul>
  • 5. Professional Experience <ul><li>CONSULTANT ON OEM GRID CONTROL TECHNOLOGY   </li></ul><ul><li>Setup & configuration of Oracle Enterprise Manager Grid Control </li></ul><ul><li>Administration & resources’ monitoring with OEM Grid Control (Managing administrators, defining target groups, use of services...) </li></ul><ul><li>Deployment & management of High availability solution (Dataguard Physical & Logical) using Enterprise Manager </li></ul><ul><li>Deployment and configuration of pre-packaged solutions (Oracle Software) </li></ul>
  • 6. Professional Experience <ul><li>CONSULTANT ON OEM GRID CONTROL TECHNOLOGY   </li></ul><ul><li>Management, comparison, cloning of (Oracle Database, Oracle Home…) </li></ul><ul><li>Applying patches. </li></ul><ul><li>Defining and using EM Alerts </li></ul><ul><li>Setup of personalized reporting solution (availability & resource usage, storage evolution…) </li></ul><ul><li>Setup of Enterprise Manager jobs (backup management…) </li></ul>
  • 7. Professional Experience <ul><li>CONSULTANT ON ORACLE DATAGUARD TECHNOLOGY   </li></ul><ul><li>Definition of High Availability solution with Dataguard </li></ul><ul><li>Creation and configuration of standby sites </li></ul><ul><li>Setup of Switchover / Failover (Disaster Recovery) features </li></ul><ul><li>Administration of a Physical / Logical Standby database with Enterprise Manager Grid Control </li></ul><ul><li>Creation & management of Dataguard configuration with Dataguard Broker & SQL </li></ul><ul><li>Monitoring of the configuration with Dg Broker and/or SQL </li></ul><ul><li>Transfer & technical support to project teams on Dataguard architecture’s configuration and management. </li></ul>
  • 8. Projects & Expertise
  • 9. Projects & Expertise <ul><li>BNP Personal Finance – Oracle 8/9/10, 10gR2 RAC, Grid Control, Advanced Replication,…   </li></ul><ul><li>Architecture technical cases for ISAM->Oracle RAC migration </li></ul><ul><li>Technical test plan for Oracle 10gR2 RAC on AIX w/ ASM </li></ul><ul><li>Oracle 8i/9i/10g Tuning – Instances & SQL Query </li></ul><ul><li>Standardization documents for RAC Migration </li></ul><ul><li>Services definition for RAC </li></ul><ul><li>Oracle Dataguard Review – Performance and best practices </li></ul><ul><li>Grid Control Implementation (PoC, RAT, Siebel Agents) </li></ul><ul><li>Siebel Instances & SQL tunings – Siebel 8 on 10.1.0.5 </li></ul>
  • 10. Projects & Expertise <ul><li>CMA-CGM Systems : Projet MLR – architecture RAC 10g – AIX </li></ul><ul><li>RAC 10g on AIX / GPFS documentation, use cases </li></ul><ul><li>Installation / migration / exploitation documents for RAC </li></ul><ul><li>Impact study of RAC migration </li></ul><ul><li>RAC Clusterware Technical tests. </li></ul>
  • 11. Projects & Expertise <ul><li>ORANGE Caraïbe – Oracle 10g R2, Real Application Cluster, OIM, grid Control </li></ul><ul><li>ONAMES to OID migration (standardization of oracle network, 3 nodes configuration between Martinique – Guadeloupe (FWI), setup & Administration of ASR replication, administration scripts, documentation) </li></ul><ul><li>Migration of Grid Control (OMR / OMS) to 10.2.0.4 w/ multiple OMS (management of agents workload) </li></ul><ul><li>Upgrade 8i/9i to 10g & File-system data files to ASM/ASSM. (Specif & documentation, Migration scripts, Bench & migration tests, Upgrades of Datawarehouse & Requisitions databases) </li></ul><ul><li>Upgrades of databases to Oracle 10g / 11g. </li></ul><ul><li>Current admin tasks of production (Apps, Rac, Backups, Dataguard, cloning & environment refresh, Query optimization…) </li></ul>
  • 12. Projects & Expertises <ul><li>FRANCE TELECOM : ORANGE UK-SCOUT Project – Oracle 10g R2, Real Application Cluster – PeopleSoft </li></ul><ul><li>Setup of exploitation procedures and tasks for Oracle Real Application Cluster (Normal execution, identification and resolution of major issues on RAC, disaster recovery). </li></ul><ul><li>Help on backup / restore strategy. </li></ul><ul><li>Metrology and benchmarks, SQL activity tuning </li></ul><ul><li>Management of RAC database with Enterprise Manager Grid Control. </li></ul>
  • 13. Technical skills
  • 14. Technical skills <ul><li>Databases </li></ul><ul><li>Oracle Database 8i, 9iR2, 10G, 11g </li></ul><ul><li>Oracle Real Application Cluster </li></ul><ul><li>Oracle Dataguard – Physical & Logical Standby Database </li></ul><ul><li>RMAN backup / restore mechanisms </li></ul><ul><li>Tuning of SQL activity & performances </li></ul><ul><li>Oracle Application Express </li></ul><ul><li>SQL performance analyser </li></ul><ul><li>Other databases : ACCESS – MySQL – SQL Server </li></ul>
  • 15. Technical skills <ul><li>Operating systems </li></ul><ul><li>UNIX (SUN Solaris - HP/UX - AIX) </li></ul><ul><li>MS-WINDOWS (NT4 – Win2000 – Win2003) </li></ul><ul><li>LINUX – RedHat AS, Fedora, Debian </li></ul><ul><li>Virtualization (VMWare, Oracle VM…) </li></ul>
  • 16. Technical skills <ul><li>Languages </li></ul><ul><li>Java – C – C++ – SHELL </li></ul><ul><li>SQL – PL/SQL </li></ul><ul><li>Visual Basic – VB script – ASP </li></ul><ul><li>Java script – HTML – CGI – XML – PHP </li></ul><ul><li>UML </li></ul>
  • 17. Technical skills <ul><li>Monitoring tools </li></ul><ul><li>Oracle Database Control </li></ul><ul><li>Oracle Enterprise Manager V1 et V2 </li></ul><ul><li>Enterprise Manager Grid Control </li></ul><ul><li>SQL Developer </li></ul><ul><li>TOAD – Foglight </li></ul><ul><li>Methods </li></ul><ul><li>Oracle Unified Method (OUM) </li></ul><ul><ul><li>Certified, Lev. 1 / 2 </li></ul></ul><ul><li>Merise </li></ul>

Related Documents