Menu

Frédéric GROUSSELLE

Issy-les-Moulineaux

En résumé

Expert in the management of Oracle's and SQLServer’s Database product in various environments (Aeronautic, Retail, Pharmaceutical) running on different platforms (UNIX, Linux, Windows).
Comprehensive knowledge of Database Architecture / Implementation, Database design and Data Models.
Architect for Database standards definition, new functionalities implementation, migrations, upgrades, consolidations and design high availability solutions according to business needs.
A self-motivated, responsible, and reliable team player with strong commitment to quality and customer service.

Mes compétences :
Oracle Database
Oracle 8i-11g
Microsoft SQL Server
Oracle Goldengate
Oracle 11g
Oracle RAC
Linux
Unix shell Script
ORACLE 8.0
Oracle 10g
ORACLE 9i
Oracle Streams
Oracle Dataguard
RMAN
Unix
Oracle Advanced Security
Database
Oracle
DBA
Freelance

Entreprises

  • Sogeti - DBA for Airbus France (Freelance)

    Issy-les-Moulineaux 2011 - maintenant INIT : Competence Center DBMS (CoC INIT Database)
    - Design Airbus standard architecture for Oracle database
    - Design Airbus Database administration procedures and standards definition
    - Oracle technical expertise
    - Design and validate technical architecture (Database replication, High availability, Cluster …)
    - Technical support level 3 (last level)
    - Writing technical documentation (Installation guide / Migration guide / Operational guide, Backup &
    Recovery …)
    - Industrialization of Oracle administrative tasks (kernel installation, Database creation & remove …)
    - Auditing and database tuning
    - Design security rules with 11g Hardening validation
    - Technologies Implemented: Dataguard, RAC, Golden Gate, Streams, Oracle Text, Forms

    Environment : Unix (AIX, HP-UX, SunOS, Linux), Oracle (8i, 9i, 10g, 11g)

    Workshops : Golden Gate, 11g New Features, Grid Infrastructure ClusterWare 11g, Real Application
    Cluster RAC 11g, Real Application Testing RAT 11g, Security and Encryption, Patching Strategy
  • Infotel - DBA for Airbus France (Freelance)

    Neuilly-sur-Seine 2010 - 2011 INIT : Competence Center DBMS (CoC INIT Database)
    - Oracle technical expertise
    - Validation of technical architecture
    - Technical support level 3
    - Writing technical documentation (installation guide / operation / migration …)
    - Audit and database tuning
    - Technology: Dataguard, RAC, Golden Gate
    Environment : Unix (AIX, HP-UX, SunOS), Oracle (8i, 9i, 10g, 11g)

    Workshop : Golden Gate, ClusterWare 11g, RAC 11g

    INID : SAFE Center Integration:
    - Responsible for database administration for the Integration department
    - Technical support levels 1 to 3

    Environment : Unix (AIX, HP-UX, SunOS), Oracle (8i, 9i, 10g, 11g)
  • Sogeti High Tech - DBA for Airbus France

    TOULOUSE 2008 - 2009 OADI : SAFE Center Integration :
    Responsible for database administration for the Integration department in Unix environments (AIX,
    HP-UX, SunOS):
    - Management of ~120 databases from Gigabytes to several Terabytes
    - Capacity planning for databases growth
    - Implementation of Oracle Grid Control
    - Databases performance monitoring
    - Lob segment and I/O tuning
    - Implementation of Backup strategy (RMAN, exp, expdp, cold-backup, hot-backup, Business Copy)
    - Implementation of Oracle Real Application Clusters (RAC)
    - Design of database synchronization procedures

    Training :
    « Administration Oracle 10g » 3 days : provided by ADHARA
    « Oracle 10g New Features » 5 days : provided by Oracle University
  • Airbus -  DBA for Airbus France

    Blagnac 2008 - maintenant
  • Cegedim / Dendrite - System Administrator / DBA Oracle

    2001 - 2007 During the last 6 years for Dendrite France, I was responsible for the production environments for several large retail clients such as Danone, Groupe Carrefour, Mattel, Eugène Perma and pharmaceutical laboratories such as UCB, Aventis and Novartis. In this position, I was able to develop my abilities and knowledge in a variety of different disciplines.

    Oracle Database administration :
    - Creation, administration and migration of Oracle databases.
    - Design Oracle database backup procedures: Hot backup, Export.
    - Oracle database maintenance, optimization, diagnostic and solutions development

    Oracle Development :
    - SQL query tuning
    - Application development in PHP / HTML / with Oracle / MySql / SqlAnywhere: Knowledge base + Reporting, Statistics on client’s sales force activities.
    - Application development for a client administration tool in Oracle and PHP / HTML
    - GUI development based on data from client data sources (SAP, AS400) to Oracle Dendrite data sources. (Such as sales force expense information)

    Others :
    - Module development for the Dendrite software package, evolutions and corrective maintenance at both Backend and Frontend levels
    - Remote maintenance of dedicated client servers (TSE, Citrix, PCA, DW)
    - Batch process automation / Perl / VB
    - Multidimensional table analysis development using QlikApp (OLAP engine)
    - Frequent client contact, needs analysis, solution proposals and estimates

Formations

Pas de formation renseignée

Réseau

Annuaire des membres :