Recommended expert

Adrian Hollay

Interim Consultant for Oracle Database Migrations to the AWS Cloud

Adrian Hollay
Wedel, Germany

Experience

Nov 2021 - Present
4 years 4 months

Interim Consultant for Oracle Database Migrations to the AWS Cloud

Bank Deutsches Kraftfahrzeuggewerbe GmbH

  • Migration of Oracle databases from on-premise to the AWS Cloud
  • Support for technical Oracle solutions and cloud database infrastructures (IaaS and PaaS) RDS vs. EC2, sizing for performance
  • Creation and maintenance of 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 database instances
  • Implementation and maintenance of database security (wallet, SSL)
  • Patch management and version control
  • Automated installation and configuration of Oracle databases using Terraform and Ansible
Sep 2015 - Jul 2016
11 months

Migration of existing data warehouse from HPUX/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
  • Adaptation of shell scripts from HPUX 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
  • Evaluation of using RDS instead of a dedicated EC2 instance
  • Building test and production environments
Apr 2015 - Present
10 years 11 months

Oracle Database Administrator (DBA) in the field of biometric identification

DERMALOG Identification Systems GmbH

  • Migration and upgrade of very large databases (VLDB) with Oracle standby databases / Data Guard
  • Bidirectional data replication with Oracle GoldenGate; Oracle Advanced Replication / Materialized View
  • Performance & tuning with Statspack, AWR, deadlock analysis, Snapper
  • Installation and configuration of Oracle Clusterware (RAC)
  • Analysis and recovery of corrupt database blocks
Apr 2015 - Mar 2017
2 years

Oracle Performance & Tuning for Output & Document Management System

Schenker AG

  • Database performance analysis, testing, and implementation with Oracle Statspack, SQL Explain Plan, TKPROF, SQL tracing
  • Introduction of partitioning
  • SQL, PL/SQL, and shell scripting and knowledge transfer
Nov 2012 - Dec 2014
2 years 2 months

Oracle database administration and Linux administration for the large-scale procedure KoPers

Dataport AÖR

  • Setup and support of technical process operations
  • Operation and maintenance of the application and database layer in cooperation with the vendor
  • Administration of SUSE Linux Enterprise Server and Oracle databases
  • Diagnostics and tuning for Oracle database performance
  • Quality assurance of backup routines with RMAN and EMC Data Domain
  • Adding customer-specific details to vendor documentation
Apr 2012 - Sep 2012
6 months

Oracle Database Administrator, Developer

GDV Dienstleistungs-GmbH & Co. KG

  • Analysis of the application's availability and stability in the Oracle RAC environment
  • Application redesign for Oracle RAC: distributed workload management, failover, load balancing, fast application notification, transparent application failover
  • Disaster recovery configuration with Oracle Data Guard
  • Oracle PL/SQL and SQL performance & tuning
  • Supporting developers with debugging, redesign, and performance tuning
  • Designing and implementing 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 months

Oracle Performance Specialist and Oracle DBA

Otto (GmbH & Co KG)

  • Operational management of e-commerce sites and related systems
  • Oracle performance & tuning: analysis, testing and implementation, PL/SQL and SQL optimization, AWR analysis
  • Configuration of Oracle database instances as well as software and hardware sizing
  • Process control and automation; monitoring and error detection
  • 3rd level support for Oracle DBAs
  • Project support in analysis and design
  • Documentation and knowledge transfer
Nov 2010 - Jun 2011
8 months

SAP Basis Administrator, Oracle Database Administrator (DBA)

Stadtreinigung Hamburg

  • Operating and maintaining SAP systems (NetWeaver 7.0) on Linux
  • Central user management and SAP job scheduling
  • Transport management/transport controlling and homogeneous system copies
  • Performing SAP and Oracle migrations, upgrades, and software rollouts
  • SAP interface administration (BatchInput, RFC, BAPI)
  • Oracle database administration: upgrades, patches, migration
  • Support and troubleshooting of production Oracle databases for SAP and DWH
  • System monitoring with Nagios
  • Backup and recovery (SAP and Oracle)
