Patrick Van Der Sande Email & Phone Number

Antwerp, Be

Brussels Area, Belgium

Senior DBA/Architect :All Oracle Database system/infrastructure related projectsMonitoring/BackupsRedhat System EngineerNetapp administrationFlexpod architecture / administrationVMWare administrationArchitectural design/infrastructure/procedures/standards/best practices/performance/monitoring

managing director of ANDES CONSULTING BVBA

Managing Director of ANDES Consulting BVBATasks :Run a daily consultancy business comprising of following services :1) Oracle DBA consultancy2) Website development3) Software Development4) Pychological assistance5) Hosting of websitesOracle Partner since 1999.Internal projects :Oracle Real Application Clusters lab. (SLES10 & 10gr2) -> finishedOracle Grid Control -> finishedOracle Dataguard running in RAC mode -->… Show more Managing Director of ANDES Consulting BVBATasks :Run a daily consultancy business comprising of following services :1) Oracle DBA consultancy2) Website development3) Software Development4) Pychological assistance5) Hosting of websitesOracle Partner since 1999.Internal projects :Oracle Real Application Clusters lab. (SLES10 & 10gr2) -> finishedOracle Grid Control -> finishedOracle Dataguard running in RAC mode --> finishedTesting Oracle Real Application Cluster 10gr2 (10.2.0.3.0) --> finishedOracle Real Application Clusters lab (OEL5 & 11G) --> finishedOracle RAC website --> finished Show less

Mechelen

Responsible for the Oracle Infrastructure.

Upgrade databases to 10.2.0.5Oracle Fusion Middleware ( Identity Management)Support Oracle RAC and DataguardDaily DBA supportOracle 11.2.0.2 new features testingUpgrade databases to 11.2.0.2Rolling Upgrade RACPerformance Tuning

Oracle DBA ( Unix Sun Solaris & HP Unix)My tasks :DBA Support DR site. (Dataguard , standby )DBA Support for all Oracle products

Oracle DBA activities:� DB software installation, upgrade, patching� Problem prevention, detection and correction (including performance tuning)� DB recovery if needed� Assisting J&J developers in deploying Oracle-based applications� Communicating with Oracle Corp., J&J developers, end-users and management� Documentation as required by GxP (Installation Qualification, change management, ...)Oracle standby implementation… Show more Oracle DBA activities:� DB software installation, upgrade, patching� Problem prevention, detection and correction (including performance tuning)� DB recovery if needed� Assisting J&J developers in deploying Oracle-based applications� Communicating with Oracle Corp., J&J developers, end-users and management� Documentation as required by GxP (Installation Qualification, change management, ...)Oracle standby implementation (DR site, primary in US)Support for Janssen PharmaceuticaHA with RAC and dataguard Show less

Oracle DBA ( Unix Sun Solaris & HP Unix with NETAPPS Filers )My tasks :Installations 9.2.,8.1.7 databasesUpgrades to 9.2.0.5.0Installation of patches and bug fixesOID replication setupTuning databases and applicationsMonitoring (OEM, scripts, statspack, HP Openview, Sitescope)Defragmentation and tablespace reorganizationsSetup OEMBackup with RMAN and Omniback : follow-up and problem solvingSupport for Siebel, SAP and Lawson application… Show more Oracle DBA ( Unix Sun Solaris & HP Unix with NETAPPS Filers )My tasks :Installations 9.2.,8.1.7 databasesUpgrades to 9.2.0.5.0Installation of patches and bug fixesOID replication setupTuning databases and applicationsMonitoring (OEM, scripts, statspack, HP Openview, Sitescope)Defragmentation and tablespace reorganizationsSetup OEMBackup with RMAN and Omniback : follow-up and problem solvingSupport for Siebel, SAP and Lawson application databasesSupport for all Oracle productsNetApps Filer maintenance Show less

