Benoit Dageville

 

OracleOracle

16 yrs 1 mo16 yrs 1 mo

• Architect - SQL Manageability GroupArchitect - SQL Manageability Group

  2002 - 2012 · 10 yrs2002 - 2012 · 10 yrsRedwood Shores, California, U.S.A.Redwood Shores, California, U.S.A.

  • • Architect in the Database Server Manageability group focusing on SQL optimization and execution. The server manageability group was created in 2002 to lower the TCO of Oracle databases by greatly simplifying their management. Led the design and implementation of the following features:
      
      • Automatic SQL Memory management
      • Automatic SQL Tuning advisor
      • SQL Performance Analyzer (SPA)
      • Real-time SQL monitoring
      • Database Active Report Framework
      • Fault Diagnosability Infrastructure
      
      In addition to focusing on core database manageability features, lead architect for the redesign of Oracle Enterprise Manager Cloud Control (EM CC) 12c. EM CC is the product developed by Oracle which manages all software and hardware assets of an IT organization: storage, operating systems, database, cloud, virtualization, middleware, application, etc. EM CC is a J2EE application with multiple server instances and many deployed agent programs responsible to directly interact with all managed assets. Main accomplishments are:
      
      • Lead architect for the re-design of Enterprise Manager
      • Consulting role for our virtualization and cloud management solutionArchitect in the Database Server Manageability group focusing on SQL optimization and execution. The server manageability group was created in 2002 to lower the TCO of Oracle databases by greatly simplifying their management. Led the design and implementation of the following features: • Automatic SQL Memory management • Automatic SQL Tuning advisor • SQL Performance Analyzer (SPA) • Real-time SQL monitoring • Database Active Report Framework • Fault Diagnosability Infrastructure In addition to focusing on core database manageability features, lead architect for the redesign of Oracle Enterprise Manager Cloud Control (EM CC) 12c. EM CC is the product developed by Oracle which manages all software and hardware assets of an IT organization: storage, operating systems, database, cloud, virtualization, middleware, application, etc. EM CC is a J2EE application with multiple server instances and many deployed agent programs responsible to directly interact with all managed assets. Main accomplishments are: • Lead architect for the re-design of Enterprise Manager • Consulting role for our virtualization and cloud management solution
• Consulting Member Of Technical Staff – Parallel SQL Execution GroupConsulting Member Of Technical Staff – Parallel SQL Execution Group

  Jan 1996 - Jan 2002 · 6 yrs 1 moJan 1996 - Jan 2002 · 6 yrs 1 moRedwood Shored, California, U.S.A.Redwood Shored, California, U.S.A.

  • • Lead architect and developer in the Oracle database parallel execution group, which is responsible for parallelizing SQL statements (queries, DML and DDL) and executes them over a RAC cluster. Major accomplishments in this area include:
      
      • Redesign and implement new parallel granule management
      • Introduce partition-based parallelism: partition-wise joins and aggregations, intra-partition parallelism, advanced pruning techniques, etc.
      • Self-tuning the degree of parallelism in multi-user environments
      • Define new Intra SQL parallelization model for parallel query
      • Database as an ETL engine: lead architect for defining many features aimed at transforming the database into a scalable ETL engine
      • Large scale data warehouse benchmarks: involved in many high-scale data warehouse benchmarks like TPC-H or POC benchmarks