Roland Millonig - Oracle DBA (Remote)

Villach, Austria

Experience

Jan 2022 - Dec 2022

1 year

Remote

Oracle DBA (Remote)

Werkstoff-Kunstoffindustrie, Germany

Supported migration of Oracle databases to AWS
Performed performance tuning both on-premises and in AWS
Advised on sizing of new databases
Analyzed Oracle edition switch scenarios
Designed backup and restore concepts for AWS Oracle RDS
Configured RDS instances using CloudFormation CLI
Implemented load balancer and HAProxy solutions
Migrated data on-premises to AWS S3 using Oracle Data Pump
Utilized Oracle 19c, Visual Code, Git, and SQL Developer

Jun 2021 - Aug 2023

2 years 3 months

Remote

Oracle DBA (Remote)

Energiewirtschaft, Germany

Supported Project Mig21 migration to cloud
Handled ad hoc daily operations and performed error analyses
Developed and maintained central APEX tool
Designed and tested backup/restore scenarios with NetApp Snap Manager
Implemented Oracle Data Pump and RMAN for platform conversion (Windows to Linux)
Provided third-level support for SQL Server and PostgreSQL databases
Worked with Oracle 11–19c, NetApp, APEX, Snap Manager for Oracle, Oracle Fail Safe, SQL Developer, Jira, Windows

May 2019 - Jul 2020

1 year 3 months

Oracle DBA / Application Manager

Immobilien, Germany

Maintained Realax and Windream real estate applications
Operated and supported Oracle 11.2 and 12c databases at third level
Set up RMAN backups
Conducted error and performance analyses
Used Citrix Director, SQL Developer, Enterprise Manager 12c, Helpline ticket system, and Active Directory

Feb 2014 - Oct 2018

4 years 9 months

OWB Developer and DBA

Telekom, Switzerland

Insourced and operated a data warehouse system for cost and connection analysis
Performed vulnerability analyses and implemented improvements
Developed new functionalities and provided third-level support
Built a complete test environment (Linux, Oracle DB, Tomcat, web application)
Managed data transfer from production to test and special data imports
Supported local database setups for web developers
Developed with Oracle Warehouse Builder (including OMB)
Conducted performance tuning and designed new data load concepts
Planned OWB replacement with ODI, including concept and test migration
Scheduled jobs with Oracle Scheduler and UC4

Sep 2012 - May 2013

9 months

Oracle DBA and Consultant

Automotive, Germany

Audited configuration of Oracle 11.2.0.2 databases integrated with Siebel CRM
Conducted quality checks of statistics and troubleshot SQL queries
Advised on materialized views, parallel processing, bind variables, data compression, stored outlines, and statistics gathering
Managed index and segment reorganizations
Created programs for basic and regular statistic gathering after Siebel releases
Used PL/SQL Developer, SQL Developer, Precise, Siebel CRM

May 2011 - May 2012

1 year 1 month

OWB and Oracle Consultant

Insurance, Switzerland

Upgraded multiple DWHs from OWB 9.2/10.1/10.2 to 11gR2 using OMB automation
Migrated systems from AIX to Linux
Installed OWB clients and applied patches
Validated legacy DWHs and established naming conventions
Packaged scripts for deployment and orchestrated UC4 workflows
Performed performance tuning using AWR, ADDM, and SQL optimization
Worked with UNIX, Linux, OWB, OMB, PL/SQL Developer, ClearCase

Feb 2010 - Sep 2010

8 months

PL/SQL Quality Manager and Performance Specialist

ENBW, Germany

Developed PL/SQL programs to detect, report, and correct data errors, inconsistencies, and logical defects
Managed quality assurance for energy and GIS data (ArcGIS, ArcFM UT)
Created APEX application and operation concept for quality control
Planned and configured cron jobs
Automated batch job performance optimization (index rebuilds, statistics creation, index monitoring, parallelization)
Used UNIX scripting, PL/SQL Developer, MetaFrame, Oracle 10gR2, APEX

Oct 2008 - Mar 2009

6 months

Oracle Forms Programmer

