Kai Pankatz-Oracle Project Management and DBA
Check rate
Experience
Oracle Project Management and DBA
Scope Solutions AG
- Installation, maintenance and regular upgrade of the DB systems with 19x
- Use of OPatch and RU 19.27 on RHEL 8x, SLES 15.x and Windows
- DBA for DACH and European customers in production and last test environments (e.g. Konrad Adenauer) as well as others in CDB
- Processes via Confluence
- Support in operations for customers SR via Metalink
Oracle operational support with TEC4 central CM
Bundesagentur für Arbeit
- Operation and regular upgrade of the DB systems with 19x on SLES 15.x
- DBA for approx. 2100 PDBs on RAC and EXADATA in Prod, Int, LTU and others in CDB
- Configuration management via ARS Remedy
- Processes via JIRA and Confluence
- Support in operations for SR via Metalink
Oracle operations, architecture for the 2022 survey
Statistisches Bundesamt
- Combining data into a central Oracle 19x DB system
- Creation of IMP/EXP concepts for the central DB structure
- Development of metrics and performance architecture for evaluations
- Training of STBA staff in the Oracle performance and DBA environment
Oracle operations, architecture for AIX LPAR and Oracle DBA
E.ON Digital Technology
- Creation of patch concepts and documentation (SHB)
- Installation of AIX 7.x and Oracle 12 / 19c, database administration, updates and operations
- LPAR administration incl. VIO server and software distribution on AIX with NIM server
- Performance monitoring and monitoring
- Backup with TSM / IBM Spectrum Protect (ISP) including backup and restore with RMAN
- Installation of EM13c with WebLogic Server 12.1x
- Training of EDT employees
Oracle DB operations – migrations to 18c / 12c with various cloud architectures
AXA
- Planning, methodology and execution of DB migrations to the cloud
- Creation of Oracle DBs in the cloud with SLES Terraform templates and cloud KPIs
- Migration to IBM Blueprint (Spectrum Private) and AWS (Amazon Public) cloud
Oracle DB migrations 11g / 12c, project management
RWE / SüwAG / syna
- Concept, planning, method, and execution of DB migrations from 11g to 12c with platform and architecture changes
- Operation on Windows 2012 / 2016 and release change from EMGC to EM12c
- Setup of 12c EM via WebLogic Server 10.3x for monitoring
- Use of Data Guard, Transportable Tablespaces, IMPDP / EXPDP, RMAN after analysis and application prerequisites
- Performance and tuning for Oracle 11g and 12c
Requirements engineer and BA for Material Support System (MSS)
MTU Aero Engines
- Operation and development of Oracle 11g / 12c databases and application/workflows
- Interfaces (BAPI) to SAP
- Concept and control of the customization and development of app modules in Visual Basic Studio and PL/SQL via Subversion
- Use in aircraft engine construction and logistics
Oracle operations, architecture and DBA, project management
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 management for DWH Oracle migration from 10g to 11g rel2
- Release change from OWB 11g rel2 to ODI 12c and Oracle 12c rel. 12.x
- Operating systems: Red Hat 5.x, AIX 6x/7x, Solaris 10
Oracle specialist and consultant for data migration/DWH
Oracle Deutschland GmbH
- Consulting at Volkswagen AG, GE Money Bank, WeKa, KSB, Swisscom, British Telekom
- Migrations and performance tuning of Oracle DBs
Oracle DB and HP-UX-to-Linux migration
WWK Deutschland a.G.
- Architecture, planning, and operating 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 management for OWB move and setup of the DWHs (>1 TB) with tuning, PLSQL, mappings, metadata, and WebLogic
Technical Project Manager DWH for Poland
Allianz Deutschland, ACAS
- AML project for loading a DWH via OWB 11i with ETL files from different European sites (PL, IRL, F)
- Business analysis and requirements management
- Automated ETL load with OWB, mappings, PL/SQL, SQL*Loader
- Data encryption via Oracle Advanced TDE
- Use of OBI 11g, Oracle 11i with Database Vault, OWB 11i rel1, SQL*Loader, DataModeler, Linux 10
Oracle DB migration design and implementation
BT-Germany
- Migration from Oracle 8i to 10g rel2 in a Solaris cluster
- Preparation of offers, project plan, and schedule
Oracle specialist and DBA for Apps 11i
NETMA
- Operation of Oracle 9 / 10g DBs, Apps 11.5.10 and NETMA applications
- Design, coordination, and development of Apps modules in PL/SQL via Subversion
- Platforms: AIX IBM 5x, SLES 9, Windows, HP-UX, Linux
- Oracle RAC 10 rel3 and Oracle 11g rel2
- Migration tests and tuning
Oracle DWH specialist
Itellium (KQ)
- Design and analysis of master data and logistics for creating a DWH in mail order retail
- Use of Designer 9i, OWB 10g, Oracle 10g rel2, ETL, PL/SQL, External Tables for a data volume of around 5 TB
Oracle specialist and consultant for data migration/DWH
Oracle Deutschland GmbH
- Migration from Discoverer EUL4 to EUL5i (10g) and optimization of the Oracle 10g DB
- Introduction of Data Guard 10g and web applications
- Performance analysis and tuning in Solaris 10 and Linux 10
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 from DB2 via LOADS
- Architecture, sizing, tuning, and performance
- Data preparation according to DWH principles with OWB 10g
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
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
Oracle Consultant
ZPD (Central Police Services) NRW
- Consulting for the ORA-Forms-IgWeb application project for the police in NRW
- PL/SQL training and project planning with architecture
- Designed for growing data volumes up to 5 TB
Project Manager
Messe München GmbH (MMG)
- MIS solution with OWB and Discoverer 4i on Oracle 11i (11.5.8) and Balanced Scorecard with Windows 2000 Server and Symmetrix SAN
- DWH architecture and integration
- Troubleshooting and consulting for data volumes of 1.5–2 TB
Oracle DBA and Consultant
Aria SA Integration
- DBA and consulting for Oracle 8.1.7.4 and 9i at the customer Chopard
- Merging the Stuttgart and Geneva databases through Oracle replication
DBA, Oracle DWH Consulting, Project Management, IT Audit, Audit
KaPe Munich
- Consulting and support for end customers in DACH, Luxembourg and Europe via Scope AG
- Planning, analysis, and performance of DWH/CRM platforms for campaign management
- Business analysis
- High availability architecture with RAC 12c on OVM or Red Hat 6x and AIX 7x
- Hardware analysis on Solaris 11
- Use of OBIEE, Data Guard, Transportable Tablespaces (TTS) 11g/12c, and RMAN
- Performance and tuning for Oracle 11g and 12c
Oracle DBA and Project Manager
Bertelsmann / ORT-Studios
- Oracle DBA (also 9i) and integration on Solaris 7/8, Windows 2000
- Cross-platform database replication, troubleshooting, and backup with Veritas
Oracle Consultant and DBA
Bayerische Landesbank
- DBA support for Oracle 8x/8i in production environments
- Creation of a migration structure on Oracle 8.1.7 Patch 2
Project Manager, Consultant, Oracle DBA
Datastream System GmbH
- Integration and technical sales of MP5 at European customers with Oracle 8i and AS 9i
- DBA tasks, performance, tuning, ETL with SQL*Loader, troubleshooting
- Projects at Migros, Haelg & Winterthur, SEW, the German Armed Forces, BMW, Flextronics, and other Central European customers
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 customers
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 8x on Windows NT and HP-UX
Integration of CADPS with AECMA 2000M and EDI
Syseca GmbH
- Setup of an order administration environment according to AECMA 2000M
- Oracle 7x and Forms 4x environment
- Documentation for the customer
- Use of Case Generator 5.0, SWAT
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Banking and Finance, Professional Services, Energy, Government and Administration, and Insurance.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Project Management, Business Intelligence, Operations, Supply Chain Management, and Sales.
Summary
Project overview in freelance work, kape munich since 10/2001
Scope Solutions AG, Basel, CH
08/23 – ongoing Oracle Project Management and DBA installation, maintenance and regular upgrade of the DB systems with 19x. OPatch, RU 19.27, RHEL 8x, SLES 15.x, also Windows. DBA for DACH and Europe customers, Prod, LastTest environments, Konrad Adenauer etc. and others in CDB. Processes via Confluence. Support in operations for customers SR via Metalink
Bundesagentur für Arbeit, Nürnberg, D
04/22 – 10/23 Oracle operational support, with TEC4 central CM operations and regular upgrade of the DB systems with 19x. SLES 15.x. DBA for approx. 2100 PDBs on RAC and EXADATA, Prod, Int, LTU and others in CDB. CM via ARS Remedy. Processes via JIRA and Confluence. Support in operations for SR via Metalink.
Statistisches Bundesamt, Wiesbaden, D
09/21 – 03/22 Oracle operations, architecture for the 2022 survey combining data into a central Oracle 19x DB system, creating IMP/EXP concepts for the central DB structure, metrics and performance architecture for evaluations, training of STBA staff in the Oracle performance and DBA environment
Skills
It And Project Management - Knowledge
Operating Systems
- Windows 11, 2019 Srv 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 Incl. 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 Rel 3
- Weblogic (Wls) Up To 12.1x By Em 13c
Ha And San Solutions
- Aws Cloud
- Exadata Incl. 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
- Among Others, Vendor Comparisons
Cloud Architectures
- Public And Private With Ibm And Aws Including Analysis And Kpi Cloud
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
BI
- 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 (Spectrumprotect)
- Data Protector (Hp)
- Etc.
Programming
- Sql
- Pl/Sql
- Proc
- Visual Basic Studio
- C++
Sw Engineering/Testing
- Oracledi 12c
- Owb 11g2 And Workflow
- Ora Designer
- Sql Navigator
- Etl
- Erm
- Especially For Dwh Concepts
- Db Design
- Oo Analysis
- Structured 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 Mgr
- 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
- Offers
- Decision Papers For Management (Gl)
- Service Contracts
- General Documents For Strategy And Concept Work
Professional Knowledge
- Telecommunications And Information Systems
- Insurance And Banking
- Energy And Electricity
- Publishing, Advertising, Photo Finishing
- Automotive And Supplier Industry
- Aerospace
- Logistics In Aircraft Construction And Industry
- Dwh Or Enterprise Dwh Solutions
- Material Management Systems: Supply Chain, Erp And Crm Systems (E.G. Obiee 12c, Oracle Apps 11i, Cadps)
- Ihms Solutions With Oracle
- Oracle Licence Mgmt, Lct
- Electronic Data Interchange Edi (Message Handler)
- Aecma Spec 2000
- International Projects
- Outsourcing (Bpo)
- Service Contracts For Applications And Dbs With Customers
Languages
Education
Siemens Nixdorf AG, Training Center Munich-Perlach
Certified application developer client-server · Application development client-server · Munich, Germany
Technical University of Munich-Weihenstephan
Graduate engineer in food technology · Technology and biotechnology of food · Freising, Germany
Theesen Primary School, Max Planck Gymnasium
General higher education entrance qualification, Abitur · Bielefeld, Germany
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Daily Rate Distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Oracle Project Management and DBA
Nearby freelancers
Professionals working in or nearby Munich, Germany
