Oracle Forms Experts in Germany

• Participated in project planning and solution design discussions to align business objectives with technical requirements.
• Conducted user requirements gathering, performed unit testing, and supported Conference Room Pilots (CRP) to validate system functionality.
• Implemented Oracle HCM Fusion Cloud modules, ensuring smooth deployment and alignment with client HR processes.
• Designed and developed Oracle OTBI and BI Publisher reports, dashboards, alerts, notifications, page integrations, and autocomplete rules to support business intelligence and automation.
• Worked on HCM data extracts and data migration using HCM Data Loader (HDL) and Spreadsheet Loader for efficient data handling and transformation.
• Managed and maintained project plans, developed project calendars, created change requests (CRs), and coordinated closely with consultants and clients for timely follow-ups.
• Currently acquiring hands-on experience in Oracle Policy Automation and Oracle Redwood UI to expand solution expertise.

PROFILE Senior Oracle specialist, consultant and DBA with many years of experience in planning, architecture, installation, migration, operations, performance tuning and troubleshooting of large Oracle database environments. Focus on Oracle Database 19c and enterprise architectures with RAC, Active Data Guard, Golden Gate, Exadata, RMAN and CDB/PDB. Experience in heterogeneous enterprise environments on Linux, AIX, Solaris, HP-UX and Windows, as well as in cloud and migration projects. Over many years, worked as a technical consultant, DBA, architect and project manager for banks, insurers, energy providers, public institutions, industry, automotive and aviation. Combining technical Oracle expertise with operations concepts, migration, project planning, documentation and customer consulting.

ORACLE FOCUS AREAS

• Oracle Database 19c – installation, upgrade, patch/RU management, operations and troubleshooting
• Oracle Database 21c / 23ai / 26ai – knowledge of current Oracle release lines
• Oracle RAC, Active Data Guard, Data Guard, Oracle GoldenGate
• CDB / PDB, multitenant architectures and enterprise database operations
• Oracle Exadata and highly available database environments
• RMAN – backup, restore, recovery, migration and disaster recovery scenarios
• Data Pump (EXPDP / IMPDP), Transportable Tablespaces (TTS) and database-based migrations
• Performance analysis, SQL / PL/SQL, tuning, troubleshooting and capacity planning
• Oracle Enterprise Manager / monitoring and technical operational support
• Oracle Security: Wallet, TDE, Database Vault, VPD / RLS
• Oracle DWH / BI: OBIEE, ODI, OWB and Discoverer
• Oracle Applications / E-Business Suite and Oracle-based application environments

CURRENT PROJECTS

Scope Solutions AG, Basel / CH | 08/2023 – ongoing Oracle Project Management and DBA

• Installation, maintenance and regular upgrades of Oracle database systems with a focus on Oracle 19c.
• Patch and release management including OPatch and Release Updates; operations on RHEL 8.x, SLES 15.x and Windows.
• DBA support for customers in DACH and Europe and support of production, load test and other CDB/PDB environments.
• Technical operating processes and documentation via Confluence; support and service requests via My Oracle Support / Metalink.

Federal Employment Agency, Nuremberg | 04/2022 – 10/2023 Oracle Operations Support / DBA

• Operations and regular upgrades of Oracle-19c database systems on SLES 15.x.
• DBA for around 2,100 PDBs on RAC and Exadata in production, integration, load test and other environments.
• Configuration management via ARS Remedy; workflows and technical documentation via Jira and Confluence.
• Operations support and processing of service requests via My Oracle Support / Metalink.

Federal Statistical Office, Wiesbaden | 09/2021 – 03/2022 Oracle Operations and Architecture – 2022 Survey

• Merging data into a central Oracle-19c database system.
• Design of import/export procedures for the central data structure.
• KPI and performance architecture for analyses.
• Training employees in Oracle performance and DBA topics.

E.ON Digital Technology, Landshut / KKI | 03/2019 – 12/2021 Oracle Operations, Architecture and DBA

• Patch concepts, technical documentation, installation, database administration and operations of Oracle 12c/19c.
• AIX 7.x, LPAR administration including VIO server and software distribution with NIM.
• Performance monitoring and monitoring.
• Backup and restore with TSM / IBM Spectrum Protect and Oracle RMAN.
• Installation of Enterprise Manager 13c with WebLogic Server 12.1x; employee training.

