Adrian H.
Oracle DBA & Cloud Specialist
Experience
Nov 2021 - Present
4 years 2 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
- Creating and maintaining DR/HA (Disaster Recovery/High Availability) and backup and recovery policies and procedures (multi-region backup)
- Assistance with Oracle license selection, Enterprise -> Standard migration
- Monitoring of database instances
- Implementation and maintenance of database security (Wallet, SSL)
- Patch management and version control
- Automated installation and configuration of Oracle database with Terraform and Ansible
Sep 2015 - Jul 2016
11 monthsMigration of the existing data warehouse from HPUX/Oracle 10g to AWS Cloud
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 migrating shell scripts from HPUX to RHEL
- Setting up and configuring the APEX application server
- Support for database migration from 10g to 12c and APEX from version 3 to 5
- Feasibility study of using RDS instead of a dedicated EC2 instance
- Building a test and production environment
Apr 2015 - Present
10 years 9 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 View
- Performance and tuning using 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 system
Dataport AÖR
- Setting up and supporting the technical operations
- Operation and maintenance of the application and database layer in collaboration with the vendor
- Administration of SUSE Linux Enterprise Servers and Oracle databases
- Diagnostics and tuning for performance optimization
- Quality assurance of backup routines with RMAN and EMC Data Domain
- Supplementing general documentation with client-specific details
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: upgrade, patching, migration
- Support and troubleshooting of productive 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: design, support and monitoring
- 2nd/3rd level technical helpdesk
- Training of operations staff: Oracle training on database specifics, monitoring & housekeeping tasks
Feb 2009 - Jul 2009
6 monthsHamburg, Germany
Oracle Database Administrator (DBA), Trainer, Technical Team Lead
Gesamtverband der Deutschen Versicherungswirtschaft e.V.
- System monitoring and maintenance of Oracle instances in RAC environment
- Design, installation and configuration of test environment (Oracle RAC with Data Guard in VMware)
- Technical team leadership, documentation and knowledge transfer
- Training of operations 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 of 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
- Support for 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
- Support for developers and customer consultants on 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
- Designing and developing technical tools for SAP and SIRAX administration
- Onboarding new customers by setting up SAP systems for SIRAX
- Setting up SAP authorizations, transport management, and interface management
- Automating SAP transports
- SAP patch and release management: planning and executing support packages
- Documenting activities and results
Nov 2006 - Mar 2007
5 monthsHamburg, Germany
Oracle Database Administrator (DBA) and Developer
Hamburger Sparkasse (HASPA)
- Database model migration from DB2 to Oracle 10g: SQL, PL/SQL, triggers, referential integrity
- Data migration from DB2 (z/OS) to Oracle (Solaris) using SQL*Loader
- Automating the migration process with shell and Perl scripting
- Administering and configuring 12 Oracle databases in 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)
- Planning and installation of Oracle 9i databases
- Configuration of 11 Oracle instances including Sun Cluster
- Performance tuning of applications and Oracle databases: partitioning, ER model analysis, SQL tracing
- Benchmarking on development and production platforms
- Data migration of 2 TB from London to Frankfurt
Nov 2005 - Mar 2006
5 monthsKöthen (Anhalt), Germany
SAP Basis Administrator
Marktplatz Services GmbH
- Planning and execution of support packages and industry solutions (patch and release management)
- Performance and error analysis as well as tuning in the SAP and database environment
- Troubleshooting in DB and SAP R/3 systems
- Performance optimization (SQL, parameter configuration) 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
- Design and planning of system architectures; proactive and reactive system management
- Definition of SLAs and ensuring 24x7 availability
- Coordination of 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 OS components
- System maintenance, monitoring, and performance tuning
- Supporting production operations, data warehousing & 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 cluster environment
- Administration, backup, and recovery of Oracle databases
- Project management and collaboration with developer teams on database system design
Feb 2001 - Aug 2001
7 monthsHanover, Germany
Oracle Database Administrator (DBA) and Developer
BizTec AG
- Production support management for database servers
- Collaboration with software developers and technology managers for high-quality solutions
- Installation and monitoring of INTERSHOP Enfinity and Oracle databases
- Application analysis and tuning through SQL optimization
Sep 1997 - Jan 2001
3 years 5 monthsBratislava, Slovakia
IT Project Manager, Developer/Analyst
Kameron GmbH
- Coordination and control 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
Diploma in Engineering · Computer Science and Software Engineering · Bratislava, Slovakia
Oct 1990 - Jun 1994
Konstantinova High School
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.