Kai P. - Oracle Project Management and DBA

Go to Website

Munich, Germany

Experience

Aug 2023 - Present

2 years 1 month

Basel, Switzerland

Oracle Project Management and DBA

Scope Solutions AG

Installation, maintenance and regular upgrades of the DB systems with 19x. OPatch, RU 19.27, RHEL 8x, SLES 15.x, also Windows.
DBA for DACH and Europe customers, Prod, load test environments Konrad Adenauer etc and others in CDB.
Workflows via Confluence.
Support in operations for customers SR via Metalink

Apr 2022 - Oct 2023

1 year 7 months

Nuremberg, Germany

Oracle Operations Support with TEC4 Central CM

Bundesagentur für Arbeit

Operation and regular upgrades of the DB systems with 19x. SLES 15.x.
DBA for about 2100 PDBs on RAC and EXADATA, Prod, Int, LTU and others in CDB.
CM via ARS Remedy.
Workflows via JIRA and Confluence.
Operational support for SR via Metalink.

Sep 2021 - Mar 2022

7 months

Wiesbaden, Germany

Oracle Operations, Architecture for the 2022 Survey

Statistisches Bundesamt

Consolidation of data into a central Oracle 19x DB system.
Creating IMP/EXP concepts for the central DB structure, metrics and performance architecture for reporting.
Training STBA staff in Oracle performance and DBA topics.

Mar 2019 - Dec 2021

2 years 10 months

Landshut, Germany

Oracle Operations, Architecture for AIX LPAR and Oracle DBA

E.ON Digital Technology

Creating patch concepts, documentation (SHB).
Installation of AIX 7.x, Oracle (12, 19c) database administration, updates and operations.
LPAR administration including VIO server, software distribution on AIX with NIM server.
Performance monitoring and monitoring.
Backups with TSM/IBM Spectrum Protect (ISP), including backup and restore with RMAN.
Installing EM13c with WebLogic Server 12.1x.
Training EDT staff.

Sep 2018 - Feb 2019

6 months

Germany

Oracle DB Operations – Migrations to 18c/12c with Various Cloud Architectures

AXA

Planning, methodology and execution of the DB migration to the IBM blueprint (Spectrum Private) and AWS (Amazon Public) cloud.
Creating Oracle DBs in the cloud with SLES Terraform templates, cloud KPI etc.

Jul 2016 - Sep 2018

2 years 3 months

Germany

Oracle DB migrations 11g/12c with various architectures, project lead

RWE/SuewAG/syna

Design, planning, methodology and execution of DB migration from 11g to Oracle 12c with platform and architecture changes.
Windows 2012, 2016 and release upgrades: EMGC to EM12c CC, setup of 12c EM via WebLogic Server 10.3x for monitoring.
Used migration methods: DG, TTS, IMPDP/EXPDP, RMAN after application analysis and prerequisites.
Performance tuning with/for Oracle 11g and 12c.

Jan 2016 - Mar 2017

1 year 3 months

Munich, Germany

Material Support System (MSS) for international engine customers, Business Analyst and Requirements Engineer

MTU Aero Engines

Responsible for operation and development of Oracle DBs 11g and 12c and applications/workflows, including interfaces (BAPI) to SAP.
Design and management of customization and development of APPS modules in Visual Basic Studio (VBS) and PL/SQL via Subversion (SVN) in aircraft engine manufacturing & logistics.

Apr 2012 - Aug 2015

3 years 5 months

Munich, Germany

Oracle operations, architect and DBA, project manager

UBIS (HVB) Deutschland

Oracle-based operation and migration of MIB trading platforms for MUREX (tuning, PL/SQL), Sophis, etc., with various Oracle architectures.
Oracle security 11gR2 (Wallet, TBS), HA (RAC, Data Guard), DBVault, Oracle GoldenGate 11g, DWH.
Project management for DWH Oracle migration from 10g to 11g R2, release upgrade: OWB 11gR2 to ODI 12c and Oracle RDBMS 12c R12.x.
OS: RedHat 5.x, AIX 6.x, 7.x, and Solaris 10.

Mar 2012 - May 2012

3 months

Munich, Germany

Oracle specialist and consultant for data migration/DWH

Oracle Deutschland GmbH

Consulting on Discoverer and OWB 10/11 for clients including Volkswagen AG, GE Money Bank, WeKa, KSB, Swisscom, British Telecom (BT).
Migration of an existing Discoverer EUL4 environment to EUL5i (10g) and optimization of the 10g DB for new requirements.
Implementation of Data Guard 10g, web applications and DB analysis, performance and tuning for clients’ new environments.
OS: Solaris 10 and Linux 10.

Sep 2010 - Mar 2012

1 year 7 months

Munich, Germany

Oracle DB and HPUX to Linux Migration

WWK Deutschland a.G