KaPe Munich – various end customers in DACH / Europe | ongoing / various projects Oracle DBA, architecture, migration, DWH consulting and project management

• Many years of consulting and operational DBA work in various Oracle architectures.
• DWH/CRM platforms: planning, analysis, performance and tuning, as well as business analysis.
• RAC, Data Guard, Transportable Tablespaces, RMAN and Oracle 11g/12c in enterprise environments.
• Customer projects including Burda, Deka, E.ON, Otto Group and Augsburger Allgemeine.

AXA, Germany / Europe | 09/2018 – 02/2019 Oracle DB Operations and Migration – Cloud Architectures

• Planning, methodology and execution of Oracle database migrations to IBM Private Cloud / Spectrum and AWS Public Cloud.
• Creation of Oracle databases in the cloud with SLES and Terraform templates.
• Technical architecture work and cloud KPIs.

RWE / SÜWAG / Syna, Germany | 07/2016 – 09/2018 Oracle DB Migrations 11g/12c and Project Management

• Design, planning and execution of Oracle database migrations 11g → 12c with platform and architecture changes.
• Windows Server 2012/2016 and setup and migration of Enterprise Manager/WebLogic-based monitoring environments.
• Use of Data Guard, TTS, EXPDP/IMPDP and RMAN based on analysis of application requirements.
• Performance and tuning for Oracle 11g/12c.

MTU Aero Engines, Munich | 01/2016 – 03/2017 Oracle DBA / Requirements Engineer

• Operations and development of Oracle 11g/12c databases and application workflows.
• Interfaces to SAP via BAPI.
• Design and management of APPS modules with Visual Basic / Visual Studio and PL/SQL; version control with SVN.

UBIS (HVB), Munich | 04/2012 – 08/2015 Oracle Operations, Architecture, DBA and Project Management

• Oracle-based operations and migration of MUREX and Sophis trading platforms.
• Oracle Security, Wallet, Tablespaces, RAC, Data Guard, Database Vault, GoldenGate and DWH.
• Project management for Oracle DWH migrations and release changes from 10g to 11gR2.
• Migration OWB 11gR2 → ODI 12c and introduction of Oracle Database 12c.
• Platforms: Red Hat, AIX and Solaris.

WWK Deutschland a.G., Munich | 09/2010 – 03/2012 Oracle DB and HP-UX → Linux Migration

• Architecture, planning, operations concept and migration of 104 databases from an HP-UX cluster to Red Hat Linux.
• Single Instance with Veritas Cluster and 2-node RAC 11.2.0.2; four Data Guard databases.
• Project management for OWB/DWH migrations (>1 TB), including tuning, PL/SQL, mappings and metadata.

Allianz Deutschland, ACAS Stuttgart | 03/2010 – 09/2010 Technical DWH Project Manager

• DWH project for processing European ETL data sources.
• Business analysis and requirements management for automated loading processes.
• OWB, PL/SQL, SQL*Loader, Oracle Advanced Security / TDE, Oracle BI and Database Vault.

NETMA, Munich-Taufkirchen | 08/2007 – 02/2010 Oracle Specialist and DBA for Oracle Applications 11i

• Operations of Oracle 9i/10g and Oracle Applications 11.5.10.
• Design and development of APPS modules with PL/SQL and SVN.
• Oracle RAC, Enterprise Manager, Oracle Application Server and migration tests.
• Platforms: AIX, SLES, Windows and HP-UX.

BT Germany, Munich | 11/2007 – 04/2008 Oracle DB Migration

• Migration from Oracle 8i to 10gR2 in a Solaris cluster environment.
• Preparing offers, project planning and process planning.

Itellium (KQ), Nuremberg | 02/2007 – 08/2007 Oracle DWH Specialist

• Design and analysis of a DWH focusing on master data and logistics.
• Oracle Designer, OWB, Oracle Database, ETL, PL/SQL and External Tables; data volumes up to approx. 5 TB.

Oracle Deutschland GmbH, Munich | 10/2006 – 02/2007 and further assignments Oracle Specialist / Consultant – Data Migration and DWH

• Consulting for customers such as Volkswagen, GE Money Bank, WeKa, KSB, Swisscom and British Telecom.
• Migration Discoverer EUL4 → EUL5i, database optimization, Data Guard and web/database analysis.
• Performance and tuning on Solaris and Linux.

HaSpa, Hamburg | 07/2006 – 10/2006 Oracle Specialist / Consultant – Data Migration and DWH

