SQL Experts in Cologne

• Further development of the existing e-commerce platform based on SAP Commerce (Hybris) to meet the growing demands of digital commerce.
• Ensuring the scalability and performance of the backend, so the platform remained stable and efficient even under heavy user load.
• Development and integration of new OCC REST APIs and services for modular extensions and flexible adjustments, to implement new features quickly.
• Optimization of data flows and interfaces, which significantly improved platform efficiency and system performance.
• Ensuring a maintainable and scalable code base by using Clean Code principles, proven design patterns, and a future-proof architecture.
• Reduction of errors through extensive testing with JUnit, Mockito, and load tests with Gatling, supported by the introduction of automated test processes.
• Improved system performance through targeted refactoring measures and efficient database queries, especially to handle peak loads.
• Use of modern cloud and monitoring tools such as Kubernetes, Google Cloud Platform (GCP), and Grafana to ensure a stable and monitored infrastructure.
• Clear improvement in efficiency, scalability, and reliability of the platform, which now meets the demands of a dynamic and growing e-commerce market.

With project PRIZMA, DB will modernize its infrastructure on the one hand, and develop a fail-safe IT landscape on the other hand, which can be restored quickly and securely in case of a disaster.

• Capture current architectures of existing systems as well as methodical consulting and development of target architectures
• Deepen and maintain the building plan / target IT landscape
• Implement technical architecture concepts & architecture descriptions
• Implement migration concepts for updating and further developing the platform and information systems
• Assess submitted improvement suggestions as part of the project
• Capability management: identify capability gaps, develop target visions, and support transformation planning within the enterprise architecture.
• Create a compatibility matrix of the components in use and compare dependencies of specific versions
• Create an IT concept for extending the platform with the following topics: hardware and software requirements, security, licensing, high availability, load balancing, backup & recovery, update strategy, monitoring integration, etc.
• Coordinate with business architects as well as technical architects from the cross-functional architecture area of the PRISMA program for the topics (backup, Active Directory, monitoring, Citrix, and business applications ...)
• Status meetings and alignment of project planning with the Release Train Engineer / Project Manager
• Advise the Release Train Engineer / Project Manager in identifying project risks
• Advise the System Architect Engineers in steering the implementation of the concept
• Implement the IT concept
• Document the infrastructure

Label: MS Project, LINUX, Windows, ORACLE, Java, REST, SharePoint, Microsoft Exchange, UML, Enterprise Architect, BPMN, AZURE, AWS, V-MODEL, Micro Service, VisualStudio, SAP S/4HANA, SCRUM(SAFE), ESB (TIBCO), Python, Innovator, LeanIX (TOGAF), Ansible, Ansible Tower, Ansible Automation, ROBOT, SpringBoot

• Planning and implementation of a migration strategy for master and transaction data for the continuous loading of a cloud-independent database
• Creation and pilot implementation of a company-wide Business Data Model for customers, suppliers, contracts, products, prices, consumption, invoices, and dunning
• Concept and consulting for a Data Governance Framework incl. definition of committees, roles, processes, and metadata model
• Operationalization of the Data Governance Framework with definition of data standards
• Sub-project management in two pilot projects (PoCs) for Data Governance systems (ErwinDIS and Atlan)
• Training and coaching the data team in migration, data quality, and data modeling

• Project: ESU Windows and SQL Server consolidation / Configuration Management in ServiceNow
• Creation of an as-is analysis of all servers worldwide
• Creation of an as-is analysis of all SQL servers worldwide
• Creation of requirements analyses for SQL and server migrations
• Coordination of requirements with partners for migrations to Hyper-V (on-premises) or Azure Cloud
• Moderation of jour fixe meetings
• Creation of roadmaps and solution models for server migrations
• Setup of test scenarios
• Moderation of workshops for the introduction of a Global Admin Team
• Creation of data models (CMDB) in ServiceNow
• Conducting workshops for the CMDB data model
• Creation of solution models for the CMDB
• Creation of seamless configuration and work documentation for the CMDB
• Creation of reports for license management
• Creation of KPIs for data quality in ServiceNow
• Creation of a service catalog
• Moderation of workshops for creating service requests
• Interface between needs analysis and ServiceNow development team
• Systems used: Windows 7, Windows 10, Microsoft Office 365/2010, Windows Server 20xx, SQL Server 20xx, SharePoint, Azure Cloud, Hyper-V, ServiceNow, various tools

