Andreas Bode - Oracle Applications DBA

Recommended expert

Bielefeld, Germany

Experience

Sep 2021 - Mar 2025

3 years 7 months

Leipzig, Germany

Oracle Applications DBA

Pyur

EBS 12.1 to 12.2.11 upgrade (DB 12 to 19)
Cloning process automation
HTTPS migration
Performance analysis and performance tuning
Error analysis
Cloning
Patching
Backup and recovery concept analysis and evaluation
Disaster recovery tests

Sep 2020 - Feb 2021

6 months

Bremen, Germany

Oracle Applications DBA

Hofmeister&Meincke

Oracle Applications R12 RAC
Performance analysis, troubleshooting
Customization analysis and adjustments
Architecture adjustments

Jun 2015 - May 2020

5 years

Hanover, Germany

Oracle Applications DBA

TUI Infotec GmbH

Support for various Oracle E-Business Suite instances up to 5TB
Upgrades of various Oracle Applications instances
AIX to Linux migration
Troubleshooting, bugfixing, 2nd level support
AIX, Linux, Solaris
Performance analysis and performance tuning
Automation of administrative processes

Jan 2014 - Present

12 years 1 month

Hanover, Germany

Oracle DBA/Subproject Lead

Oberfinanzdirektion Niedersachsen

Inventory of existing systems
Development of proposals for standardization and automation
Introduction of standards and automations
Performance analysis and performance tuning
Upgrades / patches / migrations
Development of backup and recovery concept
Oracle APEX installation with Tomcat and single sign-on
APEX architecture design
Disaster recovery tests

Jun 2012 - Mar 2013

10 months

Cologne, Germany

Oracle Applications DBA – Linux/AIX to VM Linux migration

Duales System Deutschland

Oracle Applications R12.1.1 to R12.1.3 upgrade
DB10.2 to 11.2 upgrade
Linux on VMware
Performance analysis and performance tuning
AIX to Linux migration
Data center migration
BI Publisher installations
Data synchronization optimization

Jul 2011 - Dec 2013

2 years 6 months

Hanover, Germany

Oracle DBA

Hewlett-Packard GmbH

Development of various programs in Shell, Perl, and PL/SQL
Troubleshooting, bug fixing, 2nd and 3rd level support for >1000 instances
AIX, Linux, Solaris, Windows
Performance analysis and tuning
Upgrades / patches / migrations
Automated enforcement of company standards
Data Guard
Backup and recovery

Nov 2010 - Nov 2010

1 month

Oracle Applications

Neusta Enterprise Services GmbH

Setup of an R12 Vision system on OEL 5 / VMware ESX

Oct 2010 - Oct 2010

1 month

Frankfurt, Germany

Oracle Applications DBA Training

Apps Associates

On-the-job training for 2 customer employees
Analysis of various issues and bugs in Oracle Applications R12 systems

Sep 2010 - Oct 2010

2 months

Cologne, Germany

Oracle Applications DBA

Interseroh Dienstleistungs GmbH

Performance tuning of reports and instances
Performance tuning of the database
Optimization of the cloning process
Bug fixing

Feb 2009 - Jun 2011

2 years 5 months

Hanover, Germany

Oracle DBA

E.ON IT GmbH

Development of various programs in Shell, Perl, and PL/SQL
Troubleshooting, bug fixing, 2nd and 3rd level support for >1000 instances
AIX, Linux, Solaris, Windows
Performance analysis and tuning
Upgrades / patches / migrations
Development of an automated database installation
Data Guard
Backup and recovery

Jul 2007 - Dec 2008

1 year 6 months

Hanover, Germany

Oracle Applications DBA

TUI InfoTec GmbH

Support for various Oracle Applications instances (11.5.9/11.5.10.2/R12) up to 2 TB
Development of various shell and SQL scripts
Performance analysis and tuning
Applying patches in Oracle Applications
UTF8 conversion of an OA 11.5.10.2 instance
Installing additional languages in multiple instances
Development of various tools in PL/SQL
Development of a performance monitoring system for Oracle databases
Consolidation of two Oracle Applications instances into one instance
Troubleshooting, 2nd and 3rd level support
AIX 5.3, Solaris 10, SuSE Linux Enterprise Server 9, Red Hat AS 3
Training internal staff in Unix, Oracle DBA, Oracle Applications, networking

Jan 2007 - Jun 2007

6 months

Hanover, Germany

Oracle DBA

E.ON IS GmbH

AIX 5.3, Solaris 9, Windows, SLES9/10, HP-UX
Oracle RDBMS 8i to 10g
Oracle RAC
Instance tuning, statement tuning
Performance analysis
Development of scripts in Shell and Perl
2nd level support
Upgrade, migration
Backup and recovery (RMAN)

May 2006 - Dec 2006

8 months

Münster, Germany

Oracle DBA Support

GAD eG – IT für Banken

SunOS 5.9
Oracle RDBMS 8i to 10g
Tuning and error correction
Recovery
Development of shell scripts and PL/SQL
2nd level support
Enterprise Manager Grid Control
Upgrade, migration
Materialized View Replication

Oct 2005 - Apr 2006

7 months

France

Lorem ipsum dolor sit amet