Architecture, planning/operation concept and migration (including provisioning via EMGC11g) of 104 DBs (SI, ADG and RAC on 11.2.0.2) from HPUX cluster to Linux RedHat 5.x.
SI with Veritas 5.x cluster and RAC.
DBs in 2-node RAC 11.2.0.2; 4 DBs in Data Guard 11g.
Project management for OWB–Oracle migration and configuration of the WWK DWHs (>1TB) for operation with 11g R2x (tuning, PL/SQL, mappings, metadata), WebLogic.

Mar 2010 - Sep 2010

7 months

Stuttgart, Germany

Technical Project Manager DWH for Poland

Allianz Germany

AML to populate a DWH via OWB11i with ETL files from various European sites, currently: PL, IRL, F.
BA and RM (application management) for verifying implemented modules via ETL process for automated LOAD (OWB, mappings, PL/SQL, SQL*Loader) and data encryption using Oracle advanced TDE.
Products used: OBI 11g, Oracle DB 11i with DVA (Database Vault), OWB 11i rel1, SQL*Loader, DataModuler, Linux 10, etc.

Nov 2007 - Apr 2008

6 months

Munich, Germany

Design and implementation of an Oracle DB migration

BT Germany

Migration of DBs from 8i to 10g rel2 in a Solaris cluster.
Creating proposals, project plan, schedule, etc. for the client.

Aug 2007 - Feb 2010

2 years 7 months

Taufkirchen, Germany

Oracle specialist and DBA for APPS 11i

NETMA

Responsible for operating Oracle DBs (9 and 10g), APPS 11.5.10, and NETMA applications.
Designing, managing customization, and development of APPS modules in PL/SQL via Subversion (SVN) in aircraft manufacturing as well as flight operations and maintenance.
Oracle products: APPS 11i, OC4J, DB and EM 10g rel2, OAS 10, TOAD, etc.
Platforms and clusters: IBM AIX 5x and SLES9.
Oracle RAC 10 rel3, Oracle DB 11g rel2 on Windows, HP-UX, Linux.
Conducting migration tests.

Feb 2007 - Aug 2007

7 months

Nuremberg, Germany

Oracle DWH specialist

Itellium (KQ)

Responsible for design and analysis (master data and logistics) to build a DWH in mail order.
Oracle tools: Designer 9i, OWB 10g, DB 10g rel2, ETL, PL/SQL, external table.
Data volume estimated at 5TB, etc.

Oct 2006 - Feb 2007

5 months

Munich, Germany

Oracle specialist and consultant for data migration/DWH

Oracle Germany GmbH

Consulting with Discoverer and OWB 10/11, among others, for clients like Volkswagen AG, GE Money Bank, WeKa, KSB, Swisscom, British Telecom (BT).
Migrating an existing Discoverer EUL4 environment to EUL5i (10g) and optimizing the 10g DB for the new requirements.
Implementing Data Guard 10g, web application and DB analysis, performance, and tuning for the clients' new environments.
OS: Solaris 10 and Linux 10.

Jul 2006 - Oct 2006

4 months

Hamburg, Germany

Oracle Specialist and Consultant for Data Migration/DWH

HaSpa

Setup of an Oracle 10g rel2 environment for the banking applications WP, SAMBa, KBP and BO on Solaris 10.
Data import from an OS390 DB2 database (so-called LOADS).
Architecture, sizing, tuning and performance, as well as preparing the data for Oracle (with OWB 10g) according to DWH principles and handing it over to the client Hamburger Sparkasse (HaSpa).

Feb 2005 - Jun 2006

1 year 5 months

Ingolstadt, Germany

Oracle Consultant and DBA

AUDI

Operation, installation and maintenance of Oracle 9.2.0.6, 10g and IAS 10g, archiving (Oracle RLS), RMAN.
Oracle HTMLDB 1.6.x, Veritas Cluster 2.0, Solaris 8 and 9, and AIX 5.3 with HACMP, BMC Patrol, SC, Peregrine.
Oracle database cloning, migration from 9i to 10g; about 200 systems up to 4.5TB.

Nov 2003 - Jan 2005

1 year 3 months

Kreuzlingen, Switzerland

Project Manager

Photocolor

Oracle Apps 11.5.7-9 including CRM/Telesales: on Oracle 9i Rel2, Solaris 8 and HP-UX 11.11 SAN.
Project manager for implementation, configuration, technical support and acceptance of the ERP-Oracle project, including MIS with OWB, Mercury TestDirector.
Project completion through outsourcing (BPO) of the system platform.
The system manages the processes of an online photo mail-order business with 3 interfaces and a web portal (Digital Ordering).
Data volume (project): 2TB.
Reporting directly to the CEO and the management of Photocolor Kreuzlingen AG.

May 2003 - Oct 2003

6 months

Duisburg, Germany

Oracle Consultant

ZPD (Central Police Services) NRW

