Kai Pankatz - Oracle Project Management and DBA

Munich, Germany

Experience

Aug 2023 - Present

2 years 6 months

Oracle Project Management and DBA

Scope Solutions AG

Installation, maintenance, and regular upgrades of DB systems with 19x
Use of OPatch and RU 19.27 on RHEL 8x, SLES 15.x, and Windows
DBA for DACH and European clients in production and load test environments (e.g. Konrad Adenauer) and others in CDB
Processes via Confluence
Operational support for client SR via Metalink

Apr 2022 - Oct 2023

1 year 7 months

Nuremberg, Germany

Oracle operations support with TEC4 Central CM

Federal Employment Agency

Operation and regular upgrades of DB systems with 19x on SLES 15.x
DBA for about 2100 PDBs on RAC and Exadata in prod, int, LTU, and others in CDB
Configuration management via ARS Remedy
Processes 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

Federal Statistical Office

Consolidation of data into a central Oracle 19x DB system
Creating IMP/EXP concepts for the central DB structure
Developing 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 and documentation (SHB)
Installing AIX 7.x and Oracle 12/19c, database administration, updates, and operations
LPAR administration including VIO server and software distribution on AIX with NIM server
Performance monitoring and supervision
Backup 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 DB migrations to the cloud
Creating Oracle DBs in the cloud with SLES Terraform templates and cloud KPIs
Migration to IBM Blueprint (Spectrum Private) and AWS (Amazon Public) cloud

Jul 2016 - Sep 2018

2 years 3 months

Germany

Oracle DB Migrations 11g/12c, Project Lead

RWE / SüwAG / syna

Design, planning, methodology, and execution of DB migrations from 11g to 12c with platform and architecture changes
Operation on Windows 2012/2016 and upgrade from EMGC to EM12c
Setup of 12c EM via WebLogic Server 10.3x for monitoring
Use of Data Guard, transportable tablespaces, IMPDP/EXPDP, RMAN based on application analysis and prerequisites
Performance and tuning for Oracle 11g and 12c

Jan 2016 - Mar 2017

1 year 3 months

Munich, Germany

Requirements Engineer and Business Analyst for Material Support System (MSS)

MTU Aero Engines

Operation and development of Oracle 11g/12c DBs and applications/workflows
Interfaces (BAPI) to SAP
Design and management of customization and development of app modules in Visual Basic Studio and PL/SQL via Subversion
Used in aircraft engine manufacturing and logistics

Apr 2012 - Aug 2015

3 years 5 months

Munich, Germany

Oracle Operations, Architecture, and DBA, Project Lead

UBIS (HVB) Deutschland

Operation and migration of MIB trading platforms for Murex, Sophis, etc., with different Oracle architectures
Oracle security (wallet, tablespaces), high availability (RAC, Data Guard), DB Vault, GoldenGate, DWH
Project lead for DWH Oracle migration from 10g to 11g rel2
Upgrade from OWB 11g rel2 to ODI 12c and Oracle 12c rel. 12.x
Operating systems: Red Hat 5.x, AIX 6.x/7.x, Solaris 10

Mar 2012 - May 2012

3 months

Munich, Germany

Oracle Specialist and Consultant for Data Migration/DWH

Oracle Deutschland GmbH

Consulting at Volkswagen AG, GE Money Bank, WeKa, KSB, Swisscom, British Telecom
Migrations and performance tuning of Oracle DBs

Sep 2010 - Mar 2012

1 year 7 months

Munich, Germany

Oracle DB and HP-UX to Linux Migration

WWK Deutschland a.G.

Architecture, planning, and operations concept for moving 104 DBs (SI, ADG, and RAC 11.2.0.2) from HP-UX cluster to Red Hat 5.x
Veritas cluster and 2-node RAC
4 Data Guard DBs 11g
Project lead for OWB migration and configuration of DWHs (>1 TB) with tuning, PL/SQL, mappings, metadata, and WebLogic

Mar 2010 - Sep 2010

7 months

Stuttgart, Germany

Technical Data Warehouse Project Manager for Poland

Allianz Deutschland, ACAS

AML project to populate a data warehouse via OWB 11i with ETL files from various European locations (PL, IRL, F)
Business analysis and requirements management
Automated ETL load using OWB, mappings, PL/SQL, SQL*Loader
Data encryption using Oracle Advanced TDE
Use of OBI 11g, Oracle 11i with Database Vault, OWB 11i rel1, SQL*Loader, DataModeller, Linux 10

Nov 2007 - Apr 2008

6 months

Munich, Germany

Oracle DB Migration Design and Implementation

BT-Germany

Migration from Oracle 8i to 10g rel2 in a Solaris cluster
Proposal creation, project plan and schedule

Aug 2007 - Feb 2010

2 years 7 months

Taufkirchen, Germany

Oracle Specialist and DBA for Apps 11i

NETMA