• Setup of an Oracle-10gR2 environment for banking applications.
• Data transfer from DB2 / OS390, architecture, sizing, tuning and performance.
• Data preparation and integration with OWB.

AUDI, Ingolstadt | 02/2005 – 06/2006 Oracle Consultant and DBA

• Operations, installation and maintenance of Oracle 9i/10g and IAS 10g.
• RMAN, Oracle RLS, Oracle HTMLDB, Veritas Cluster, Solaris and AIX / HACMP.
• Database cloning and migration 9i → 10g; approx. 200 systems up to 4.5 TB.

Photocolor, Kreuzlingen / CH | 11/2003 – 01/2005 Project Manager / Oracle

• Implementation, configuration, technical support and acceptance of an Oracle ERP/CRM solution.
• Oracle Applications, Oracle 9i, Solaris, HP-UX, OWB and Mercury TestDirector.
• Project scope approx. 2 TB; reporting to management.

ZPD NRW, Duisburg | 05/2003 – 10/2003 Oracle Consultant

• Consulting, PL/SQL training and project planning for a nationwide Oracle Forms integration.
• Oracle on HP Superdome / HP-UX; data volume 1.2 → 2.5 TB, sizing up to 5 TB.

Messe München GmbH | 11/2002 – 05/2003 Project Manager / Oracle

• MIS/DWH solution with OWB, Discoverer, Oracle 11i / 9i and RAC.
• Architecture, design, integration, troubleshooting and consulting for data volumes of 1.5–2 TB.

Aria SA Integration, Geneva / CH | 09/2002 – 11/2002 Oracle DBA and Consultant

• Oracle 8.1.7.4 / 9i; merging the Stuttgart and Geneva databases via replication.

• Development and implementation of backend components with PL/SQL and Oracle Forms 12c. Adaptation and further development of the policy administration system. Technical consulting in UI design with a focus on integrating existing Oracle Forms and the requirements of the BIPRO framework.
• The project takes place in the technical environment of BIPRO, SQL databases and Oracle Forms applications. The assigned work includes backend development and technical further development in the above project with the following tasks:
• Development and implementation of backend components with PL/SQL and Oracle Forms 12c to technically map the business processes and ensure a stable and efficient system architecture
• Adaptation and further development of the policy administration system to ensure system functionality in line with the requirements of the new broker communication program
• Analysis of the existing system to identify and avoid errors and technical problems during implementation, in order to enable a smooth transition to the new system
• Carrying out patching and further development of existing Oracle and Oracle Forms applications to ensure compatibility and security of the systems in use
• Technical consulting in UI design with a focus on integrating existing Oracle Forms and the requirements of the BIPRO framework.

Label: PL/SQL, Java, Oracle RDBMS and Oracle Forms

• Migration of a case management system with numerous interfaces to other systems from Spring and Activiti to a Java JEE application
• Further development toward a cloud application
• Consulting, development, requirements analysis, specification and design
• Coordination with upstream and downstream systems
• Data modeling, programming and implementation
• Support with code reviews and ensuring clean code in the PL/SQL context
• Documentation in Confluence
• Troubleshooting of PL/SQL applications, including log analysis, session tracing and performance profiling
• Optimization and tuning measures in the PL/SQL environment
• Knowledge transfer and onboarding of new employees
• Use of Jira for task management, progress tracking and sprint planning

• Design and implementation of an OCI-based DWH and ETL system to replace legacy mainframe applications
• Development of a database optimization strategy and planning the rapid conversion of JCL and COBOL routines to PL/SQL with the help of AI
• Development of an Oracle Apex-based app for internal administrative processes in the public sector (office equipment, employee training)
• Implementation of PL/SQL workflows for approval processes and creation of a responsive mobile version with JavaScript and CSS
• Use of Azure DevOps for backlog and documentation, as well as Git for version control
• Development of REST interfaces for CRM systems
• Replacement and reprogramming of Oracle Forms screens with Oracle Apex and upgrading to the latest Apex versions
• Design of a Git branching strategy and conducting code reviews
• Maintenance and further development of an EDI-based data exchange system based on Oracle Advanced Queuing for the public sector in Austria
• Data analysis and creation of charts in the Oracle Apex frontend; installation of standalone ORDS and Apex 23.1
• Agile working according to the Spotify Model; development of complex Apex screens with the support of Oracle JET
• New development and customization of existing PL/SQL packages, workarounds for database version differences and query optimization
• Development of Apex applications for broker pools to manage and optimize Oracle databases in the banking sector, including SSO-based authorization systems with OAuth2 and Keycloak
• Development of extensive Oracle Apex applications for BI and data mining modernization projects, as well as development of manual and automated projection methods in the frontend
• Implementation of data warehousing projects in the banking sector and use of Scrum and Kanban in team-oriented projects

