CURRICULUM VITAE

Benny Derous

Senior Oracle Database Administrator

Freelance Consultant

Personalia
Nationality / Belgian
Gender / Male
Year of Birth / 1971
Contact /
Place / Brugge
Languages
Very Good / Not too bad / Could be worse
Dutch / X
English / X
French / X
German / X
Education
1989 – 1995 / Master’s Degree in Corporate and Financial Sciences
@EHSAL Brussels
Speciality : Corporate Management
Knowledge Summary
Specialisations / Oracle7
Oracle8
Oracle8i
Oracle9i
Oracle10gEnterprise Edition
Programming Languages / PL/SQL
Unix Shell Scripting
Operating Systems / Some light administration on:
IBM AIX
Solaris
HP-UX
Oracle / (DataWarehouse) Database Administration
Storage Management
Capacity Planning
Backup/Recovery - RMAN
Oracle DataGuard – Standby Databases
Oracle Replication
Oracle Partitioning, Query Rewrite, Materialized Views
Database Wide Tuning
Extensive Query tuning
Developer support
Security Planning & Implementation
Oracle Application Server
Other / TOAD, SQL Navigator, SQL Developer
Oracle Enterprise Manager (Grid Control)
Platinum TS*Reorg
Compuware Ecotools
Main Experiences
KBC
Period / dec 2006 – now
Project / Design and Advice
Function / Oracle Performance Specialist
Tasks /
  • Database Administration on Oracle9i & 10g
  • Change Management
  • Security Planning & Implementation
  • Database tuning
  • SQL Tuning
  • Application Performance tuning
  • Performance reporting
  • Baseline
  • Partitioning
  • Pro-active monitoring

Technical Description
OS / HP Sun Fire & Sun Solaris
Tools & Technologies / InDepth (Precise)
Quest Toad Expert Edition & Lab Tuning
Oracle Enterprise Manager Grid Control
Databases / Oracle EE 9i & 10g
Volvo IT Belgium
Period / sept 2000 – sept 2006
Project / Business Intelligence
Function / Oracle DataWarehouse DBA
Tasks /
  • Data Warehouse Administration on Oracle9i
  • Migration of Oracle databases
  • Capacity Planning
  • Storage Management on Oracle
  • Security Planning & Implementation
  • Database tuning
  • Performance tuning complex queries with “Query rewrite” and “Materialized Views”
  • Partitioning, Aggregates and Transportable Tablespaces
  • Pro-active monitoring
  • SOX, ISO9001
  • Light Unix Administration
  • Backup/Recovery strategy and automation

Technical Description
OS / IBM LPAR AIX 5.3 (HACMP)
IBM RS6000 AIX 4.3.3
Microsoft Windows Server (2000 – 2003)
Tools & Technologies / Business Objects
Oracle Enterprise Manager
Oracle Grid Control
Oracle Application Server
Databases / Oracle EE 8i, 9i & 10g
The Campus (Cronos)
Period / 2000 –now
Project / Training at irregular intervals
Function / Trainer
Tasks / Courses given :
  • OracleBasic Database Administration (8i,9i & 10g)
  • Oracle Advanced Database Administration (9i)
  • Oracle Backup & Recovery (8i)
  • Oracle8i New Features
  • Oracle9i New Features

More info /
Vierdaagse van de IJzer (ministery of defense)
Period / 1 week yearly extensively + random work during year
next to main job at Volvo IT
Project / Sponsership
Function / All IT related projects
Tasks /
  • Build application in PL/SQL for enrollment of hikers
  • Automate payments from bank to database
  • Scanning and tracking of hikers
  • Datacomm via GPRS

Technical Description
OS / Solaris & Windows
Tools & Technologies / Mod/SQL
PL/SQL
Databases / Application Server / Oracle 10g
Oracle DataGuard
More info /
KBC
Period / Oct 2003
Project / Replication
Function / Oracle Database Administrator
Tasks / Transfer data between databases
Technical Description
OS / Sun Solaris
Databases / Oracle 8i
Different Companies
Period / 2000-2006 next to main job at Volvo IT
Companies / VTM, Pinguin, SITEL, Electrabel, ADMB
Project / Different short-time projects (1 day – 1 week)
Function / Oracle Database Administrator
Tasks /
  • Database upgrade (Pinguin)
  • Performance problem (Electrabel, ADMB)
  • Database migration (VTM-
  • Standby on call DBA (Sitel)

Saudi Telecom Company (Saudi Arabia)
Period / May 2002 in Riyadh
Project / Securing all databases
Function / Oracle Security Specialist
Tasks /
  • Security Implemention on Oracle databases
  • Stripping Oracle databases

Technical Description
OS / Compaq with Windows NT
Databases / Oracle 8i
OracleWorld 2002 Copenhagen (Denmark)
Period / 24-28 June 2002
Project / Conference
Function / Speaker at conference
Tasks / Presentation of my paper :
“Oracle9i Raises Data Warehousing to the Next Level”
More info /
Monsanto
Period / July 2000
Project / Maintain all Oracle databases + Unix systems
Function / UX sysadmin + Oracle DBA
Tasks /
  • Database Administration
  • Unix Administration
  • Backup – Recovery
  • Developer Support

Technical Description
OS / HP - UX
Tools & Technologies / Omniback
Databases / Oracle7, 8 and 8i
Creyf’s Interim
Period / May 2000 – June 2000
Project / SLA setup
Function / Setup techniques to maintain SLA
Tasks /
  • Defining of Service Level Agreements for outsourcing
  • Minor Database Administration
  • Storage Management on Oracle and Unix
  • Setting up of Capacity Planning

Technical Description
OS / IBM RS/6000 AIX 4.3.2
Databases / Application Server / Oracle7 & 8
Oracle Application Server
Oracle Context/Intermedia
OracleEnterprise Manager
Roularta Media Group
Period / 1998 – 2000
Project / Primary DBA
Function / All Oracle related
Tasks /
  • Database Administration on Oracle7
  • Storage Management on Oracle
  • Capacity Planning
  • Backup/Recovery procedure
  • Tuning of RDBMS
  • Security Planning & Implementation
  • Research/implementing Oracle8i Data Warehouse features

Technical Description
OS / IBM RS/6000 AIX 4.3.3
Tools & Technologies / Platinum – TS*Reorg
Compuware - Ecotools
Databases / Application Server / Oracle7
Oracle WebServer
Oracle Enterprise Manager

1

23/10/2018CV – Benny Derous