Top expert badge
Recommended expert
Profile header background

Adrian Hollay

Interim Consultant for Oracle Database Migrations to the AWS Cloud

Adrian Hollay
Profile header overlay
Wedel, Germany

Experience

Nov 2021 - Present
4 years 5 months

Interim Consultant for Oracle Database Migrations to the AWS Cloud

Bank Deutsches Kraftfahrzeuggewerbe GmbH

Expertise details
Position Summary
Interim Consultant for Oracle Database Migrations to the AWS Cloud at Bank Deutsches Kraftfahrzeuggewerbe GmbH
Industries
Banking and Finance
Business Areas
Information Technology
  • 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

Expertise details
Position Summary
Migration of existing data warehouse from HPUX/Oracle 10g to AWS at Johnson & Johnson MEDICAL GmbH
Industries
Healthcare
Business Areas
Business Intelligence
Information Technology
  • 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
11 years

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

DERMALOG Identification Systems GmbH

Expertise details
Position Summary
Oracle Database Administrator (DBA) in the field of biometric identification at DERMALOG Identification Systems GmbH
Industries
Information Technology
Business Areas
Information Technology
  • 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

Expertise details
Position Summary
Oracle Performance & Tuning for Output & Document Management System at Schenker AG
Industries
Transportation
Business Areas
Information Technology
  • 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

Expertise details
Position Summary
Oracle database administration and Linux administration for the large-scale procedure KoPers at Dataport AÖR
Industries
Government and Administration
Business Areas
Information Technology
Operations
Quality Assurance
  • 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

Expertise details
Position Summary
Oracle Database Administrator, Developer at GDV Dienstleistungs-GmbH & Co. KG
Industries
Insurance
Business Areas
Business Intelligence
Information Technology
  • 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)

Expertise details
Position Summary
Oracle Performance Specialist and Oracle DBA at Otto (GmbH & Co KG)
Industries
Retail
Business Areas
Information Technology
Operations
  • 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

Expertise details
Position Summary
SAP Basis Administrator, Oracle Database Administrator (DBA) at Stadtreinigung Hamburg
Industries
Government and Administration
Business Areas
Information Technology
  • 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

Expertise details
Position Summary
Oracle database administration and support for highly available web applications at GDV Dienstleistungs-GmbH & Co. KG; eSailors IT Solutions GmbH
Industries
Insurance
Information Technology
Business Areas
Customer Service
Information Technology
  • 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.

Expertise details
Position Summary
Oracle Database Administrator, Trainer, Team Lead at Gesamtverband der Deutschen Versicherungswirtschaft e.V.
Industries
Insurance
Business Areas
Information Technology
Operations
  • 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

Expertise details
Position Summary
Oracle Database Administrator, System Administrator, System Architect at GDV Dienstleistungs-GmbH & Co. KG; Easynet GmbH
Industries
Information Technology
Business Areas
Information Technology
  • 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

Expertise details
Position Summary
Oracle Database Administrator, Developer at Implico GmbH
Industries
Energy
Information Technology
Transportation
Business Areas
Information Technology
  • 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

Expertise details
Position Summary
SAP Basis Administrator, Oracle DBA, SIRAX Administrator at Lufthansa Systems AS GmbH
Industries
Aerospace and Defense
Information Technology
Business Areas
Information Technology
  • 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)

Expertise details
Position Summary
Oracle Database Administrator and Developer at Hamburger Sparkasse (HASPA)
Industries
Banking and Finance
Business Areas
Information Technology
  • 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.

Expertise details
Position Summary
Oracle Database Administrator, Solaris System Administrator at 02 (Germany) GmbH & Co.
Industries
Telecommunication
Business Areas
Information Technology
Operations
  • 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

Expertise details
Position Summary
SAP Basis Administrator at Marktplatz Services GmbH
Industries
Information Technology
Business Areas
Information Technology
Operations
  • 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

Expertise details
Position Summary
ITO/ITI Head, Oracle DBA, SAP R/3 Basis Administrator at Mercateo AG
Industries
Information Technology
Business Areas
Information Technology
Operations
  • 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

Expertise details
Position Summary
Oracle DBA & Unix Administrator at Portal Software (Hamburg) GmbH
Industries
Information Technology
Business Areas
Business Intelligence
Information Technology
Operations
  • 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

Expertise details
Position Summary
Oracle Administrator & Designer, Solaris and Linux Administrator at Nikotel Deutschland AG
Industries
Telecommunication
Business Areas
Information Technology
Project Management
  • 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

Expertise details
Position Summary
Oracle Database Administrator and Developer at BizTec AG
Industries
Information Technology
Business Areas
Information Technology
Operations
  • 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

Expertise details
Position Summary
IT Project Manager, Developer/Analyst at Kameron GmbH
Industries
Information Technology
Business Areas
Information Technology
Product Development
Project Management
  • 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

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Information Technology, Banking and Finance, Government and Administration, Transportation, Insurance, and Healthcare.

Information Technology
Banking and Finance
Government and Administration
Transportation
Insurance
Healthcare
Profile match chart

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Operations, Project Management, Product Development, Business Intelligence, and Quality Assurance.

Information Technology
Operations
Project Management
Product Development
Business Intelligence
Quality Assurance
Profile match chart

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

Statistics

Experience

Total positions 21
Experience in Information Technology 18.5 y
Avg length 1 y 6 m
Longest experience 10 y 11 m

Expertise

Recent roles 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
Main industries Information Technology, Banking and Finance, Government and Administration
Main business areas Information Technology, Operations, Project Management

Qualifications

Highest degree Master
Certifications earned 2

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, Banking and Finance, and Government and Administration. Adrian also has some experience in Transportation, Insurance, and Healthcare.

Which business areas is Adrian most experienced in?

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

Which industries has Adrian worked in recently?

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

Which business areas has Adrian worked in recently?

Adrian has recently worked in business areas like Information Technology.

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.

1000
750
500
250
Rate comparison chart
Market avg: 800-960 €
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.