Oracle on HP Superdome 9000/800/SD32000 OS 11.11 with Oracle DB 8.1.7.4 and Oracle IAS.
Integration of the internal ORA-Forms application IGWEB across North Rhine-Westphalia for the police.
Consulting, PL/SQL training, project planning with architecture.
Data volume growing from 1.2 to 2.5 TB during the project, designed for 5 TB to connect all PI stations in NRW.

Nov 2002 - May 2003

7 months

Munich, Germany

Project Manager

Messe München GmbH (MMG)

MIS solution (with OWB, Discoverer 4i) on Oracle 11i (11.5.8), Balanced Scorecard (BSC) on Windows 2000 Advanced Server with Symmetrix SAN, and Oracle DB 9i rel2 with RAC 9iR3.
DWH: with OWB, ETL and Discoverer 4i, architecture and design, integration, troubleshooting, consulting.
Data volume 1.5 - 2 TB.
Reporting to the IT director of MMG.

Oct 2002 - Dec 2002

3 months

Geneva, Switzerland

Oracle DBA and Consultant

Aria SA Integration

Oracle 8.1.7.4 and 9i DBA and consultant at client Choppard.
Merged the Stuttgart and Geneva databases using Oracle 9i replication.

Jan 2002 - Oct 2002

10 months

Munich, Germany

Oracle DBA and Project Manager

Bertelsmann / ORT-Studios

Oracle DBA (including 9i) and integration on various platforms (Solaris 7, 8; Windows 2000; etc.) for the production system DMS 1.6.x from Quark.
DB replication, troubleshooting, and backups, including Veritas 3.2.

Oct 2001 - Present

23 years 11 months

Luxembourg

DBA, Oracle DWH consulting with various architectures, project management, IT audit, revision

KaPe Munich

Projects for multiple clients via SCOPE AG (e.g. Burda (HBM), DeKa, e.ON KM, Otto Group, Augsburger Allgemeine).
Planning, analysis, and performance of DWH/CRM platform for campaign management.
Business analysis.
High availability with RAC 12c using OVM or Red Hat 6.x, AIX 7.x.
Solaris 11 with hardware analysis.
Methods used: OBIEE, Data Guard, Transportable Tablespaces 12c and 11g, RMAN prerequisites for the application.
Performance tuning for Oracle 11g and 12c.

Oct 2001 - Dec 2001

3 months

Munich, Germany

Oracle consultant and DBA

Bayerische Landesbank

DBA support for 8x and 8i in production environments.
Created a migration structure from lower Oracle versions to 8.1.7 Patch 2.

Mar 2000 - Oct 2001

1 year 8 months

Munich, Germany

Project manager, consultant, Oracle DBA

Datastream System GmbH

Integration and technical sales of the MP5 product for European customers, i.e. creating Oracle DBs 8i and AS9i on various platforms and providing the necessary technical advice. Here, Oracle WEBSRV, WTS, and client/server are available to the customer.
General: DBA activities, performance tuning, ETL (SQL*Loader), troubleshooting according to service agreements.
Projects: Oracle Web 9i AS integration at Migros, Haelg & Winterthur (all CH), SEW in Munich, DVUMatErh for the Bundeswehr in BNA and Aachen. Other Oracle architectures for BMW worldwide, LGM; Flextronics (Austria, Hungary, Poland), several small customer projects in Central Europe.

Apr 1999 - Feb 2000

11 months

Munich, Germany

NT Specialist, Oracle DBA

TDS Consulting GmbH

Migration projects / coexistence with Lotus Notes R4x/5 from existing systems.
NT specialist (topology, analysis), Windows Terminal Server (WTS), Citrix MetaFrame.
MS Backoffice: MS Exchange 5.5 SP2, SMS 2.0, MS Proxy Server.
Oracle DBA for 7.3.4 and 8.0.5 environments.
Projects: Siemens AG Berlin, Leonberger BauSpK, several small customer projects.

Jun 1998 - Mar 1999

10 months

Munich, Germany

Application Specialist

VIAG Interkom GmbH & Co.

MS Backoffice: MS Exchange 5.5 design & implementation, admin & network technology/security.
Oracle 7.3.2, 7.3.3 and 8.x.
Oracle for Windows NT, UNIX HP-UX.

Mar 1997 - Jun 1998

1 year 4 months

Taufkirchen, Germany

Integration of CADPS with AECMA 2000M and EDI

Syseca GmbH Germany

For NETMA in cooperation with GB, I, E for EFA 2000 and Tornado.
Created an Order Administration (OA) environment for transactions with standard AECMA 2000M (including documentation for the customer) in an Oracle 7.x and Forms 4.x environment.
Oracle Forms 4.0.16
Case Generator/Dictionary 5.0
Oracle RDBMS 7.2.x
SQL Plus 3.2.3
SWAT Software Assurance & Testing Tool