Centris, Switzerland

Developed multiple Forms applications for health and accident insurance migration project
Worked with Forms 10g and set up deployment processes
Used Windows environment with TOAD, Remote Desktop, and VPN

Nov 2007 - Mar 2008

5 months

Oracle DBA

Bundeswehr, Germany

Took over operation of system integration environment
Set up development systems and monitored live systems
Managed Oracle 10gR2, Cognos, Informatica ETL, message queuing, and RMAN backups

Apr 2006 - Dec 2006

9 months

Oracle DBA

Eli Lilly, Bad Homburg, Germany

Upgraded databases to 10.2.0.1 and cloned/delete databases in a regulated environment
Validated and documented system changes
Installed and patched software releases
Used Remedy ticket system, Lotus Notes, Solaris, HP, Windows, TOAD, and SQL Developer

Feb 2004 - Nov 2007

3 years 10 months

Oracle DBA

Siemens / Royal Mail, Germany

Installed Oracle 9i–10.2.0.1 databases for production and test systems
Migrated databases from 9.2.0.7 to 10gR2 and applied patches
Resolved Oracle locking issues using partitioning, Advanced Queues, and replication
Developed stored procedures and triggers for auditing
Automated testing and managed test data
Implemented Java interface classes (JDBC) and Oracle Fail Safe
Built and maintained RAC environments
Performed DB and SQL tuning with Statspack, OEM, and Quest Expert
Managed version control with Harvest and SVN; used RMAN, Pl/SQL Developer, TOAD

Dec 2003 - Dec 2003

1 month

Oracle Web Forms Developer

SphinxConsulting, Vienna, Austria

Developed web forms with PL/SQL and TOAD on Oracle 9i Application Server
Programmed packages, procedures, and functions
Set up test environment on Windows 2000 and deployed to Linux
Managed version control with CVS

Mar 2003 - Aug 2003

6 months

Oracle Forms Designer/Developer

Siemens, Braunschweig, Germany

Designed and programmed Forms 6i applications with PL/SQL and SQL Navigator on Solaris
Created design documentation and online help with HTML
Conducted test documentation reviews
Used ClearCase and RequisitePro

May 2001 - Dec 2002

1 year 8 months

DBA/Developer

Deutsche Post AG, Darmstadt, Germany

Provided Oracle consulting for SER document management system
Conducted DB tuning and PL/SQL programming
Scripted HPUX operations and developed intranet solutions (HTML DB, OAS)
Created operating and security concepts for Oracle 8i/9i and Forms 6i
Planned backup/recovery strategies

Aug 2000 - Dec 2001

1 year 5 months

DBA/Designer

Commerzbank, France

Administered Oracle 8i databases on AIX with backup/recovery and HACMP clustering
Implemented datamarts and data warehouse solutions
Monitored database performance and programmed PL/SQL interfaces
Migrated databases from 7.3 to 8i and conducted functional tests
Remotely maintained Remedy CRM database

Mar 2000 - Jul 2000

5 months

Oracle Instructor

BIT Schulungszentrum, Vienna, Austria

Taught Developer/2000, Designer/2000, WebServer, SQL, PL/SQL, SQL*Plus, and HTML
Developed training materials and examinations

Apr 1999 - May 1999

2 months

Data Exchange Developer

GE Capital Bank, Vienna, Austria

Developed Unix C-shell and Bourne shell scripts for automated FTP data transfer to Windows

Feb 1999 - Jul 2025

26 years 6 months

Oracle Developer and Consultant

Self-Employed

Provided ongoing Oracle consulting, training, and telephone support for clients in Austria, Switzerland, and Germany
Performed performance tuning using Statspack and SQL optimization
Troubleshot production issues including replication, statistics errors, and runtime behavior
Supported data warehouse and BI solutions
Conducted database health checks for Oracle 11g, 12c, and 19c
Analyzed and designed RAC environments, implemented training, and developed applications with Oracle APEX

Feb 1999 - Dec 2000

1 year 11 months

Oracle Programmer and DBA

STRATIS Informationssysteme, Vienna, Austria

