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
  • Oracle Cloud DevOps Professional (OCP) 2023
  • Oracle APEX Cloud Developer Professional (OCP) 2023
  • AWS Certified Solutions Architect – Associate 2016
  • IBM Data Science Foundations Specialist

Past projects

Consultation and support for a home appliance manufacturer

  • Analysis and securing of the Oracle databases of the inventory management system
  • Securing, reconfiguration, and testing of the RMAN Backup/Recovery
  • Analysis/testing of the scripted high availability solution
  • Training of the employees regarding Oracle database administration

 

Oracle Consulting and Support for an Energy Provider

  • Consulting and support during the migration of a complex application system to a SaaS provider into the cloud for the Oracle databases area
  • Conceptualization of the multi-part migration for the data part in the Oracle databases, including fallback scenarios and archiving of the legacy systems
  • Development of complex scripts and PL/SQL code for data migration and archiving
  • Performance optimization of deletion and copying 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 Database Management and Administration

Oracle Database Backup and Recovery
Oracle RMAN (Recovery Manager)
Oracle Datapump, imp/exp
Oracle Flashback Technology
Oracle Database Upgrade and Migration
Oracle Dataguard
Oracle Failsafe
Oracle Patch Management
Oracle Multitenant
Oracle RAC (Real Application Cluster)
Oracle Automatic Storage Management (ASM)
Oracle Grid Infrastructure
Oracle Clusterware
Oracle VPD (Virtual Private Database)
Oracle Transparent Data Encryption (TDE)
Oracle Database audit trail

Oracle Performance, Monitoring and Diagnosis

Automatic Workload Repository (AWR)
Active Session History (ASH)
Statspack
Trace file diagnostic
Snapper
Oracle Performance Tuning
Oracle Real Application Testing (RAT)
Oracle SQL Tuning Advisor
Swingbench
Snapper

Oracle Software Development

Oracle APEX
Oracle SQL*Plus and SQL
Oracle SQL Developer
PL/SQL Programmierung
Oracle Database Data Modelling and Design

Oracle System Administration and License Management

Oracle Enterprise Manager
Oracle Internet Directory and LDAP
Oracle Lizenzierung und Lizenzaudit

Operating Systems and Virtualization

Oracle Linux
Windows
VMWare

Cloud-Computing

Oracle Cloud Infrastructure (OCI)
Oracle Cloud Database Services
Oracle Autonomous Database
Oracle Zero Downtime Migration (ZDM)
Microsoft Azure Cloud-Computing
Amazon Web Services (AWS) Cloud-Computing

Other Database Technologies and Tools

PostgreSQL
MS SQL
NetApp SnapManager for Oracle (SMO)
NetApp SnapDrive
Icinga, Nagios
Elasticsearch, Logstash, Kibana

SOFTWARE DEVELOPMENT AND DevOps

Python
Object Pascal
IaC, Chef, git
Docker und Docker Swarm
Shellskripting
Windows Batch

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