Operation of Oracle 9 / 10g databases, Apps 11.5.10 and NETMA applications
Design, control and development of Apps modules in PL/SQL via Subversion
Platforms: IBM AIX 5.x, SLES 9, Windows, HP-UX, Linux
Oracle RAC 10 rel3 and Oracle 11g rel2
Migration testing and tuning

Feb 2007 - Aug 2007

7 months

Nuremberg, Germany

Oracle Data Warehouse Specialist

Itellium (KQ)

Design and analysis of master data and logistics to build a data warehouse in mail order
Use of Designer 9i, OWB 10g, Oracle 10g rel2, ETL, PL/SQL, External Tables for about 5 TB of data

Oct 2006 - Feb 2007

5 months

Munich, Germany

Oracle Specialist and Consultant for Data Migration/DWH

Oracle Deutschland GmbH

Migration from Discoverer EUL4 to EUL5i (10g) and optimization of the Oracle 10g database
Implementation of Data Guard 10g and web applications
Performance analysis and tuning on 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 banking applications (WP, SAMBa, KBP, BO)
Data transfer from OS/390 DB2 via LOADS
Architecture, sizing, tuning, and performance
Data preparation according to DWH principles using OWB 10g

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 and 10g, IAS 10g
Archiving (Oracle RLS), RMAN, HTMLDB 1.6.x, Veritas Cluster
Operating systems: Solaris 8/9, AIX 5.3 with HACMP
Over 200 systems up to 4.5 TB
Migration from 9i to 10g

Nov 2003 - Jan 2005

1 year 3 months

Kreuzlingen, Switzerland

Project Manager

Photocolor

Implementation and configuration of Oracle Apps 11.5.7–9 including CRM/Telesales on Solaris 8 and HP SAN
Technical support and acceptance of the ERP Oracle project with MIS, OWB, and Mercury TestDirector
Data volume approx. 2 TB
Project completion through outsourcing of the system platform

May 2003 - Oct 2003

6 months

Duisburg, Germany

Oracle Consultant

ZPD (Central Police Services) NRW

Consulting on the ORA-Forms-IgWeb application project for the police in NRW
PL/SQL training and project planning with architecture
Design for growing data volumes up to 5 TB

Nov 2002 - Oct 2003

1 year

Munich, Germany

Project Manager

Messe München GmbH (MMG)

MIS solution with OWB and Discoverer 4i on Oracle 11i (11.5.8) and Balanced Scorecard on Windows 2000 Server and Symmetrix SAN
DWH architecture and integration
Troubleshooting and consulting for data volumes of 1.5–2 TB

Oct 2002 - Dec 2002

3 months

Geneva, Switzerland

Oracle DBA and Consultant

Aria SA Integration

DBA and consulting for Oracle 8.1.7.4 and 9i at client Chopard
Merged the Stuttgart and Geneva DBs through Oracle replication

Oct 2001 - Present

24 years 4 months

DBA, Oracle DWH Consulting, Project Management, IT Audit and Compliance

KaPe Munich

Consulting and support for end customers in DACH, Luxembourg, and Europe via Scope AG
Planning, analysis, and performance tuning of DWH/CRM platforms for campaign management
Business analysis
High availability architecture with RAC 12c on OVM, Red Hat 6.x, and AIX 7.x
Hardware analysis on Solaris 11
Use of OBIEE, Data Guard, Transportable Tablespaces (TTS) 11g/12c, and RMAN
Performance tuning for Oracle 11g and 12c

Jan 2001 - Oct 2002

1 year 10 months

Munich, Germany

Oracle DBA and Project Manager

Bertelsmann / ORT-Studios

Oracle DBA (including 9i) and integration on Solaris 7/8 and Windows 2000
Cross-platform DB replication, troubleshooting, and backup with Veritas

Jan 2001 - Dec 2001

1 year

Munich, Germany

Oracle Consultant and DBA

Bayerische Landesbank

DBA support for Oracle 8.x/8i in production environments
Set up a migration framework to Oracle 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 MP5 for European clients using Oracle 8i and AS 9i
DBA tasks, performance tuning, ETL with SQL*Loader, troubleshooting
Projects at Migros, Haelg & Winterthur, SEW, Bundeswehr, BMW, Flextronics, and other Central European clients

Apr 1999 - Feb 2000

11 months

Munich, Germany

NT Specialist, Oracle DBA

TDS Consulting GmbH

Migration projects and coexistence with Lotus Notes R4x/5
Windows Terminal Server, Citrix Metaframe, MS Exchange 5.5, SMS 2.0, MS Proxy Server
Oracle DBA for versions 7.3.4 and 8.0.5
Projects at Siemens AG Berlin, Leonberger BauSpK and other clients

Jun 1998 - Mar 1999

10 months

Munich, Germany

Application Specialist

VIAG Interkom GmbH & Co.

MS Exchange 5.5 design, implementation and administration
Network technology and security
Oracle 7.3.2, 7.3.3 and 8.x on Windows NT and HP-UX