Timken Europe

Project management for Germany
Project planning and implementation
Update of the Oracle Applications 11.0.3 system
Creation of the instance concept
Cloning of the Oracle Applications 11.0.3 system
Creation of test scenarios and monitoring of the tests
Training and onboarding of the American administrators
Migration/upgrade of connected systems and interfaces
Migration of Oracle databases from 8i to 9i
Performance tuning

Jun 2005 - Jan 2006

8 months

Hanover, Germany

Lorem ipsum dolor sit amet

Kassenzahnärztliche Vereinigung Niedersachsen

Moving the 11.0.3 instance from SCO Unix to Windows
Upgrade of the 11.0.3 instance to 11.5.10
Training of internal administrators
Project planning and execution
Cloning of the production instance

Jun 2005 - Jul 2005

2 months

Paderborn, Germany

Lorem ipsum dolor sit amet

Wincor Nixdorf AG

Monitoring service requests with Oracle Support
Coordinating testers and reviewing test results
Performance tuning of various forms

Jan 2005 - Jan 2005

1 month

Hagen, Germany

Lorem ipsum dolor sit amet

Justizministerium NRW

Upgrading 3 Oracle Applications 11.5.9 instances to 11.5.10 on Linux

Jan 2004 - Dec 2010

7 years

Hagen, Germany

Administration and support for 3 Oracle Applications instances

Justizministerium NRW

Server monitoring and support

Jan 2004 - Dec 2005

2 years

Halle, Germany

Lorem ipsum dolor sit amet

Timken GmbH

Implementing shell scripts, PL/SQL programs, and procedures to collect and store information for SOX audits
Supporting auditors during the SOX audit

Jan 2004 - Dec 2005

2 years

Halle (Saale), Germany

Infrastructure Team Lead

Timken GmbH

Managing a team of 4 employees
Cost center responsibility
Areas of responsibility: Oracle databases, Oracle Applications 11.0.3, Windows Server, network infrastructure, EDI
Planning, coordinating, and controlling various infrastructure projects

Dec 2003 - Dec 2004

1 year 1 month

Hagen, Germany

Lorem ipsum dolor sit amet

Ministry of Justice North Rhine-Westphalia

Installation of Oracle Applications Release 11.5.9 on SUSE Linux Enterprise Server 8
Setup of 16 organizations
Creation of scripts for data migration
Development of interfaces to upstream systems
Development of an instance concept
Training of administrators

Sep 2003 - Sep 2003

1 month

Hanover, Germany

Lorem ipsum dolor sit amet

Lower Saxony Association of Statutory Health Insurance Dentists

Creation of an Oracle Applications test system (cloning) on SCO Unix
Performance tuning of the Oracle Applications production system

Apr 2003 - Jul 2003

4 months

Czech Republic

Lorem ipsum dolor sit amet

Ingersoll-Rand AG

Data separation and data reduction: creation of purge scripts
Moving a partial instance to a new AIX host
Training in English on AIX, Oracle databases and Oracle Applications administration

Jan 2003 - Present

23 years 1 month

Freelance work in Oracle databases and Oracle Applications

Andreas Bode Engineering Office

Execution of various projects (see project list)

Jan 2003 - Dec 2005

3 years

Halle (Saale), Germany

Oracle Database Administrator, Unix Administrator

Timken GmbH

Operation of an 11.0.3 Oracle Applications system on AIX 4.3.3
Various database upgrades
Server consolidations on AIX and Linux
System separation of an 11.0.3 instance
Tuning, performance management and monitoring of 5 Oracle databases and the AIX and Linux operating systems
Training of staff in English
Automation of administrative tasks through shell scripting
Development, implementation and control of Sarbanes-Oxley (SOX) processes
Support during Sarbanes-Oxley auditing

Jan 2002 - Dec 2003

2 years

Paderborn, Germany

Consultant for Oracle Databases and Oracle Applications

cqel GmbH

Installation, maintenance, and support of Oracle Applications systems on Windows2000, AIX, Solaris, and Linux
Programming a web-based time management system with PHP
Shell programming

Jan 2002 - Dec 2002

1 year

Halle, Germany

Lorem ipsum dolor sit amet

cqel GmbH

Participated in development using PHP and an Oracle8i database

Jan 1998 - Dec 2000

3 years

Paderborn, Germany

Student Assistant

Heinz Nixdorf Institut

Installation and administration of Silicon Graphics servers
Installation and administration of SUN servers
Support of the heterogeneous network

Skills

Oracle: Oracle Applications 11.0.3, 11i, R12.1, R12.2; Oracle Databases 7 Through 19; Tuning And Performance Management, Awr, Addr; Backup & Recovery; Dataguard
Hardware: Pc; Rs/6000; Routers, Switches
Operating Systems: Linux (Redhat, Suse, Oel); Unix (Aix, Solaris, Irix, Hp-ux); Windows
Programming Languages: Sql; Pl/sql; Perl; Shell Scripting; Awk
Networking: Ethernet; Isdn; Iso/osi; Lan; Routing; Smtp, Pop3, Imap4; Tcp/ip; Snmp; Fddi; Atm; Various Protocols And Services
Others: Sarbanes Oxley Auditing (Sox)