Aug 2009 - Dec 2009
5 months

Oracle database administration and support for highly available web applications

GDV Dienstleistungs-GmbH & Co. KG; eSailors IT Solutions GmbH

  • System monitoring and maintenance of Oracle instances
  • PL/SQL and SQL performance & tuning, AWR analysis
  • RMAN database backup: planning, 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 months

Oracle Database Administrator, Trainer, Team Lead

Gesamtverband der Deutschen Versicherungswirtschaft e.V.

  • System monitoring and maintenance of Oracle instances in an RAC environment
  • Designing, installing and configuring test environments (RAC with Data Guard on VMware)
  • Functional team leadership, documentation and knowledge transfer
  • Training of operations staff (DBAs)
  • Leading a small Oracle DBA team
  • Disaster recovery scenario with Oracle Data Guard
  • Oracle performance & tuning: analysis, testing and implementation
Feb 2008 - Jul 2008
6 months

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) at two sites
  • Implementation of dual-site RAC clusters for disaster recovery
  • High-availability components: multipath I/O, NIC bonding, ASM, OCFS2, failover, and load balancing
  • Monitoring using SNMP
  • Proof of concept, proof of technology, and documentation
Nov 2007 - Jan 2008
3 months

Oracle Database Administrator, Developer

Implico GmbH

  • Support for the migration of OpenTAS 4.0 from Oracle 9iR2 to 10gR2: concept, testing, implementation
  • Configuration of Oracle 10gR2 instances: software sizing, init parameters, maintenance tasks, batch processing
  • Database model and view redesign (RBO → CBO)
  • Support for developers and client consultants in debugging, redesigning, and tuning
  • Documentation, training, and knowledge transfer
May 2007 - Sep 2007
5 months

SAP Basis Administrator, Oracle DBA, SIRAX Administrator

Lufthansa Systems AS GmbH

  • Development of technical tools for SAP and SIRAX administration
  • Support for new clients in setting up SAP systems for SIRAX
  • SAP authorizations, transport management, interface management
  • Automation of SAP transports
  • SAP patch and release management
  • Detailed documentation of activities
Nov 2006 - Mar 2007
5 months

Oracle Database Administrator and Developer

Hamburger Sparkasse (HASPA)

  • Migration from DB2 (z/OS) to Oracle 10g: data model, SQL, PL/SQL, triggers, referential integrity
  • Data migration using SQL*Loader and automation via shell and Perl scripting
  • Administration and configuration of 12 Oracle databases in development, integration, and production
  • Performance and tuning of migrated applications and databases
May 2006 - Oct 2006
6 months

Oracle Database Administrator, Solaris System Administrator

02 (Germany) GmbH & Co.

  • Planning (high-level and detailed design) and installation of Oracle 9i databases
  • Configuration of 11 Oracle instances including Sun Cluster
  • Performance and tuning: partitioning, ER analysis, SQL tracing
  • Benchmarking on development and production platforms
  • Data migration of 2 TB from London to Frankfurt
Nov 2005 - Mar 2006
5 months

SAP Basis Administrator

Marktplatz Services GmbH

  • Planning and execution of support packages and industry solutions (patch and release management)
  • Performance and error analyses as well as tuning in the SAP and database environment
  • Troubleshooting and error analysis of DB and SAP R/3 systems
  • Performance optimization (SQL, parameterization) of Oracle and SAP R/3 basis
  • Backup of SAP systems and disaster recovery (Oracle Data Guard)
Apr 2004 - Oct 2005
1 year 7 months

ITO/ITI Head, Oracle DBA, SAP R/3 Basis Administrator

Mercateo AG

  • Planning and design of system architectures; proactive and reactive system management
  • Definition of SLAs and ensuring 24x7 system availability according to the SLA
  • Coordination of configuration management for development, test, and production environments
  • Leadership of a small team of IT specialists
  • Review of the security concept
  • Creation and management of the IT budget