Mar 1997 - Jun 1998

1 year 4 months

Taufkirchen, Germany

Integration of CADPS with AECMA 2000M and EDI

Syseca GmbH

Set up an order administration environment according to AECMA 2000M
Oracle 7.x and Forms 4.x environment
Documentation for the client
Use of Case Generator 5.0, SWAT

Summary

Project overview in freelance work, kape munich since 10/2001

Scope Solutions AG, Basel, CH

08/23 - present Oracle project management and DBA Installation, maintenance and regular upgrade of DB systems with 19x. OPatch, RU 19.27 on RHEL 8x, SLES 15.x, and Windows. DBA for DACH and European clients, prod and load test environments like Konrad Adenauer etc. and others in CDB. Processes via Confluence. Operational support for client SR via Metalink

Federal Employment Agency, Nuremberg, DE

04/22 - 10/23 Oracle operations support with TEC4 central CM Operation and regular upgrade of DB systems with 19x on SLES 15.x. DBA for about 2100 PDBs on RAC and Exadata in prod, int, LTU and others in CDB. CM via ARS Remedy. Processes via JIRA and Confluence. Operational support for SR via Metalink.

Federal Statistical Office, Wiesbaden, DE

09/21 - 03/22 Oracle operations, architecture for the 2022 survey 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

Skills

It And Project Management Skills

Operating Systems

Windows 11, 2019 Server, Etc.
Dos
Unix (Hp-ux 11.x (Superdome), Dynix, Solaris 6-11, Aix 7x)
Linux (Suse Sles 15x, Red Hat 7.x, Oel 7x)

Databases

Oracle Including 23ai, 21c, 19c, Etc.
Rac
Adg
Ogg
Performance
Tuning
Troubleshooting
Toad (Db Analysis Tool)
Oracle Data Guard
Oracle Vpd (Rls)
Microsoft Sql Server
Access

Middleware (Oracle)

Oracle As 10g Release 3
Weblogic (Wls) Up To 12.1x Via Em 13c

Ha And San Solutions

Aws Cloud
Exadata Including X7
Oracle Rac Up To 12c
Hp-ux Sd 11.x
Sun Solaris Clustering V3
Veritas Cluster 5x And Vm
Hacmp (Ibm)
San Symmetrix
Emc²
Hp Xp
And Other Vendors For Comparison

Cloud Architectures

Public And Private With Ibm And Aws Including Analysis And Cloud Kpis

Erp/crm/dwh

Oracle Biee 12c
Oracle Apps (Ont, Po, Gl, Ar, Ap)
Mis (Dwh)
E-commerce
B2b
Online Marketing
Odi
Owb Rel 11.2
Discoverer 10g - 4i
Designer 9i

Oracle-based Phases 1-3
Strategy
Concept
Implementation
Master Data Management (Mdm)

Backup/recovery

Veritas 5.x
Legato Networker 6x
Rman Oracle 19c
Oracle Rls
Tsm/isp (Spectrum Protect)
Data Protector (Hp)
Etc.

Programming

Sql
Pl/sql
Pro*c
Visual Basic Studio
C++

Sw-engineering/testing

Oracle Di 12c
Owb 11g2 And Workflow
Ora-designer
Sql Navigator
Etl
Erm
Especially For Dwh Concepts
Db Design
Oo Analysis
Structural Analysis & Design (Sa, Sd)
Sccm: Mercury Testdirector
Swat
Svn
Dimension Cm

Project Management

Tpl
Project Planning
Presales
Postsales
Mis
Iso 9001
Iso 10006
Ppm According To Pmi
Onyx
Ms Project
Ms Powerpoint
Dms
Knowledge Db
Service Contracts
Requirements Specification
Ba
Rm (Am)
Service Offers (Add-ons, Customizing)
Bpo
Spoc

Ticketing/change Mgmt

Itil Management
Itsm
Hp Service Manager
Clarify
Remedy
Thinkware (Magic)
Helpline
Altiras
Sc
Dimension And Pvcs (Serena)
Subversion (Svn)
Git
Sla

Documentation

Visio 2016
Requirements Specification
User Manuals Technical And Functional
Proposals
Decision Templates For Management (Executive Board)
Service Contracts
General Documents For Strategy And Conception

Domain Knowledge

Telecommunications And Information Systems
Insurance And Banking
Energy And Power
Publishing, Advertising, And Photo Finishing
Automotive And Supplier Industry
Aerospace
Logistics In Aircraft Manufacturing And Industry
Dwh Or Enterprise Dwh Solutions
Materials Management Systems: Supply Chain, Erp, And Crm Systems (E.g. Obiee 12c, Oracle Apps 11i, Cadps)
Ihms Solutions With Oracle
License Management Oracle, Lct
Electronic Data Interchange (Edi) (Message Handler)
Aecma Spec 2000
International Projects
Outsourcing (Bpo)
Service Contracts For Applications And Dbs With Clients