Databases

Databases are the core of our work. We have administered Oracle since version 7 and hold Oracle Certified Professional certifications for every major version from 8 to 12c, plus Certified Expert for performance tuning, RAC and Oracle on Linux. Today we run Oracle 19c with Data Guard, PostgreSQL with Patroni on Kubernetes, MariaDB Galera and Exasol side by side.

Typical tasks

  • Oracle from single instance to RAC and Data Guard: setup, cloning, upgrade, operations
  • Upgrades across several major versions, most recently 12.2 and 18c to 19c
  • Backup and recovery with RMAN, standby databases, Enterprise Manager
  • Introduce Oracle APEX and ORDS; migrate Forms applications to APEX
  • PostgreSQL as a Patroni cluster on Kubernetes, MySQL 8 and MariaDB Galera
  • Build and run Exasol and MS SQL Server
  • Oracle SQL and PL/SQL tuning

From practice

On behalf of DXC Technology, which runs apoBank’s systems, we upgraded the Oracle databases of two data warehouse systems from 12.2 and 18c to 19c between 11/2019 and 06/2021, introduced Exasol 6.2, installed APEX and ORDS and automated the installation of various software products with Ansible. Context: bank risk management and regulatory reporting.

An older example: in October 2002 we improved the response time of a ticketing application on Oracle and Solaris at WestLB in Düsseldorf by a factor of 10.

Frequently asked questions

Which Oracle versions do you support?
Every major version from 7 to 19c, certified as Oracle Certified Professional for 8 to 12c. Most recently we upgraded data warehouse databases from 12.2 and 18c to 19c.
Do you also do PostgreSQL?
Yes. We build and run PostgreSQL, also as a Patroni cluster on Kubernetes, and advise on moving from Oracle where it makes sense.
How do you approach an Oracle upgrade?
With a clone, a test upgrade and measurements before the production date. We have supported upgrades across several major versions at banks and telecoms, mostly in weekend windows.
Do you help with performance problems?
Yes. Oracle Certified Expert for performance tuning; we look at SQL, instance and operating system together. In a short assignment at WestLB we improved a response time by a factor of 10.

Not sure which field fits?

Describe the problem to us, not the technology.

Contact