Mar 2002 - Sep 2002
7 months

Oracle DBA & Unix Administrator

Portal Software (Hamburg) GmbH

  • Planning, design, and operation of Oracle database administration
  • Development and implementation of disaster recovery and security concepts for database and OS components
  • System maintenance (updates, upgrades, optimization), monitoring, and performance tuning
  • Support of production operations, data warehousing, and data mining
Sep 2001 - Feb 2002
6 months

Oracle Administrator & Designer, Solaris and Linux Administrator

Nikotel Deutschland AG

  • Design and development of complex database configurations for performance and redundancy in a cluster environment
  • Administration, backup, and recovery of Oracle databases
  • Project management and close collaboration with development teams for new database system design
Feb 2001 - Aug 2001
7 months

Oracle Database Administrator and Developer

BizTec AG

  • Production Support Management for database servers
  • Collaboration with developers and technology managers for tailored solutions
  • Installation and monitoring of INTERSHOP Enfinity and Oracle databases
  • Analysis and tuning of applications through SQL optimization (stored procedures, triggers)
Sep 1997 - Jan 2001
3 years 5 months

IT Project Manager, Developer/Analyst

Kameron GmbH

  • Coordination and oversight of project tasks for information systems
  • Task assignment and management of five developers
  • Software design, simulation, modification, testing, and documentation throughout the entire project

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Information Technology (18.5 years), Banking and Finance (4.5 years), Government and Administration (2.5 years), Transportation (2 years), Insurance (1.5 years), and Healthcare (1 year).

Information Technology
Banking and Finance
Government and Administration
Transportation
Insurance
Healthcare

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (24 years), Operations (6.5 years), Project Management (4 years), Product Development (3.5 years), Business Intelligence (2 years), and Quality Assurance (2 years).

Information Technology
Operations
Project Management
Product Development
Business Intelligence
Quality Assurance

Skills

  • Oracle Database Administrator / Specialist (Dba)

  • Cloud Database Expert (Aws, Oracle, Azure)

  • Linux/unix System Administration

  • Oracle Performance & Tuning; Migration; Replication

  • High Availability, Data Guard, Cluster (Rac)

  • Oracle: Expert Knowledge: Oracle 8i - 23c, Many Years Of Oracle Dba Experience, Ocp (Certificate), Sql, Pl/sql Development, Performance & Tuning, Sql Optimization, Rac, Data Guard, Multitenant Db

  • Ms Sql Server: Administrator - Very Good Knowledge, Ms Sql 7.0 - 2022

  • Postgresql, Mysql/mariadb: Administrator - Very Good Knowledge

  • Amazon Relational Database Service (Rds): Postgresql, Mariadb, Mysql, Aurora

  • Oracle Cloud Infrastructure (Oci): Autonomous Database Specialist (Certificate)

  • Linux: Redhat, Oracle Linux, Centos, Opensuse 6.2-15, Sles 8-15

  • Unix: Solaris 2.6-11

  • Windows: Windows Nt/2000/2003/2008/2012/2016/2019/2022 As Administrator

  • Ibm Aix 4.3.3/5l 5.2/7.3, Hp-ux: Good Knowledge

  • Git: Github, Gitlab, Bitbucket

  • Virtualization: Vmware, Kvm, Oracle Vm, Docker, Virtualbox, Vagrant

  • Config Management: Ansible, Puppet, Cloudformation, Chef, Packer

  • Infrastructure As Code (Iac): Terraform

  • Logging & Monitoring: Check Mk, Nagios/icinga, Grafana, Splunk

  • Quality/testing: Apache Jmeter

  • Jira, Confluence, Slack

  • Build: Jenkins, Maven, Travis Ci

  • Oracle Tools: Sqlplus, Sql*loader, Awr, Statspack, Rman, Logminer Etc.

  • Dell (Quest) Toad, Sql Navigator, Spotlight, Pl/sql Developer, Oracle Sql Developer

  • Oracle Enterprise Manager Cloud Control, Oracle Enterprise Manager Grid Control

  • Oracle Advanced Queuing, Oracle Streams, Goldengate, Oracle Advanced Replication

  • Oracle Audit Trail, Oracle Unified Auditing

  • Oracle Application Express (Apex)

  • Oracle Business Intelligence, Warehousebuilder, Discoverer, Businessobjects, Cognos

  • Agile Software Development

  • Scrum

  • Rad (Rapid Application Development)

  • Hci: Dell Emc Vxrail

  • Nutanix: Nx Nodes, Nutanix On Hpe Platform

  • Oda - Oracle Database Appliances – X3-2, X4-2, X5-2, X8-2, X9-2 (S, M And Ha Models)

  • Hpe: Hp Proliant Server, Hp Alphaserver Systems

  • Ibm: Xseries, Eservers, Mainframes, Mainframe

  • Sun: Sun Enterprise Servers, Sun Fire Servers

