Contract PostgreSQL and EnterpriseDB database consultant

4/2018 – offen

Assisting multiple clients including the Registers of Scotland, EOH Europe Ltd, Oscar Music and Media Ltd, Seeburger AG, Tatras Data, AgSpace Ltd, SalesQL, GfK, the EdTechHub and many more, all requiring hands-on assistance and knowledge transfer to help them integrate their existing local and cloud-based PostgreSQL databases with modern Open Source tools
including TICK / EFK stacks with Grafana / Kibana dashboards, Ansible and Jenkins CI/CD automation.
Tasks include among others optimising the performance of local and cloud-based database instances by tuning both hosts and queries, resolving potential streaming and logical replication issues, implementing site-wide database updates via Ansible, Jenkins and Git with live monitoring dashboards, migrating out PostgreSQL committed data via logical decoding into Apache Kafka topics
as well as creating database reporting scripts for Jira / Confluence or Barman centralised backups using Bash or Python.

Postgresql, Red Hat Enterprise Linux (RHEL), Bash Shell, Jenkins, Python, Ansible

3/2015 – 4/2018

PostgreSQL and EnterpriseDB Postgres Plus DBA.
Database management, tuning and training workshops for EMEA Postgres clients

Red Hat Enterprise Linux (RHEL)

11/2012 – 3/2015

PostgreSQL and EnterpriseDB Postgres Plus Database Administrator

Microsoft SQL-Server (MS SQL), Mysql, Oracle-Anwendungen, Postgresql