• Coordination and planning, execution, documentation, and analysis of test cases
• Development of test concepts considering best practices (e.g., test pyramid) with a focus on reliable, automatable test runs
• Implementation and maintenance of test cases according to the test concepts
• Technologies: Citrix Workspace, Shopify, Jira, Xray, MS Teams, MS SharePoint, Confluence, MS Office 365

• SPA for automated communication of medical findings with role-based access (Sanctum)
• Server-side LLM integration (OpenRouter) with structured processing
• Automated sending via SMS/voice call (Twilio, ElevenLabs) with queue + status retry
• Full test coverage with 80+ documented test cases

Technologies: PHP, Laravel, LLM API (OpenRouter), Twilio, ElevenLabs, Laravel Sanctum, PHPUnit, Playwright, Docker, REST

• Supporting the DevOps team in Terraform-managed, multi-region AWS infrastructure to achieve environment parity.
• Developed end-to-end CI/CD pipelines using AWS CodePipeline, CodeBuild, and CodeDeploy, automating the build and deployment.
• Maintained pre- and post-deployment scripts to automate critical tasks such as database schema migrations and environment sanity checks.
• Implemented CI/CD flow specifically for hotfixes via separate Git branches, managing back-merge activities from feature branches to release branches to ensure code integrity through automated conflict resolution.
• Deployed a dedicated, lightweight sanity check application hosted cost-effectively on Azure Container Apps to run automated health and basic functional checks as a post-deployment activity triggered via pipeline.
• Investigated production incidents through code changes and AWS CloudWatch logs.
• Coordinated integration of Dynatrace APM and its APIs for monitoring purposes.
• Full stack QA strategist for a high-traffic e-commerce platform built on a layered architecture for the back-end testing of core platform services, especially the order management system in Zed and Glue layers.
• Managed automation activities, testing process, and refactoring practices.
• Responsible for framework migrations, setup, and training for new automation frameworks.
• Promoted a shift-left approach within the QA team and created the test concept.
• Participated in meetings with IT managers, business owners, product owners, and team members.
• Designed and implemented contract testing to validate API schema compatibility between the order management system and the Zed and Glue layers, reducing production-relevant breaking changes by approximately 3%.
• Led the migration to a multi-environment framework that enabled test execution across 4 country configurations from a single codebase.
• Integrated automated unit and functional tests directly into the GitLab CI/CD pipeline, reducing pipeline runtime by 32%.
• Coached and trained 5 QA engineers across Germany and Hungary in test automation, framework architecture, and best practices.
• Architected a layered backend test automation framework separating business logic, API request builders, and the database layer.
• Piloted AI-assisted testing with Playwright Agents, the Playwright MCP Server, and GitHub Copilot for automated test generation, execution, and self-healing Playwright scripts.

Architected and maintained data products for renewable energy operations, covering wind turbine, grid-meter, and weather data. Built scalable ETL/ELT pipelines in Azure Databricks using Delta Lake (bronze/silver/gold layers) and processed data in various formats, including structured and semi-structured data. Contributed to a data quality framework supporting table and column documentation, outlier detection, and completeness metrics across all datasets within a data product. In addition, implemented a DORA KPI Databricks dashboard used across all data products. Optimized CI/CD processes in Azure DevOps to streamline deployment across development, test, and production environments.

Technology stack: Azure Databricks, PySpark, SQL, Delta Lake, Unity Catalog, Azure Data Lake, APIs, Dremio, Azure DevOps, YAML, Git, Databricks Workflows, Application Insights, Terraform, OpenAI API, Codex, LLM-assisted workflows

PLANT-MY-TREE®-per-order

The application enables Shopify merchants to automatically place tree-planting orders for every incoming order. By integrating ecological contributions directly into the purchase process, the manual effort for tracking and billing reforestation initiatives is eliminated. The system increases transparency for end customers through real-time visualizations of the ecological impact directly in the storefront. The architecture is based on a modular monolith with Spring Boot in the backend and an integrated React app inside the Shopify admin area. The solution uses webhooks to capture order data in an event-driven way and integrates the weclapp ERP system for automated monthly invoicing. An app proxy mechanism provides dynamic statistics such as CO2 compensation and planted trees without any performance loss for the merchant shop.

