Adrian H.
Oracle DBA & Cloud Specialist
Experience
Nov 2021 - Present
3 years 11 monthsInterim Consultant for Oracle Database Migrations to AWS Cloud
Bank Deutsches Kraftfahrzeuggewerbe GmbH (BDK)
- Migration of Oracle databases from on-premises to AWS Cloud
- Support for technical Oracle solutions and cloud database infrastructures (IaaS and PaaS), RDS vs. EC2, sizing for performance
- Establishing and maintaining DR/HA (Disaster Recovery/High Availability) and backup and recovery policies and procedures (multi-region backup)
- Support for Oracle license selection, Enterprise -> Standard migration
- Monitoring of database instances
- Implementing and maintaining database security (wallet, SSL)
- Patch management and version control
- Automated installation and configuration of Oracle database using Terraform and Ansible
Sep 2015 - Jul 2016
11 monthsMigration of existing data warehouse from HP-UX/Oracle 10g to AWS
Johnson & Johnson MEDICAL GmbH
- Installation and configuration of the database including parameter optimization on AWS EC2 instance; backup configuration with RMAN and Amazon S3
- Support in rewriting shell scripts from HP-UX to RHEL
- Setting up and configuring the APEX application server
- Support for migrating the database from 10g to 12c and APEX from version 3 to 5
- Feasibility study of using RDS instead of a dedicated EC2 instance
- Setting up test and production environments
Apr 2015 - Present
10 years 6 monthsOracle Database Administrator (DBA) in the field of biometric identification
DERMALOG Identification Systems GmbH
- Migration and upgrade of very large databases (VLDB) using Oracle Standby databases/Data Guard
- Bidirectional data replication with Oracle GoldenGate; Oracle Advanced Replication/materialized views
- Performance and tuning with Statspack, AWR, deadlock analysis, Snapper
- Installation and configuration of Oracle Clusterware (Oracle RAC)
- Analysis and recovery of corrupt database blocks
Apr 2015 - Mar 2017
2 yearsOracle Performance & Tuning for Output & Document Management (O&DM) system
Schenker AG
- Database performance analysis, testing, and implementation using Oracle Statspack, SQL Explain Plan, TKPROF, SQL tracing
- Implementation of partitioning
- SQL, PL/SQL, and shell scripting, as well as knowledge transfer
Nov 2012 - Dec 2014
2 years 2 monthsOracle database administration and Linux administration for the large-scale KoPers procedure
Dataport AÖR
- Establishing and supporting the technical operation of the process
- Operation and maintenance of the application and database layer in collaboration with the vendor
- Administration of SUSE Linux Enterprise Server and Oracle databases
- Diagnostics and tuning for performance optimization
- Quality assurance of backup routines with RMAN and EMC Data Domain
- Adding customer-specific details to the general documentation
Apr 2012 - Sep 2012
6 monthsHamburg, Germany
Oracle Database Administrator (DBA), Developer
GDV Dienstleistungs-GmbH & Co. KG
- Analysis of application availability and stability in the Oracle RAC environment
- Application adjustments for Oracle RAC: Distributed Workload Management, failover and load balancing, Fast Application Notification, Transparent Application Failover
- Disaster Recovery configuration with Oracle Data Guard
- Oracle PL/SQL and SQL performance tuning
- Support for developers in application debugging, redesign, and performance tuning
- Design and implementation of ETL processes (Data Warehouse)
- Administration and configuration of Oracle databases in development and integration
- Database and system monitoring with Nagios/OpenNMS
Aug 2011 - Mar 2012
8 monthsHamburg, Germany
Oracle Performance Specialist and Oracle DBA
Otto (GmbH & Co KG)
- Operational management of e-commerce sites ([link]) and related systems
- Oracle performance tuning: analysis, testing, and implementation; PL/SQL and SQL performance tuning; AWR analysis
- Configuration of Oracle database instances, software and hardware sizing
- Process control and automation; monitoring and error detection
- Support for Oracle DBAs in 3rd level support
- Project support in analysis and design
- Documentation and knowledge transfer
Nov 2010 - Jun 2011
8 monthsHamburg, Germany
SAP Basis Administrator, Oracle Database Administrator (DBA)
Stadtreinigung Hamburg
- Operation and maintenance of SAP systems (NetWeaver 7.0) on Linux (IS-Waste, SD, FI, MM, PM, CO)
- Maintenance of central user management in SAP; SAP job control (Batchman)
- Transport management and homogeneous system copies
- Execution of SAP and Oracle migrations, upgrades, and software rollouts
- SAP interface management (BatchInput, RFC, BAPI)
- Oracle database administration: upgrades, patches, migrations
- Support and troubleshooting of production Oracle databases for SAP and Data Warehouse
- System monitoring with Nagios
- Backup and recovery for SAP and Oracle
Aug 2009 - Dec 2009
5 monthsHamburg, Germany
Oracle Database Administration and Web Application Support
GDV Dienstleistungs-GmbH & Co. KG; eSailors IT Solutions GmbH
- System monitoring and maintenance of Oracle instances
- Oracle PL/SQL and SQL performance tuning; AWR analysis
- RMAN database backup: planning, support, and monitoring
- 2nd/3rd level technical helpdesk
- Training of operational staff: Oracle training on database-specific, monitoring, and housekeeping tasks
Feb 2009 - Jul 2009
6 monthsHamburg, Germany
Oracle Database Administrator (DBA), Trainer, Team Lead
Gesamtverband der Deutschen Versicherungswirtschaft e.V.
- System monitoring and maintenance of Oracle instances in a RAC environment
- Design, installation, and configuration of test environments (Oracle RAC with Data Guard on VMware)
- Leading the team, documentation, and knowledge transfer
- Training of operational staff: database administrators
- Leading a small team of Oracle DBAs
- Disaster recovery scenario with Oracle Data Guard
- Oracle performance tuning: analysis, testing, and implementation
Feb 2008 - Jul 2008
6 monthsHamburg, Germany
Oracle Database Administrator, System Administrator, System Architect
GDV Dienstleistungs-GmbH & Co. KG; Easynet GmbH
- Configuration, installation and implementation of Oracle MAA: RAC with Data Guard technology across two sites
- Implementation of dual-site Oracle RAC cluster for disaster recovery
- Implementation of high availability components: multipath I/O, NIC bonding, ASM, OCFS2, failover and load balancing
- Monitoring Oracle instances and components using SNMP
- Proof of concept, proof of technology and documentation
Nov 2007 - Jan 2008
3 monthsHamburg, Germany
Oracle Database Administrator (DBA), Developer
Implico GmbH
- Supported migration of OpenTAS 4.0 from Oracle 9iR2 to 10gR2: planning, testing and implementation
- Configuration of Oracle 10gR2 instances: software sizing, init parameters, maintenance tasks, batch processing
- Database model and view redesign: RBO to CBO migration
- Supported developers and client consultants with debugging, redesigning and tuning
- Documentation, training and knowledge transfer
May 2007 - Sep 2007
5 monthsNorderstedt, Germany
SAP Basis Administrator, Oracle Database Administrator (DBA), SIRAX Administrator
Lufthansa Systems AS GmbH
- Designed and developed technical tools for SAP and SIRAX administration
- Onboarded new clients by setting up SAP systems for SIRAX
- Set up SAP authorizations, transport management, interface management
- Automated SAP transports
- SAP patch and release management: planning and applying support packages
- Documented tasks and results
Nov 2006 - Mar 2007
5 monthsHamburg, Germany
Oracle Database Administrator (DBA) and Developer
Hamburger Sparkasse (HASPA)
- Migrated database model from DB2 to Oracle 10g: SQL, PL/SQL, triggers, referential integrity
- Migrated data from DB2 (z/OS) to Oracle (Solaris) using SQL*Loader
- Automated migration process with shell and Perl scripting
- Administered and configured 12 Oracle databases across development, integration and production
- Performance tuning of migrated applications and Oracle databases
May 2006 - Oct 2006
6 monthsCologne, Germany
Oracle Database Administrator (DBA), Solaris System Administrator
02 (Germany) GmbH & Co. (O3SIS Information Technology AG)
- Planned and installed Oracle 9i databases
- Configured 11 Oracle instances including Sun Cluster
- Performance tuning of applications and Oracle databases: partitioning, ER model analysis, SQL tracing
- Benchmarked on development and production platforms
- Migrated 2 TB of data from London to Frankfurt
Nov 2005 - Mar 2006
5 monthsKöthen (Anhalt), Germany
SAP Basis Administrator
Marktplatz Services GmbH
- Planning and implementing support packages and industry solutions (patch and release management)
- Analyzing performance and errors, and tuning in the SAP and database environment
- Troubleshooting in the DB and SAP R/3 system
- Optimizing performance (SQL, parameter settings) of Oracle and SAP R/3 Basis
- Backup and disaster recovery for SAP systems (Oracle Data Guard)
Apr 2004 - Oct 2005
1 year 7 monthsMunich, Germany
ITO/ITI Manager, Oracle DBA, SAP R/3 Basis Administrator
Mercateo AG
- Concept and design of system architectures; proactive and reactive system management
- Defining SLAs and ensuring 24x7 availability
- Coordinating configuration management for development, test, and production environments
- Leading a small team of IT specialists
- Reviewing security concepts
- Creating and managing the IT budget
Mar 2002 - Sep 2002
7 monthsHamburg, Germany
Oracle DBA & Unix Administrator
Portal Software (Hamburg) GmbH
- Planning, design, development, and operation of Oracle databases
- Creating disaster recovery and security concepts for databases and operating system components
- System maintenance, monitoring, and performance tuning
- Supporting production operations, data warehousing, and data mining
Sep 2001 - Feb 2002
6 monthsHamburg, Germany
Oracle Administrator (DBA) & Designer, Solaris and Linux Administrator
Nikotel Deutschland AG
- Designing and developing complex database configurations in a clustered environment
- Administering, backing up, and restoring Oracle databases
- Leading projects and collaborating with development teams on database system design
Feb 2001 - Aug 2001
7 monthsHanover, Germany
Oracle Database Administrator (DBA) and Developer
BizTec AG
- Managing production support for database servers
- Collaborating with software developers and technology managers for high-quality solutions
- Installing and monitoring INTERSHOP Enfinity and Oracle databases
- Analyzing and tuning applications through SQL optimization
Sep 1997 - Jan 2001
3 years 5 monthsBratislava, Slovakia
IT Project Manager, Developer/Analyst
Kameron GmbH
- Coordination and oversight of project tasks for information systems
- Assignment of tasks and management of five developers
- Responsible for software design, simulation, modification, testing and documentation throughout the entire project
Summary
- Oracle Database Administration (DBA) - 8i to 23ai
- Cloud Database Expert (AWS, Oracle Cloud, Azure)
- Linux/Unix System Administration
- Oracle Performance & Tuning, Migration, Replication
- High Availability, Data Guard, Cluster (RAC)
Languages
Slovak
NativeCzech
AdvancedGerman
AdvancedEnglish
AdvancedEducation
Oct 1994 - Jun 1999
University of Economics Bratislava
Dipl. Ing. · Computer Science and Software Engineering · Bratislava, Slovakia
Oct 1990 - Jun 1994
Gymnasium Konstantinova
Prešov, Slovakia
Certifications & licenses
VMware Certified Associate - Data Center Virtualization
VMware
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle
Oracle DBA - Oracle Certified Professional (OCP)
Oracle
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.