Performed PL/SQL and SQL programming and UNIX scripting on Sun Solaris and Dynix
Conducted DB tests after NUMA migration on Sequent
Developed data correction programs, views, procedures, functions, and triggers
Served as UNIX/Oracle consultant for credit and leasing application forms 6i

Jan 1999 - Jun 1999

6 months

Access Database Developer

Schneiderei Havel, Ried/Innkreis, Austria

Solely responsible for analysis, design, and programming in Access 97 with Visual Basic on Windows NT

Jan 1999 - Mar 1999

3 months

Oracle DB Tuning Specialist

GE Capital Bank, Vienna, Austria

Tuned Oracle SQL scripts for accurate and high-performance data cleansing

Jan 1998 - Dec 1998

1 year

Migration Developer

GE Capital Austria

Analyzed source data and defined target datasets
Programmed migration with PL/SQL and SQL Loader from VSAM to Oracle DB

Jan 1996 - Dec 1997

2 years

DB Programmer and DBA

GE Capital Austria

Designed and programmed credit-leasing software in Forms 6i, SQL, and PL/SQL on Oracle under Sun Solaris
Performed testing and DB tuning as primary DBA responsibilities

Jan 1995 - Feb 1999

4 years 2 months

Business Analyst/System Analyst

GE Capital Bank

Conducted requirements analysis for credit and leasing IT projects
Managed technical project leadership of IT initiatives
Integrated and supported applications
Acted as Oracle DBA under UNIX
Migrated and tested Oracle from version 7.3.4 to 8.0
Administered UNIX systems
Developed with Developer/2000 and Designer/2000
Programmed in SQL, PL/SQL, Unix shell, and nawk

Jan 1995 - Dec 1995

1 year

Business Analyst

GE Capital Austria

Defined requirements using ADW case tool
Conducted technical evaluations of offered software products

Jan 1994 - Dec 1994

1 year

Technical Project Member

Nestlé Austria

Performed requirements analysis and technical project support
Managed hardware setup and data security
Developed interfaces to production systems on PRG/400

Jan 1993 - Dec 1993

1 year

Business Analyst and Programmer

Nestlé Austria

Analyzed, designed, and programmed packaging deposit system on AS/400 using RPG/400

Mar 1991 - Dec 1994

3 years 10 months

System Analyst/Programmer

Nestlé Austria

Developed applications including analysis and design
Led projects for accounts receivable, statistics, inventory, and logistics
Worked on AS/400 (RPG/400, OS/400)
Organized projects using MS Project
Used CASE tool ADW

Jun 1988 - Feb 1991

2 years 9 months

Programmer/Analyst

WANG Austria

Installed hardware components
Developed software using COBOL and PACE
Provided user support and training
Organized and managed projects
Maintained and supported LAN and WAN networks

Sep 1987 - May 1988

9 months

Participant

Language Improvement Stay

Improved foreign language skills during 8 months in Scotland and 1 month in France

Mar 1986 - Aug 1987

1 year 6 months

Distribution Clerk

Procter & Gamble

Managed warehouse accounting on PC using Lotus 123
Scheduled and coordinated truck dispositions
Handled import processes including customs clearances using IBM/S36

Jul 1985 - Feb 1986

8 months

Mandatory Military Service

Austria Armed Forces

Completed required national service

Languages

German

Native

English

Advanced

French

Intermediate

Education

Oct 1985 - Present

TU Wien

Data Engineering · Vienna, Austria

Sep 1980 - Jun 1985

HAK Oberpullendorf

High School Diploma · Business Academy · Oberpullendorf, Austria

Sep 1976 - Jun 1980

Hauptschule Stoob

Secondary School · Stoob, Austria

...and 1 more

Certifications & licenses

Driver's License A

Driver's License B

Driver's License C

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Similar Freelancers

Discover other experts with similar qualifications and experience

Olaf Taesch

BI Architect in the Kanban Team

View Profile

Jakub Szepietowski

Oracle Consultant

View Profile

Ernst Höfler

Support/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD

View Profile

Serkan Kaya