Languages

Slovak
Native
German
Advanced
English
Advanced

Education

Oct 1994 - Jun 1999

University of Economics Bratislava

Dipl. Ing. in Computer Science and Software Engineering, Faculty of Economics · Computer Science and Software Engineering · Bratislava, Slovakia

Oct 1990 - Jun 1994

Konstantinova High School

Prešov, Slovakia

Certifications & licenses

Oracle Autonomous Database Cloud 2021 Certified Specialist

Oracle Certified Professional - Database Administrator

Profile

Created
Last Update
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Adrian based?

Adrian is based in Wedel, Germany.

What languages does Adrian speak?

Adrian speaks the following languages: Slovak (Native), German (Advanced), English (Advanced).

How many years of experience does Adrian have?

Adrian has at least 24 years of experience. During this time, Adrian has worked in at least 19 different roles and for 21 different companies. The average length of individual experience is 1 year and 2 months. Note that Adrian may not have shared all experience and actually has more experience.

What roles would Adrian be best suited for?

Based on recent experience, Adrian would be well-suited for roles such as: Interim Consultant for Oracle Database Migrations to the AWS Cloud, Migration of existing data warehouse from HPUX/Oracle 10g to AWS, Oracle Database Administrator (DBA) in the field of biometric identification.

What is Adrian's latest experience?

Adrian's most recent position is Interim Consultant for Oracle Database Migrations to the AWS Cloud at Bank Deutsches Kraftfahrzeuggewerbe GmbH.

What companies has Adrian worked for in recent years?

In recent years, Adrian has worked for Bank Deutsches Kraftfahrzeuggewerbe GmbH and DERMALOG Identification Systems GmbH.

Which industries is Adrian most experienced in?

Adrian is most experienced in industries like Information Technology (IT), Banking and Finance, and Government and Public Administration. Adrian also has some experience in Transportation and Logistics, Insurance, and Healthcare.

Which business areas is Adrian most experienced in?

Adrian is most experienced in business areas like Information Technology (IT), Operations, and Project Management. Adrian also has some experience in Product Development, Quality Assurance (QA), and Business Intelligence.

Which industries has Adrian worked in recently?

Adrian has recently worked in industries like Information Technology (IT) and Banking and Finance.

Which business areas has Adrian worked in recently?

Adrian has recently worked in business areas like Information Technology (IT).

What is Adrian's education?

Adrian holds a Master in Computer Science and Software Engineering from University of Economics Bratislava.

Does Adrian have any certificates?

Adrian has 2 certificates. These include: Oracle Autonomous Database Cloud 2021 Certified Specialist and Oracle Certified Professional - Database Administrator.

What is the availability of Adrian?

Adrian is immediately available for suitable projects.

What is the rate of Adrian?

Adrian's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Adrian?

To hire Adrian, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1200
900
600
300
Market avg: 920-1080 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.