Nils Meyer
DBRE and DevOps Specalist
Erfahrungen
PostgreSQL Cloud Migration
mrge Group GmbH / shopping24
Shopping24 develops tailored e-commerce solutions for product recommendations. The scope of the project was twofold: Assess the current state of the database systems and ensure working backups as well as high-availability and prepare the existing databases for migration to AWS.
- Ensure working backups with barman and pgbackrest
- Create replicas for databases using pgbackrest
- Prepare existing servers for migration to AWS using pglogical and DMS
- Use ansible to manage the on-prem infrastructure
Technologies used: PostgreSQL, CentOS, barman, pgbackrest, ansible, GitHub, git
PostgreSQL Database Automation
K-Mail Order GmbH & Co. KG
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
PostgreSQL Database Consulting SRE Team
IONOS SE
IONOS offers cloud computing made and based in Germany with a particular focus on GDPR compliance. PostgreSQL is a central piece of the infrastructure for the cloud solution.
- Consulting regarding database structure and performance
- Plan for database upgrade and new, HA setup
- Backup and Restore of databases / tables with barman
- Infrastructure automation with Ansible
- Transfer of database responsibilities to another internal team
- Maintaining Postgres Clusters running on Debian Linux
- Database Monitoring with Prometheus/Thanos and Grafana
Technologies: PostgreSQL, Barman, Patroni, etcd, Proxmox
Consultant PostgreSQL Database
IBM Germany
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
PostgreSQL Database Automation
Ratepay GmbH
Ratepay offers tailor-made payment solutions for online merchants and marketplaces. The focus of this project was to improve the various databases used to run the business.
- Migrating applications from EXASOL to PostgreSQL
- Automating setup of PostgreSQL Clusters
- Setting up highly-available PostgreSQL Clusters using Patroni
- Optimizing SQL Query performance for applications
- Migration of a mission-critical PostgreSQL cluster from BDR2 to BDR3
- Developing backup solutions
- Automating maintenance and setup tasks with Ansible
Technologies used: PostgreSQL, Patroni, 2nd Quadrant BDR, Consul, VMWare ESXi, Ansible, Terraform, git, Debian Linux, HAProxy
PostgreSQL Database Automation
ITSG GmbH
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)
Automation improvement
finAPI GmbH
FinAPI provides a unified API to access banking data as well as additional services for companies developing Applications for FinTech. The technology stack includes Java (Spring), MySQL and ElasticSearch. Tasks included:
- Automating previously manual operations processes freeing up development and operations staff resources
- Migrating existing terraform infrastructure from terraform 0.11 to 0.12
- Reducing code repetition with Terragrunt
- Speeding up creation of new customer accounts by improving automation
- Extending and Improving logging, monitoring and metrics collection
- Database optimization and troubleshooting
- Security and Compliance improvements
- Automating AMI creation and implementing immutable infrastructure
Technologies used: Amazon Web Services (AWS), Ansible, Packer, Terraform, Terragrunt
Infrastructure as Code onboarding
WONDER TECH sp. z o.o.
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
Consultant – Database Operations
Spark Networks SE (NYSE: LOV)
- Building a Database as a Service solution to provide PostgreSQL databases on EC2 Instances
- Ensuring automated testing for Ansible code with Molecule and GitLab CI
- Technologies used: AWS, Linux, Docker, PostgreSQL, Ansible, Molecule, repmgr, pg-bouncer-rr, Terraform, Packer
Consultant – Performance / Reliability Engineering
Parfürmerie Douglas GmbH
- 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)
Consultant – Operations Engineering
ABOUT YOU GmbH
- Maintaining, Extending and Troubleshooting LEMP (Linux, Nginx, MySQL, PHP) applications (Laravel / Lumen) running on AWS
- Developing Ansible roles for use with packer for creating Amazon Machine Images (AMI)
- Assisting in database migration from EC2 Instances to AWS RDS
- AWS cost optimization (scaling policies, instance sizing)
- Onboarding new employees onto the Infrastructure as Code environment
Consultant – Database Administration
Zalando SE (Pricing & Forecasting)
- 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
Consultant – Devops Engineering
OEDIV KG
- Writing comprehensive Ansible playbooks for installing various applications (Atlassian Stack, Owncloud, LAMP) on virtual machines on premises as well as AWS and Azure
- Troubleshooting Java Applications (Atlassian stack)
- Building a CI Pipeline for Ansible playbooks on Gitlab
Consultant – Devops Engineering
ABOUT YOU GmbH
- 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
Zusammenfassung
Experienced in Systems Operation and Software development, bridging the gap between the disciplines. A technology and open source enthusiast since young age, driven and self-directed, 100% self taught. Enjoys debugging and Troubleshooting as well as new Development. Versed in Cloud deployments as well as on-prem and hybrid.
Sprachen
Ähnliche Freelancer
Entdecken Sie andere Experten mit ähnlichen Qualifikationen und Erfahrungen.