Claus (Østby) Nielsen
Oracle Database Engineer
Experience
Oracle Database Engineer
BBV.ch
- Migration of databases from ODA to ExaData
- Migration of databases from ExaData to ExaCC/OCI
- Decreased UCC usage by 10%
- Developing automation scripts using Python
- Performance tuning
- Shrunk development databases from 6 TB to 3 TB using Exadata columnar compression
- Tuned application performance by 30% using inmemory option
- Tuned non-production Exadata by 20% to release CPU resources before ExaCC migration
- Database patching of Oracle 19c
- Basic Ansible scripting for deployments and database cloning
- Developing acconting model for shared Oracle platform
- Migrating single-instance databases to Oracle RAC
- Analysis of RAC issues
- Advising development teams of how to migrate to RAC
Oracle Database Engineer
Sunrise UPC
- Migration of databases to Exadata
- Developing automation scripts using Python
- Performance tuning
- Database patching 12.x -> 19.10
- APEX Development
Oracle Database Engineer
GULP
- Oracle Private Cloud Appliance
- Developing automation scripts using Python
- Performance tuning
- Database patching 12.x -> 19.10
- Database migration 12.x -> 19.x
DevOps database audit specialist
Swisscom AG
Oracle DBA / Sysadmin
Tradeware AG
- Credit Suisse: Migration of Datawarehouse infrastructure to Exadata. Migration of 80 Oracle 11.2.0.4 databases to Oracle 19c on Exadata. Provisioning storage cells.
- UBS: Sysadmin for 80 ODA and Exadata nodes. Hardware service. Operating system upgrades. Troubleshooting of the Grid Infrastructure software stack.
- Migros Bank: DBA Operation on Exadata infrastructure. Multitenant database cloning. Performance issues. Automation.
Senior Oracle DBA with application focus
Avectris AG
- Senior Oracle DBA with application focus for Generali AG.
- Migrating several enterprise quality applications from the old IT service provider Avaloq to the Avectris infrastructure.
- Analyzing and rewriting application code.
- Supporting the development teams in both Avectris and Generali.
- Migrating databases and developing database cloning procedures.
- Implementation of database cloning in Python using HPE 3PAR storage snapshots.
Senior Oracle DBA
Rize Recruitment
- Migrating Oracle OID to Oracle Fusion 11g
- Migrating OEM 11 to Cloud Control 12c
- APEX Development
- Database Engineering in large environment of 500+ Oracle database
- Backup status reports
- Security reports
- Capacity Management reports
Senior Oracle DBA
Coba IT
- Migrating 4000+ databases to Simpana/Comvault
- Incident/Problem Management
- Performance tuning
Hewlett Packard
Senior Oracle DBA
Bosshard & Partner
- Incident/Change/Problem Management at Bank Julius Baer
- Database migrations
- Task forces regarding backup/performance problems
- Testing Oracle 12c RDBMS
- Capacity Management of disk, CPU and network resources in AIX environment
Senior Oracle Engineer / Associate Vice President
Leonteq AG
- Management of the database tier for mission critical Sophis application and migration between different generations of the database platform (40 databases and 8 physical database servers).
- Engineering of four generations of Oracle database platforms using technologies like Oracle 10g/11g, Sun V490, Solaris 10, ASM, HP DL 380, Oracle Unbreakable Linux, HP blade servers, Suse Enterprise Linux 11, Oracle Grid Infrastructure, Hitachi SAN, Fiber Channel attached HP MSA 2000, and NetApp FAS 2043.
- License management of Oracle installation (support budget 100,000 CHF/year).
- Proof of concept and purchase decision of Commvault and Control-M infrastructures.
- Migration of business critical applications from Oracle 10g to 11g.
- Migration of backup system from diskbased backups to Commvault.
- Migration of storage system from ASM to NetApp.
- Production support and on-call duty.
- Technologies used: Oracle 10g/11g, PL/SQL, Dataguard, Oracle Streams replication, Enterprise Manager 10g/12c, RMAN, VMWare ESX, Suse Enterprise Linux, NetApp Metrocluster, Sun Solaris, Shell scripting.
Senior Oracle DBA
Swisslinx AG
- Rollout and maintenance of a large Grid Control infrastructure for Credit Suisse with about 6,000 individual targets.
- Regression testing to ensure Oracle 11g compliance with Credit Suisse standards.
- Migration of a 100 TB data warehouse from Oracle 10g to 11g.
- Scripting automatic procedures for refreshing development environments using volume manager snapshots.
- Production support and on-call duty.
- Technologies used: Oracle 10g/11g, Oracle RAC 10g/11g, PL/SQL, Dataguard, Enterprise Manager 10g, Sun Solaris, RMAN, Oracle Application Express, Shell scripting.
DBA
Amadeus IT Group
- DBA work on high availability databases for the airline industry.
- Migration of 1 TB database from Oracle 9 on HP-UX to Oracle 10g on Suse Enterprise Linux.
- Preparation of Linux production environment (SUSE Enterprise Linux) for Oracle 10g (RMAN backup to disk, integration to Tivoli Storage Manager).
- Installation of physical standby databases on HP-UX.
- Installation of 10g RAC on Linux (Oracle Unbreakable Linux).
- Collection and analysis of capacity statistics at instance and session level.
- Production support and on-call duty.
- Technologies used: Oracle 9i/10g, Dataguard, Enterprise Manager 10g, HP-UX, RAC, Suse Linux, RMAN, Shell scripting, PL/SQL.
DBA
IBM Denmark
- DBA work on large Invoicing System for Maersk Sealand (revenue 28 billion USD) based on Oracle Financials AR module.
- Incident, Problem and Change processes according to ITIL.
- Production support and on-call duty.
- General DBA tasks for Sonofon including capacity, storage, and performance tuning.
- Technologies used: Oracle 9i/10g, Dataguard, Enterprise Manager 9i, Sun Solaris, RAC, RMAN, PL/SQL, Shell-scripting.
Technical coordinator / DBA / Developer
IT-Konsulenterne ApS
- Technical coordinator during conversion of billing system from BSCS5 to BSCS7 for Orange DK A/S.
- DBA work in Oracle 7, 8i, and 9i for Orange DK A/S.
- Development of mediation systems for GPRS and MMS services.
- Test of TAP3 format with external Data Clearing House.
- DBA on implementation of Peoplesoft 8 for Orange DK A/S.
- Installation of Oracle 9i and design of interfaces to number portability for Telmore.
- Training customer in standards for number portability and design of interfaces to Internal Clearing House for ONI (Portugal).
- Design, implementation, and test of provisioning gateway to a Nortel DMS100 Exchange for Cabovisaõ (Portugal).
- Object Oriented design and programming in Java, JDBC, Oracle, Corba, and Perl for Internal Clearing House international project.
- DBA on Oracle 7 for Mobilix A/S.
- Technical coordinator during conversion of billing system from BSCS3 to BSCS5 for Mobilix A/S.
- Oracle 7 performance optimization and development of tools for automatic test of CDR formats for Mobilix A/S.
- Developer during implementation of ASN.1 (TAP3) in the Roameo Data Clearing House for Dan Net.
PC support and developer
InCase Aps
- PC support and development of SQL reports on DB2 for IBM/SDC.
Developer / Trainer
Dan Net A/S
- Developer for Roameo Data Clearing House, optimization of SQL and design of database interface.
- Analysis and development of internet based distribution system for medicine prices for DLI.
- Development of TOPAS billing system for interconnect traffic for Tele Danmark EDB.
- Development of trouble ticket system for KTAS.
- Internal development and internal trainer in DB2 and CSP programming.
- Development of Electronic Document Interchange systems for the transport sector.
- Technologies used: Oracle 7, IBM AIX, ANSI-C.
Developer / Project leader / Database Administrator
Port Authority of Copenhagen
- Developer for Payroll and Purchase systems.
- Project leader for Finance system.
- Database Administrator for SQL/DS and CA-UNIVERSE.
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 Telecommunication (17 years), Information Technology (15.5 years), Transportation (14 years), Banking and Finance (11 years), Healthcare (6 years), and Government and Administration (5 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 (38 years), Product Development (12 years), Business Intelligence (11 years), Finance (10 years), Operations (7 years), and Customer Service (6 years).
Summary
Highly skilled Database Engineer with 20 years of professional experience with Oracle technologies. Experience in Oracle Data Guard configuration, Oracle Streams implementation and Oracle database performance tuning. Considerable experience in Oracle Database backup and restore techniques using RMAN including database backup strategies implementation. Experience in implementation and configuration of Oracle Enterprise Manager version 12/13c for both small and very large installations. Extensive experience in Linux (Suse/Redhat) and Solaris system administration. Many years of experience with supporting mission critical database systems for Fortune 500 companies and especially the Financial Industry.
Skills
- Unix (Solaris, Linux)
- Windows (W2k, Xp, Win7)
- Ansi-c
- Csp
- Pl/sql
- Shell-script (Awk, Ksh, Sh, Bash, Perl)
- Java
- Python
- Oracle 7
- Oracle 8
- Oracle 8i
- Oracle 9
- Oracle 10
- Oracle 11g
- Oracle 12c
- Oracle 19c
- Mssql 2008 (Basic)
- Postgres (Basic)
- Ibm Websphere Mq Series
- Oracle Grid Control 12c
- Oracle Grid Control 13c
- Oracle Golden Gate 12g
- Oracle Rac
- Oracle Dataguard
- Oracle Cloud Infrastructure
- Apex
- Commvault Backup (Basic Engineering)
- Control-m Batch Scheduler (User Level)
- Vmware Esx (Basic Engineering)
- Amazon Aws Rds
- Netapp (Basic Engineering)
- Ansible (Basic)
Languages
Certifications & licenses
Oracle 11g OCP DBA
Oracle 9i Certified Master
Oracle10g OCP DBA
ITIL Foundation Certification
Oracle9i OCP DBA
Oracle8i OCP DBA
Oracle8 OCP DBA
Oracle7 OCP DBA
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Claus based?
What languages does Claus speak?
How many years of experience does Claus have?
What roles would Claus be best suited for?
What is Claus's latest experience?
What companies has Claus worked for in recent years?
Which industries is Claus most experienced in?
Which business areas is Claus most experienced in?
Which industries has Claus worked in recently?
Which business areas has Claus worked in recently?
Does Claus have any certificates?
What is the availability of Claus?
What is the rate of Claus?
How to hire Claus?
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 Database Engineer
Nearby freelancers
Professionals working in or nearby Thalwil, Switzerland