• Maintenance, further development, modernization and testing of the OK.VERKEHR specialist application, a monolithic Enterprise Java solution (with approx. 3,5 Mio LOC) for vehicle registration and driving license authorities
• Design, development, testing and maintenance of end-to-end workflows (dialogs, backend services and persistence layer, test suite) for new driving license applications, changes/extensions to driving licenses, management of parking permits and truck driver cards
• Development and maintenance of web services for communication between local traffic authorities and the Federal Motor Transport Authority, FAER register, TÜV testing centers and driving schools
• Performance optimization and targeted refactoring for the future migration to a cloud architecture and the addition of a new web client (Vaadin)
• 3rd-level support for customers during ongoing operations

• Conducted a comprehensive due diligence review for a potential acquisition of a Swiss manufacturing company as part of a pre-merger analysis
• Assessed production capacities and technical infrastructure
• Evaluated integration possibilities into existing business processes
• Performed risk assessment and developed recommendations for action
• Documented the findings and presented them to management

• Enterprise and IT strategy
• Digital transformation
• Process and portfolio management
• Interim IT management

• Client: Terex Corporation

• Business analysis of payments for the introduction of Wero EPI in Germany.
• Analysis and optimization of merchant processes in the context of acquiring and issuing.
• Analysis of interfaces for instant payments.
• Analysis of SCT-Inst processes, settlement mechanisms and reporting processes.
• Identification and clarification of gaps in merchant processes.
• Analysis and documentation of clearing and settlement processes.
• OSPlus process analysis and documentation.
• Coordination and alignment with scheme management as well as various payment service providers and financial institutions on merchant processes.
• Preparation and follow-up as well as active participation in EPI meetings on technical coordination and regulatory topics in payments, including content familiarization and prioritization.
• Preparation and documentation of project and steering committees in the EPI environment.
• Creation of status reports for the subproject.
• Maintenance and structuring of Confluence pages for project documentation.
• Coordination and alignment with the issuing teams on individual customer processes as well as aligning with bank processes and acquirer processes in the Wero environment.
• Communication with payment service providers regarding merchant and bank processes in the Wero environment.
• Organizational support for project management in special tasks in the EPI and Wero environment.
• Digital filing and documentation in Confluence and Microsoft Teams.
• Planning, implementation and tracking of work packages and steps.
• Quality assurance and project control.
• Consulting on IT strategy, IT architecture and interface management in the EPI and Wero environment.
• Technical environment: Jira, Confluence, XML, JSON, MS Office (Word, Excel, Teams, PowerPoint), SharePoint, Draw.io, Innovator, 3rd-level support, ITIL, creation and updating of software documentation, interface management, OSPlus, Scrum, KYC, payment, European Payments Initiative (EPI), Wero, Microsoft Loop, Instant Payments, SCT-Inst.

• Supported the production rollout of the KVAI-Classic master data system
• Analyzed and fixed errors in PL/SQL-based interfaces on Oracle 19
• Designed fixes and enhancements for the service provider

• Maintenance of a company-wide Oracle database that consolidates information from various internal databases, Active Directory, and other systems

• Data transfer via Oracle jobs between the monitoring database and other systems

• Data visualization and processing using APEX and Oracle Forms (with Forms being replaced by APEX)

• Gathering requirements from business units

• Designing the implementation

• Implementation at the database level and in APEX

• System maintenance

• Troubleshooting

Technologies: Oracle 12, Oracle 19, Oracle PL/SQL, Oracle APEX, SQL Developer

• Oracle databases 11g, 12c and 19c RAC
• Installation, configuration and deployment of Oracle Fusion Middleware 11g & 12c (WebLogic, SOA, Oracle Forms and Report Server, etc., OBIA)
• Administration of Oracle 11g, 12c, RAC and 19c
• Applying patches
• Installation, configuration and deployment of Tomcat
• Oracle tuning
• The system includes several production, QA, test & development Oracle databases and WebLogic application servers 11g & 12c