Roland Millonig
Oracle DBA (Remote)
Experience
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Oracle Instructor
BIT Schulungszentrum, Vienna, Austria
- Taught Developer/2000, Designer/2000, WebServer, SQL, PL/SQL, SQL*Plus, and HTML
- Developed training materials and examinations
Data Exchange Developer
GE Capital Bank, Vienna, Austria
- Developed Unix C-shell and Bourne shell scripts for automated FTP data transfer to Windows
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
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
Access Database Developer
Schneiderei Havel, Ried/Innkreis, Austria
- Solely responsible for analysis, design, and programming in Access 97 with Visual Basic on Windows NT
Oracle DB Tuning Specialist
GE Capital Bank, Vienna, Austria
- Tuned Oracle SQL scripts for accurate and high-performance data cleansing
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
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
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
Business Analyst
GE Capital Austria
- Defined requirements using ADW case tool
- Conducted technical evaluations of offered software products
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
Business Analyst and Programmer
Nestlé Austria
- Analyzed, designed, and programmed packaging deposit system on AS/400 using RPG/400
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
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
Participant
Language Improvement Stay
- Improved foreign language skills during 8 months in Scotland and 1 month in France
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
Mandatory Military Service
Austria Armed Forces
- Completed required national service
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 (29 years), Professional Services (26.5 years), Transportation (5.5 years), Banking and Finance (5.5 years), Telecommunication (4.5 years), and Food and Beverage (4 years).
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 (37 years), Business Intelligence (27.5 years), Project Management (10.5 years), Logistics (5 years), Finance (4 years), and Customer Service (2.5 years).
Languages
Education
TU Wien
Data Engineering · Vienna, Austria
HAK Oberpullendorf
High School Diploma · Business Academy · Oberpullendorf, Austria
Hauptschule Stoob
Secondary School · Stoob, Austria
Certifications & licenses
Driver's License A
Driver's License B
Driver's License C
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Roland based?
What languages does Roland speak?
How many years of experience does Roland have?
What roles would Roland be best suited for?
What is Roland's latest experience?
What companies has Roland worked for in recent years?
Which industries is Roland most experienced in?
Which business areas is Roland most experienced in?
Which industries has Roland worked in recently?
Which business areas has Roland worked in recently?
What is Roland's education?
Does Roland have any certificates?
What is the availability of Roland?
What is the rate of Roland?
How to hire Roland?
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 Oracle DBA (Remote)
Nearby freelancers
Professionals working in or nearby Villach, Austria