Oracle DB Migration from QNAP (NAS) to HITACHI (SAN) Storage

• Participated in team projects, demonstrating an ability to work collaboratively and effectively.
• 3rd Level Oracle 12C Support
• DBVISIT Standby for Oracle SE Disaster Recovery
• Oracle DB Migration from QNAP (NAS) to HITACHI (SAN) Storage
• Oracle Software Updates (Oracle Patches)

3rd Level Oracle 19C Support

• Performed BCS Control System DB Installation / Administration
• Reviewed Performance metrics, identify Performance bottlenecks by using Cloud Control and SQL-Tuning
• Designed and Implemented GoldenGate 19C Replication

• Developed strong communication and organizational skills through working on group projects.
• ITSM Incident-Change-Service Request-Problem Management (HP Service Manager)
• Backup-Recovery and Duplicate Databases (RMAN, IBM TSM)
• Migration/Export/Import via RMAN, Data Pump
• Oracle Software Updates (Oracle Patches)
• Performance Monitoring with Cloud Control
• More than 400 Oracle 12.1-12.2 Databases with Oracle Automatic Storage Management (ASM) Oracle Real Application Cluster (RAC), DG

Oracle Database Support

• Aufbau einer Testinstallation (ESX ? SLES ? Oracle ? JBOSS 7) 
• Aufbau einer Musterinstallation für die Abnahmetests durch Auftraggeber 
• Anpassung Dokumentation und Softwarepakete und Übergabe für den produktiven Einsatz 
• Fehlersuche in Oracle-Abläufen mittels TOAD, SQL Developer 
• Fehlersuche in DB-Inhalten z. B. mittels TOAD, SQL Developer 
• Installation von Linux-Paketen mittels RPM, CA_DSM 
• Fehlersuche bei fehlgeschlagenen Installationen

• DB Performance Monitoring (via Cloud Control, TOAD, UC4)
• Developed DB Backup ? Recovery Concepts
• Designed and implemented Transparent Data Encryption (TDE) on Oracle databases.

Created Ansible Playbooks for Oracle 11G-12C (Single and RAC)

• Created Ansible Playbooks for Oracle 11G-12C (Single and RAC) using Ansible, GIT and Vagrant
• Implemented Ansible Vault Data Encryption

Upgraded the Central DWH from 11G to 12C on Windows

• Upgraded the Central DWH Oracle RAC DB (Grid & RAC on Windows 2008) from 11G to 12C
• Data Migration (Extrakt, Transformation, Load)
• Oracle Patch and Release Management
• Oracle SQL / PL-SQL, TOAD, SQL-Developer, Oracle APEX, RMAN
• Enterprise Manager Cloud Control, Oracle DWH Builder
• Windows 2008R2, Solaris, RHEL 7.3
• Ansible Playbooks, Oracle 11G/12C RAC, YAML, GIT, Vagrant

Administration of the Oracle Database HA/DR Environment

• Administration of the Oracle DB HA/DR Environment (Oracle RAC 12c + DataGuard 12c + EM13c)
• Executed RAC Failover/Switchover using EM13C
• Updated Enterprise Manager Cloud Control from 12c to 13c
• Developed User Guides

MS-SQL 2016 Installation and Administration

• Provided MS-SQL 2016 Administration
• HP 3par B6200/B6500 Storage Configuration and Administration

Oracle DB and Application Migration from HPUX to Linux

• Moved a 3.4TB database from a big to a little endian platform (HPUX -> OL5) both using ASM
• Performance Tuning of the Oracle-Databases

• Delivered services to customer locations within specific timeframes.
• Managed time efficiently in order to complete all tasks within deadlines.
• Oracle Databases Upgrades / Migration from Version 10 to Version 11G and Version 12c
• Provided development and Design assistance to Developers
• Created operating manuals
• Created Oracle Forms/ Report/ PL/SQL packages

Administration of the Oracle Databases

• Designed, implemented Transparent Data Encryption (TDE) on Oracle databases.
• Created Oracle DB Installation/Migrations scripts
• BMC Remedy Change Management und Incident Management
• Monitoring and optimization of DB operations in terms of performance and availability (11G and 12C)
• Oracle Patch & Release Management

Execute System Integration and Acceptance Tests

• Execute System Integration and Acceptance Tests
• Adaptation of documentation and software packages and transfer for productive use
• Troubleshooting Database contents, by using TOAD, SQL Developer
• Installation of Linux packages using RPM, CA_DSM
• Troubleshooting failed installations

• Developed strong communication and organizational skills through working on group projects.
• Troubleshooting and problem solving of the Oracle databases and the Application Systems
• Oracle-Database Installation, Configuration und Administration (Single, Dataguard, RAC)
• Oracle Advanced Replication
• Netapp FAS Shared Storage Installation / Configuration / Admin
• Support for the configuration settings of Oracle databases on the ESX vSphere platform

• Learned and adapted quickly to new technology and software applications.
• Remote Solution of Customer Tech Problems (Oracle, Windows, Linux, XP and Win7 clients, Citrix, Backup/Recovery, Voice Recognition)
• Level 3 Remote Technical Support for HCIT Field Engineers
• Troubleshooting and sustainable problem solving in the environment of databases and the application systems
• Performance tuning and monitoring of Oracle databases
• Migration of Oracle Databases under Windows 2003/2008

• Oracle Database 9i & 10G Administration (Single, Dataguard)
• Logical and Physical DB Backup and Restore ? Recover using Rman, IBM TSM, Dataguard, Export/Import
• ITSM BMC Remedy Change and Incident Management
• Develop ETL with dem Oracle Warehouse Builder 10 (OWB)

• Administration of Production Line IT infrastructure: physical and virtual servers, Line Controllers, SPS, Bar code Readers, Printers, Client terminals
• Administration and monitoring of Oracle and MS-SQL databases and their interfaces on HP-UX and Microsoft platforms
• Update & migration of Oracle databases under HP-UX and Windows
• Check that the data backup and recovery plans (OS, Oracle) are available and operational.
• Installation, configuration and administration of VISIPRISE Manufacturing ERP (SAP ME)
• Monitoring of HP-UX 9000 and also Windows (2000 and 2003) and Linux servers and workstations in 24*7 production environment with more than 30 servers and 100 PCs.