Tasks:

• Design of the modular software architecture based on Spring Modulith to ensure high maintainability
• Development of the event-driven business logic for evaluating Shopify orders via webhooks
• Implementation of automated invoicing by connecting the weclapp REST API
• Building the frontend using React Router and Shopify App Bridge for native integration
• Design of the database model and implementation of the persistence layer with JPA/Hibernate and Prisma
• Integration of internationalization processes for global use in the frontend and email communication
• Automation of deployment processes using Docker and GitLab CI/CD

Project skills: Java 25, Spring Boot, Spring Security, Spring Modulith, Hibernate, JPA, REST API, PostgreSQL, Maven, Liquibase, React, TypeScript, React Router, Vite, Node.js, Prisma, Zod, Docker, Docker Compose, GitLab CI/CD, Shopify CLI, Shopify App Bridge, Polaris, weclapp, i18next, Lombok, Vitest

• Structured analysis and evaluation of business processes

• Gathering, documenting, and prioritizing requirements

• Creating business-friendly and technically executable process models

• Use of Camunda tools

• Deriving requirements and interfaces from BPMN diagrams

• Coordination with stakeholders and business units

• Translating business requirements into technical solution designs

• Implementing efficient and tailored applications

• Systematic collection, analysis, and documentation of requirements

• Prioritizing and validating requirements in close collaboration with stakeholders

• Alignment between business and development to ensure shared objectives

• Creating use cases, user stories, and acceptance criteria

• Continuous requirements and change management throughout the project lifecycle

• Define project goals and create project plans

• Delegate tasks and monitor project progress

• Monitor budgets and inform stakeholders

• Mendix: Architecture, development, and maintenance of custom applications (Microflows, Domain Model, Security, XPath)

• Modeling Mendix workflows for process optimization

• Develop scalable apps with Mendix including REST/SOAP integration with SAP, SQL, Azure & SharePoint

• UI design for Mendix using Atlas UI, Fluent UI, HTML, CSS, JavaScript

• Develop web & mobile apps with Mendix using agile methods (Scrum, Kanban)

• Implement business logic with Mendix Microflows and Nanoflows

• Performance optimization and architecture improvements for Mendix applications

• Conduct Mendix training

• Create technical documentation and best practices for Mendix

• Coaching and mentoring for low-code development with Mendix

• Integration of medical modalities (including ultrasound) into the existing IT infrastructure (DICOM, HL7) – put into operation within the planned timeframe.
• Administration and optimization of PACS systems for efficient archiving and distribution of radiology image data across multiple locations.
• Ensuring consistent data quality and seamless interoperability in data exchange between HIS, RIS, and PACS.
• Close collaboration with medical staff to analyze and digitally optimize clinical workflows.
• Requirements management and test coordination when implementing clinical requirements in complex IT structures.

• PRISMA project
• Ansible automation
• Windows third-level support for Windows NT, Windows 2000, Windows 2013, Windows 2016, Windows 2019

Industry: digital sovereignty, public sector

Responsibilities:

• Project coordination (teams: consulting, development, testing, deployment/operations)

Products and standards:

• Jira, Confluence, Asana, Miro, Mural
• Open Source, Keycloak, Open Xchange, ownCloud

Project: Digitalization of Warehouse Processes | Building a Data Analytics Platform.

• Built a web-based workforce allocation system that digitized daily shift planning by matching worker expertise to operational zones, replacing manual coordination with a structured workflow adopted across the site, saving supervisors time on daily planning.
• Developed a real-time operational visibility dashboard giving supervisors a live view of task throughput and outstanding workload across warehouse zones throughout the day, helping reduce overtime and idle labour costs.
• Developed a slotting optimization solution to improve warehouse picking efficiency and reduce picking time per order, working directly with operations teams from concept through production deployment.

Technologies used: Python, Django, PostgreSQL, Pandas, NumPy, HTML, Java, JavaScript, Docker, Kubernetes, AWS, Power BI, GitHub Actions CI/CD, GitOps, Claude, OpenAI