Adrian Hollay
Interim Consultant for Oracle Database Migrations to the AWS Cloud
Experience
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
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
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
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
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
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
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
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)
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
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
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
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
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
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
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
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)
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
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
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
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)
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).
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).
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
Education
University of Economics Bratislava
Dipl. Ing. in Computer Science and Software Engineering, Faculty of Economics · Computer Science and Software Engineering · Bratislava, Slovakia
Konstantinova High School
Prešov, Slovakia
Certifications & licenses
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle Certified Professional - Database Administrator
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Adrian based?
What languages does Adrian speak?
How many years of experience does Adrian have?
What roles would Adrian be best suited for?
What is Adrian's latest experience?
What companies has Adrian worked for in recent years?
Which industries is Adrian most experienced in?
Which business areas is Adrian most experienced in?
Which industries has Adrian worked in recently?
Which business areas has Adrian worked in recently?
What is Adrian's education?
Does Adrian have any certificates?
What is the availability of Adrian?
What is the rate of Adrian?
How to hire Adrian?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Interim Consultant for Oracle Database Migrations to the AWS Cloud
Nearby freelancers
Professionals working in or nearby Wedel, Germany