Stan Wydooghe

Task Description: Deployment of 4 new X9-2 ExaCC Machines. Deployment of 2 X9-2 ZDLRA Appliances. Design & Development of a Generic PL/SQL Framework for IAM, Compliance, partition management, Compression, FGA, FGAC Design & Development of automated deployment procedures. Migration of existing Oracle Databases (19c + Exadata X8) to the new ExaCC infrastructure via RMAN and/or expdp Development of automated Reports regarding IAM enforcement and Segment Space Details Reorganisations of existing Databases using custom parallel PL/SQL to encrypt data at rest (TDE) and reclaim unused space. Create and Follow-up Oracle Service Requests Performance tuning of existing PL/SQL and SQL codebases. Support towards developers and application owners regarding all Oracle Technologies

Technology used: Oracle 19c, Oracle ExaData X8 / X9-2, Oracle ExaCC, OEM, ASM, Grid, OCI, PL/SQL, bash, RHEL, FGA, FGAC

Task Description: Design and Development of the Operational Data Store, Data Warehouse and multiple Data Marts Development of ETL procedures in PL/SQL for performant massive data loads Design and Development of ILM procedures for maintenance of the different Data Warehouses Performance tuning of complex parallel PL/SQL systems Design and Development of a high-volume metadata-driven data-flow framework between globally distributed Oracle Databases. Implementation and Roll-out of an Oracle Database Vault Setup for highly confidential data.

Technology used: Oracle 12c, Oracle 19c, Oracle ExaData X6-X8, Oracle Database Vault, PL/SQL, expdp, impdp, SQLplus, ksh, bash, RHEL, Oracle R Enterprise

Task Description: Implemented DB Cloning procedures in bash to clone (provision) multi-TB Databases as non-prod environments using NetApp cloning technology and Oracle Data Guard Setup of DataGuard Environments from running primary PROD DBs Developed automated Oracle Installation scripts to allow repeatable Oracle binaries installations together with the required PSUs, patches and OEM agents. OEM Configuration of new Oracle targets both via the UI and via the CLI.

Participated in the Oracle Workgroup to define a new Oracle Platform based on Netapp storage, VmWare and ESX (Virtualisation). Participated in daily monitoring, tuning and troubleshooting operations. Automated partition management procedures & statistics gathering procedures for complex multi-TB databases

Technology used: Oracle 11g, PL/SQL, RAC, ASM, Data-Guard, SQLplus, OEM, bash, Data Guard, NetApp Clustered OnTap 8.3, OPatch, RMAN