PL/SQL Expert in Munich

Wolfgang T.

Senior Project Manager and Requirements Manager/Business Analyst

Unterhaching

Last position:

Overall Project Manager at itzbund

Project overview: The use of “Generative Pretrained Transformer” (GPT) technologies will greatly change the world of work in the coming years. ITZBund is developing a basic service for this purpose, which can be used by its 200 customers. This basic service is offered both on-premises and in the cloud. Launched in 12/23, production systems (based on the MVP) had already been successfully rolled out and operated for several authorities and federal ministries by 05/24.

Project metrics:

2024 budget approx. 20 Mio €
approx. 70 people directly involved in the project
regular (indirect) contact with approx. 80 people in the wider project environment

My main responsibilities:

Overall responsibility as external project manager
Project definition phase/ Project setup and establishment of the project organization
Strategic and operational project planning, as well as project design and ongoing adjustments
Ongoing coordination with the project owner and stakeholders at ITZBund
Ongoing coordination with sub-project managers, agile roles, and other project team members
Responsibility for project controlling, quality management, risk management, and change management
Responsibility for providing the basic service in on-premises and cloud environments and its ongoing development
Planning and leading several hypercare phases
Collaboration and ongoing coordination with a federal ministry partner project and delivery of an MVP
Coordination with the agile teams
Coordination with operations, release, and deployment
Responsibility for delivering initial customer projects
Responsibility for developing AI governance
Ensuring accessibility (BITV)
Responsibility for setting up a sub-project for marketing activities
Support in setting up an efficient proposal process
Stakeholder management

Approach:

V-Modell XT ITZBund
Scrum

Tools used:

Microsoft Office, Skype, MS Project, Confluence, Jira, Sharepoint, Miro

Florian B.

Program & Integration Lead (AI, Data & Analytics Transformation)

Last position:

Project Management / PMO Consultant

PMO & Project Organization Blueprint for Restructuring

Renewable Energy / Solar Equipment

Technologies / Methods: PMO setup, KPI tracking, project organization, Jira, Confluence

Developed measures to improve management control during a restruct...

Birgit S.

Business Analysis & Solution Design :: IT Architecture :: Project Management

München

Last position:

Business Analyst / Requirements Engineer / Tester at BMW

Topics:

Further development of the CRM system NKAM and technical separation of “direct” and “indirect” sales
Redesign of the discount management area and outsourcing to another system.
Designing numerous improvements on the wholesale side to reduce manual effort down to the level of user stories.

Markus B.

Software Development / Programming; Consulting; Project Management / Management / Organization / Coordination;

Last position:

Developer / DevOps, Consulting at A state authority in Baden-Württemberg / FSAS Technologies GmbH

Oracle Project Management and Automation

As part of the project, the operation of an Oracle infrastructure was automated by developing and enhancing Puppet modules and migrating existing Bash scripts to a standardized configuration management solution.

The aim of the project was to standardize and automate administrative processes, improve the maintainability of the Oracle platform, and increase the efficiency and traceability of infrastructure management through the use of Infrastructure as Code.

Analysis and migration of existing Bash shell scripts to a Puppet-based automation solution
Development and enhancement of Puppet modules for Oracle environments
Automation of installation, configuration and operational processes using Infrastructure as Code
Standardization and optimization of configuration management for Oracle systems
Creation and maintenance of technical and operational documentation
Planning, coordination and professional support during project implementation
Operation and automation of Oracle systems on x86-based Linux server platforms
Testing and quality assurance of the developed Puppet modules
Analysis and resolution of technical errors as part of the automation and migration
Close coordination with specialist departments and infrastructure teams to implement automation requirements

Technologies used: Puppet 7/8, SLES 15, Oracle 19, Oracle Grid, SVN, Windows Server, Confluence, VS Code, Ruby, Bash, Pass

Philipp G.

Machine Learning & Data Engineer

München

Last position:

Data Scientist & ML Engineer at Data-Science Factory GmbH

Building, implementing and selling automated Data Science solutions such as Scorecard Factory and Forecast Factory
Implementation of automated end-to-end cloud processes
Development of LLM and NLP models
Creation of interactive reports
Support for national and international large corporations as well as medium-sized companies in implementing ML projects

Kai P.

Senior Oracle Specialist & Consultant

Last position:

Oracle Project Management and DBA at Scope Solutions AG

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.

Emanuel F.

Interim Architect & Data Taskforce

Last position:

Interim Architect & Data Taskforce at Freelancer / Project Assignments

Data Engineering: Design and implementation of scalable data pipelines
Legacy migrations to Microsoft Fabric (Lakehouse, Dataflows Gen2, Pipelines)
BO Universe migrations to MS Fabric / Semantic Models / Power BI
Taskforce for data-driven transformation projects involving Azure Fabric / Oracle / MSSQL

John R.

Technical Account Manager

Last position:

Munich Volkshochschule

Teaching English at Munich Volkshochschule, developing training materials and delivering courses to adult learners

Frank E.

DevOps

Ismaning

Last position:

DevOps at Lauck-IT

Operations and extensions of Azure DevOps pipelines
Operations and extensions of AWS services
Citrix (Windows 10, Bitwarden)
AWS: ECR, EKS, CloudFront CDN, Route 53, VPC peering and CNI upgrade, Atlas MongoDB, S3 buckets, static website hosting
Azure: build and deploy with DevOps pipelines