Application and Server DBA (Unix Solaris 8 & 9)My tasks :Testing and evaluating SUN Fire 6800Advice given on RAID config and database config on SUN Fire 6800Installations 9.2.0 databaseInstallation of patches and bug fixes on all Oracle productsTuning of all databases, OS’s, network and applications (close collaboration with development teams) Backup,recovery and cloning of databases (8.1.7 & 9.2.0)Disaster recovery testingSetup backup/recovery with… Show more Application and Server DBA (Unix Solaris 8 & 9)My tasks :Testing and evaluating SUN Fire 6800Advice given on RAID config and database config on SUN Fire 6800Installations 9.2.0 databaseInstallation of patches and bug fixes on all Oracle productsTuning of all databases, OS’s, network and applications (close collaboration with development teams) Backup,recovery and cloning of databases (8.1.7 & 9.2.0)Disaster recovery testingSetup backup/recovery with NetbackupTest SUN tape robot (L180)Monitoring (statspack,OEM,scripts)Oracle Portal installations,support,bug fixing,upgradesOracle Portal development supportSupport for ApacheAdvanced SecurityOID setup and creation of OID procedures and guidelinesGeneral support for all Oracle Products Show less

Application and Server DBA (Unix environment)Schema management (weekend releases)Implement and apply database standards and application standardsEvaluate Third party products (f.e. Peoplesoft, Siebel, SAP)Evalutate Third party database products (f.e. Precise, Quest )Reorganization of databases (online & offline)SLA implementation and follow upTechnical activities9i advanced queueingSupport Oracle E-business (Oracle Applications)Develop generic Unix… Show more Application and Server DBA (Unix environment)Schema management (weekend releases)Implement and apply database standards and application standardsEvaluate Third party products (f.e. Peoplesoft, Siebel, SAP)Evalutate Third party database products (f.e. Precise, Quest )Reorganization of databases (online & offline)SLA implementation and follow upTechnical activities9i advanced queueingSupport Oracle E-business (Oracle Applications)Develop generic Unix scripts (executed on all environments)Upgrades, backup and recovery proceduresTuning & performance monitoring using Precise I3,statspack and own written utilities for database, OS and networkStorage management & advising on organizing database storageHelpdesk Oracle Show less

Client : Euronext (BXS) (CIK)Application and Server DBA ( DEC OpenVms,NT,DEC Unix environment)My tasks were :Installation Oracle 7.3.4 on OpenVMSMigration Oracle 7.3.4 -> Oracle 8Schema management (releases, implementation new objects,advice storage …)Migrations of databases, designer 2000, application serverSLA procedures and implementationInstallation Application Server on DGUXTuning and monitoring of databases, OS, networkUpgrades of database (patches… Show more Client : Euronext (BXS) (CIK)Application and Server DBA ( DEC OpenVms,NT,DEC Unix environment)My tasks were :Installation Oracle 7.3.4 on OpenVMSMigration Oracle 7.3.4 -> Oracle 8Schema management (releases, implementation new objects,advice storage …)Migrations of databases, designer 2000, application serverSLA procedures and implementationInstallation Application Server on DGUXTuning and monitoring of databases, OS, networkUpgrades of database (patches, bug fixes)Implement backup and recovery strategy and proceduresAssist and support development teams (designer, PL/SQL …)Helpdesk Oracle Show less

Application and Server DBA (HP UX and NCR Unix environment)Tasks :Schema management, snapshot problematics, migrationsUpgrades, creation of databases, backup and recoveryHelpdesk,Testing of new or existing DBA Tools

At ICI I worked as Oracle DBA and Developer.I did the daily DBA work and worked very closely with the oracle development team to do :Maintenance of Profit Book applicationDocumentation proceduresSystem TestingSecurity user accessDesign modules and coding

Consultant Advanced Technologies :Responsible of the installations on Unix,Netware,Windows NT Installation Oracle RDBMS V6,V7Installation SQL*NET V1,V2Installations Designer 2000, Developer 2000Configuration SQL*NET V1,V2Upgrades V6 -> V7,Migrations V6 -> V7Creation of databases,Backup and recovery proceduresTuning of databasesDBA Assistance for Levi StraussDevelopment of Sales Application for HENKEL (Power Objects)DBA and maintenance… Show more Consultant Advanced Technologies :Responsible of the installations on Unix,Netware,Windows NT Installation Oracle RDBMS V6,V7Installation SQL*NET V1,V2Installations Designer 2000, Developer 2000Configuration SQL*NET V1,V2Upgrades V6 -> V7,Migrations V6 -> V7Creation of databases,Backup and recovery proceduresTuning of databasesDBA Assistance for Levi StraussDevelopment of Sales Application for HENKEL (Power Objects)DBA and maintenance application at ICI Show less