MariaDB Experts in Munich

Oracle Project Management and Automation

As part of the project, the operation of an Oracle infrastructure was automated by developing and enhancing Puppet modules and migrating existing Bash scripts to a standardized configuration management solution.

The aim of the project was to standardize and automate administrative processes, improve the maintainability of the Oracle platform, and increase the efficiency and traceability of infrastructure management through the use of Infrastructure as Code.

• Analysis and migration of existing Bash shell scripts to a Puppet-based automation solution
• Development and enhancement of Puppet modules for Oracle environments
• Automation of installation, configuration and operational processes using Infrastructure as Code
• Standardization and optimization of configuration management for Oracle systems
• Creation and maintenance of technical and operational documentation
• Planning, coordination and professional support during project implementation
• Operation and automation of Oracle systems on x86-based Linux server platforms
• Testing and quality assurance of the developed Puppet modules
• Analysis and resolution of technical errors as part of the automation and migration
• Close coordination with specialist departments and infrastructure teams to implement automation requirements

Technologies used: Puppet 7/8, SLES 15, Oracle 19, Oracle Grid, SVN, Windows Server, Confluence, VS Code, Ruby, Bash, Pass

• Building, implementing and selling automated Data Science solutions such as Scorecard Factory and Forecast Factory
• Implementation of automated end-to-end cloud processes
• Development of LLM and NLP models
• Creation of interactive reports
• Support for national and international large corporations as well as medium-sized companies in implementing ML projects

Tasks

• Further development of a new ERP system with Blazor
• Generation of e-invoices in the XRechnung and Zugferd formats
• UI/UX design Client-server system
• Windows 11 Technology
• Microsoft .NET 9, Git, Azure DevOps, ASP.NET, MSSQL, Blazor Programming languages
• C#, MVVM Development tools
• Microsoft Visual Studio .NET 2022 Database
• MSSQL Industry
• Other

• Building an independent enterprise IT setup — cloud strategy, network, AWS landing zone, security requirements, contract negotiations.
• Migration of all applications; avoiding high contractual penalties for the client.
• Onboarding and coordination o...

• Development of dynamic web components for displaying KPIs, intelligent map applications, and operational process analysis tools
• Angular 18+
• Leaflet, MapLibre
• NestJS, JavaScript, HTML, CSS
• PostgreSQL, GraphQL, RabbitMQ
• Gitea, Jenkins, Docker

• Design and implementation of a Laravel backend API for provider-based geo search, feature details, boundary geometries and neighborhood detection.
• The API serves as a server-side proxy, cache and enrichment layer, protecting credentials for external geo services and persisting features, localizations, geometries, hierarchies and neighborhood relationships in MariaDB.
• Key areas included normalization of autocomplete and feature data, caching strategies for expensive boundary/polygon requests, spatial processing of GeoJSON and MultiPolygon geometries, as well as neighborhood detection using hierarchies, bounding box filters and topology checks.
• Additionally, separate production and diagnostic endpoints were created, along with status and error catalogs, discovery logging, a Docker development stack, API documentation, and unit and feature tests.
• Technologies: PHP 8.3, Laravel, REST API, geo data API, GeoJSON, MariaDB Spatial, Eloquent, Laravel Queues, PHPUnit, Mockery, Docker, Docker Compose, API design, geocoding, boundary data, spatial queries.

• Risk Management
• Incident Management
• Security Analysis
• Secure Coding
• Information Security Management System (ISMS)

• Building the company with a focus on connectivity for IIoT and Industry 4.0, iRPA/process automation, advanced robotics and smart systems, sensors and services
• Project management and software architecture for IoT gateway development (since 2020) with protocol translation, IT/OT convergence and GRC
• Developing RPA bots for automating and monitoring industrial processes with an agent-based AI approach (since 2020)
• Implementing unsupervised clustering and anomaly detection for time series data in big data streaming pipelines (since 2021)
• Introducing a Docker-based release train for OTA updates with DevSecOps and CI/CD (since 2018)

• The software supports the complete planning and approval of antennas for mobile telephony.

• The system was implemented using an event-driven microservice architecture for cloud-native deployment with Quarkus on the backend, Kafka for communication, and Angular for the frontend. Services run on Kubernetes in Google Cloud. A special challenge was synchronizing with the legacy system still used by some users.

• Further development of Excel templates for the electrical industry
• Design and development of new analysis functions
• Extension of Excel templates for data analysis
• Use of Excel and VBA