My services

Troubleshooting and performance analysis

A methodical and structured approach to solving technical, logical or performance problems is my core competence.

 

Solve these problems in your Oracle databases with my support.

Oracle upgrades and migrations

Current database versions ensure support by Oracle and third party manufacturers. Improve your protection with the latest security patches and benefit from functional and performance improvements by updating and maintaining your Oracle databases.

Oracle Databases in the cloud

I provide consultation and support for the operation of your Oracle databases in the cloud, delivering suitable solutions for a smooth migration to the cloud.
I early and independently assess the actual economic and operational benefits that can be realized.

All things “Oracle Database”

In addition to these topics, in which I have specialized, I can also reliably support and advise you as a freelancer in most other areas of Oracle database administration.

 

Use the opportunity to arrange an introductory call!

About me

Computer scientist – Database expert – Oracle Certified Master

Qualifications

  • Computer Scientist (B.Sc.)
  • Oracle Database Certified Master (OCM) Administrator
  • Oracle Database Certified Professional (OCP) Administrator (10g, 11g, 19c)
  • Oracle Cloud Database Migration and Integration 2022 Professional
  • Oracle Database Certified Expert (OCE) Performance Tuning
  • Oracle Database Certified Expert (OCE) Managing Oracle on Linux
  • Oracle Certified Specialist (OCS) Autonomous Database Cloud 2019
  • AWS Certified Solutions Architect – Associate 2016
  • IBM Data Science Foundations Specialist

Past projects

Oracle consulting and support for an energy supplier

  • Consulting and support regarding the migration of an complex application system to a SaaS solution in the cloud
  • Concept developmment of the multi-part migration for the Oracle database side, including fallback scenarios and archival of the legacy systems
  • Development of complex scipts and PL/SQL code for data migration and archival
  • Performance optimization of the delete and copy processes

 

Concept development and consulting regarding migrations to Oracle 19c for an health insurance company

  • Consulting regarding migration techniques, performance management and new Oracle features
  • Analysis of the Oracle system environment
  • Oracle performance analysis and tuning
  • Determination of the best migration technique and proceedings
  • Design and execution of tests preparing the migration
  • Research and tests for individual topics

 

Database administration for an energy supplier

  • Project management and implementation of multiple Oracle database migrations
  • Technical project management for Oracle license audit
  • Project management, conception and implementation of a configuration management tool (CMDB) in Oracle Apex
  • Project management, design and implementation of an Icinga system monitoring system
  • Troubleshooting of Oracle databases
  • Oracle performance analysis and tuning
  • Consulting of internal developers and project managers on Oracle database issues
  • All other standard database administration tasks

 

Oracle consulting and database administration for a software development company for the pharmaceutical industry

  • Consulting of customers from the pharmaceutical industry regarding infrastructure, high availability solutions, installation, database migrations and licensing issues
  • Troubleshooting in the area of Oracle databases, inhouse and with customers from the pharmaceutical industry
  • Migration of Oracle databases inhouse and for customers from the pharmaceutical industry
  • Oracle Database administration inhouse
  • Consulting of internal developers and project managers on Oracle database issues
  • Oracle performance analysis and tuning

Skills, technologies and tools

I have many years of experience with Oracle 9i to 19c running on Linux and Windows.

Here is a selection of techniques, skills and tools I have already used over the years:

Oracle RAC (Real Application Cluster)
Oracle Automatic Storage Management (ASM)
Oracle Grid Infrastructure
Oracle Clusterware
Oracle RMAN (Recovery Manager)
Oracle Datapump, imp/exp
Oracle VPD (Virtual Private Database)
Oracle Dataguard
Oracle APEX
Oracle SQL*Plus and SQLcl
Oracle SQL Developer
Oracle Failsafe
Oracle Enterprise Manager

Oracle Database audit trail
Oracle Internet Directory and LDAP
Automatic Workload Repository (AWR)
Active Session History (ASH)
Statspack
10053 and 10046 trace file diagnostic
Oracle licensing and license audits
Snapper
Oracle Linux
Oracle Cloud Infrastructure (OCI)
Oracle Zero Downtime Migration (ZDM)
Oracle Autonomous Database
Oracle Cloud Database Services

Microsoft Azure Cloud-Computing
Amazon Web Services (AWS) Cloud-Computing
NetApp SnapManager for Oracle (SMO)
NetApp SnapDrive
Swingbench
elasticsearch, logstash, kibana
PostgreSQL
Docker and Docker Swarm
Icinga, Nagios
VMWare
Python
Object Pascal
Shellskripting

Get in touch

 

Arrange an introductory call

Take your time to find out whether I am the ideal partner for you and your Oracle databases.

Please contact me by email to arrange a phone or video call.



Contact details

Marcus Mönnig Database Engineering
Ludwig-Erhard-Straße 18
20459 Hamburg
Germany
office@marcusmoennig.de
XING profile
LinkedIn profile
@MarcusMonnigDE