Michael T.

Senior DWH Developer

Last position:

ETL Developer at Insurance service provider

DWH for customer and financial data

Expansion of the DWH to include new data sources
Report development
Data quality management

Methodology: Scrum

Tools: Atlassian Confluence & Jira

Databases: Microsoft SQL Server

Programming languages: SQL, T-SQL

ETL: Microsoft SQL Server Integration Services (SSIS)

Frontend platform: PowerBI, Microsoft Reporting Services

Stefan W.

Architect/Software Developer/Infrastructure

Ottobrunn

Last position:

Architect/Software Developer at Global Logistics Support GmbH

Tasks

Further development of a new ERP system with Blazor
Generation of e-invoices in the XRechnung and Zugferd formats
UI/UX design Client-server system
Windows 11 Technology
Microsoft .NET 9, Git, Azure DevOps, ASP.NET, MSSQL, Blazor Programming languages
C#, MVVM Development tools
Microsoft Visual Studio .NET 2022 Database
MSSQL Industry
Other

Ernst H.

Support/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD

München

Last position:

Support/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD

Support and further development of a complex process for creating XML documents for electronic invoices / E-Invoicing (XRechnung, ZUGFeRD)
Automation of operational processes, process development and optimization
Development of frontend applications with MS Power Apps
Porting SQL Server 2016 to SQL Server 2022
SQL Server database administration

Stefan C.

SQL, ETL, Reporting, DWH Development

Last position:

SSIS Development at Stadtsparkasse München

Replacement of a Java application and the Oracle DB for loading the internal WerWasWo system using SSIS.
Development of SSIS packages to load text files into the database (SQL Server)
Development of a database project for deployment on various servers
Creation of queries to monitor the loading runs
Development of a PowerShell script to automate the deployment of the SSDT projects.
Oracle, SQL Developer, Microsoft SQL Server 2022 on-premises, SQL Server Management Studio v21, Visual Studio 2022, SSIS, SSDT, PowerShell.

Christiane N.

Management Consultant

Last position:

Management Consultant at Christiane Neher Management Consulting

Large Insurance Company – Consultant Wiesbaden: Consulting support for the introduction of an integrated planning and performance management framework (operational, financial, customer) to enhance customer-centric transparency, decision-making quality, and steering capabilities across all lines of business within an insurance organization:

Analysis of existing processes, reports, KPIs, and KPI calculation methodologies
Design and introduction of new, standardized customer KPIs (gross/net), as well as key steering metrics with consistent linkage across all lines of business
Recalculation, validation, and plausibility checks of KPIs based on existing and newly integrated data sources
Conceptual support for the development of an integrated reporting and performance management setup
Execution of customer insights analyses to identify patterns and anomalies within customer data clusters

Large retail company – Consultant in Karlsruhe: Advisory services for the setup and step-by-step implementation of an internationally deployable RELEX solution in the supply chain management environment:

Advising overall and sub-project management on methodology, project setup and steering (e.g. agile approach, Jira configuration, RELEX phases, Jira Structure PPM)
Strategic-operational consulting for the introduction of RELEX including best practices
Support in defining overarching goals and requirements (2-year target picture)
Guidance in scoping a relevant supply chain network segment for the project
Development of a roadmap for iterative, incremental RELEX setup and rollout
Assessment of project dependencies (interfaces, configurations, etc.)
Advice on prioritized implementation of business requirements and data interfaces
Support in test planning (data validation, system testing, UAT)
Consulting on internationalization, change management, training, and knowledge transfer
Stakeholder advisory and alignment activities between the client, implementation partner, and RELEX

Insurance company – Management Consultant in Munich: Analysis, consulting and support for the optimization of a large-scale business and IT transformation. Focus on strategically important programs and modernization projects in the area of Managed Services Operations and processes:

Review of project plans and deliverables; analysis of programs and projects (e.g. cloud approach, process standardization, system integration, roadmaps)
Identification of technical, functional and personnel risks and challenges; development of content-related measures and alternative solutions
Proposal of quality improvements for program and modernization efforts
Sparring partner and professional, technical, structural and organizational consulting for project and program management

Large retail group – Management Consultant & Stream Lead in Cologne: Consulting, process, project and product management for the introduction and implementation of a large strategic program in the field of advanced analytics, assortment and space management:

Setup, test and rollout of a new space planning, automation and optimization product based on the existing cluster-based merchandising approach
Definition and setup of new processes and transformation and change management measures for the new store-specific merchandising approach
Collaboration with Advanced Analytics and IT (internal and external) for software implementations, automations, extensions and interfaces
MVP approach and piloting in phases with gradual rollout (pilot with 80 stores, region with 500 stores, national level with 4000 stores)

Large retail company – Agile Coach & Change Agent in Cologne: Agile coach, OKR master and facilitator for the introduction of the OKR approach in a large strategic digitization program for retail stores:

Coaching of the core team with topic managers and team leads
Introduction to the OKR topic and setup of the OKR cycle
Establishment of the OKR approach in teams and on a cross-team level

Delivery and logistics company – Management Consultant in United Kingdom: Consulting and coaching in the restructuring of the Data Analytics department:

Analysis of current challenges
Definition of overarching goals
Development of a proposal for a new team structure
Identification of required competencies, skills and responsibilities
Advisory and alignment on communication and change management strategy

Harald L.