DBRE and DevOps Specalist

The project here concerned the returns processing of the company for its own shops as well as third parties, the total scope of the project was a migration from a mainframe based legacy system to a new system based in Java Applications with PostgreSQL as a database running on a mix of CentOS, RHEL and Ubuntu Linux Vms.

• Develop Ansible Roles for managing PostgreSQL instances
• Automated Testing of Roles using molecule as well as GitLab CI
• Database migration and major version upgrade using pglogical replication
• Database backup with wal-g
• Consulting on database table structure and performance optimization
• PostgreSQL Monitoring and Alerting with Icinga
• PostgreSQL Log shipping to ElasticSearch using fluentd

Technologies: PostgreSQL, wal-g, pglogical, GitLab, git, icinga, fluentd, ElasticSearch, molecule, gitlab-ci, CentOS

The "e-Rezept" project is part of the digital transformation of the German healthcare sector. This project concerns the handling of prescriptions for medication digitally, planned to handle hundreds of millions of digital prescriptions per year from issuance to billing.

• Work on database design, choice of appropriate table structure, data types and partitioning for a multi terabyte database including encrypted data
• Python scripting for data expiration
• Assist in High-Availability setup planning

Technologies used: PostgreSQL, repmgr, barman, Python 3, RHEL 8, IBM Cloud

ITSG provides IT services (Hosting and Development) for German statutory health insurance (gesetziche Krankenversicherung). The project involved setting up PostgreSQL databases for the CI/CD, Collaboration and Automation platforms for a project.

• Capacity planning for database servers
• Backup Concept
• Automation Code in Ansible
• Streaming Replication with repmgr
• Backup with barman

Technologies used: PostgreSQL, Ansible, RedHat Enterprise Linux (RHEL) 8, VMWare ESX, Barman, RepMGR, git (gitlab)

Wonder is a Polish online-shop startup, selling furniture and home accessories. The shop is built using mostly JavaScript for Frontend (vue.js) and Backend (express) with node.js, MySQL, redis and ElasticSearch. The site is hosted in the cloud at AWS. The project involved moving manually created resources to an automatically deployable setup using DevOps methods and Infrastructure as Code. Tasks performed included:

• Planning and setup of multi account setup separating production and non-production resources
• Automatic the creation of machine images using packer and ansible
• Configuration of resources using Terraform and Terragrunt
• Database optimization
• Disaster Recovery strategy
• Setup of Autoscaling for resources and cost optimization with mixed instances

Technologies used: Amazon Web Services (AWS), Ansible, Packer, Terraform, Terragrunt

• Successfully assisted the customer in preparing their complex e-Commerce site for Black Friday, achieving 100% availability in a high-revenue, business-critical phase
• Performance Analysis, Load Testing, Configuration review
• Making recommendations and applying to the production code and configuration
• Technologies: Java/Scala/JVM, SAP Hybris, Tomcat, InfluxDB, Grafana, Graylog, ElasticSearch, Sensu, StormForger, nginx, HAProxy, SaltStack, proprietary components (Prudsys, FactFinder)

• Optimizing of legacy database infrastructures based on MySQL and complex stored procedures
• Migration of ETL processes from Bash scripts / Stored Procedures to Python, Airflow and docker
• Preparation of database migration to PostgreSQL on AWS

• Assisting in Migration to AWS
• Creating CloudFormation Templates
• Moving Databases to AWS RDS
• Creating and upgrading ansible playbooks
• Troubleshooting of Problems with MySQL databases, Redis Key Value Stores
• Assisting Teams in troubleshooting PHP (Laravel/Lumen) based Applications