Database Administrators in Germany

• Working on the next iteration of tonbo to make it the most flexible in-process analytical database in the market that scales and is operated with strong availability

• Introduced object scope cache to the remote storage layer to avoid I/O churn

• Working on refactoring WAL to support remote storage

• Taking care of the health of the systems as well as designing the operational story and bringing them to production

• Technologies: LSM, WAL, Arrow, Parquet, Rust

• Building the world's largest database of market research service providers and survey platforms ([link]

• Establishing the Microsoft Fabric platform with the company as the central data warehouse and reporting system.
• The company migrated several operational systems including D365 to new version. The new data warehouse is based on a Fabric/Power BI architecture with Azure cloud Entra Authentication.

Tasks Performed:

• Full administrative responsibility for the Fabric platform F64 and F32 capacities, as well as two F8 capacities for development and prototyping.
• Integration of Fabric with Microsoft Entra.
• Data modeling for the data warehouse bronze, silver and gold layers using data modeling tools.
• Star Schema as well as entity relationship modeling.
• Data modeling for data marts and for dimensional modeling and Power BI (semantic model).
• Design of data models for Microsoft SSAS multidimensional and tabular OLAP cubes using DAX and MDX.
• Definition of design patterns for the ETL team for loading OLAP cubes (Tabular and MD), star schemas and data vault structures.
• Planning and managing team of 4 ETL and reporting developers.
• Performance Tuning of Power BI reports, particularly the semantic layer, as well as the Fabric notebooks
• SQL Performance Tuning.
• DB Design for Azure SQL.
• Reporting directly to project senior management.

Label: Power BI, Fabric, Analysis Services (multidimensional and tabular), D365, SSIS, Tabular Editor, SQL Server and Azure SQL, TOAD Data Modeler, DBSchema, Visual Studio Code, DAX Studio, SSMS, Visual Studio, Jira and Confluence.

Are you looking for more than just a developer, but a partner who understands business processes and develops sustainable solutions? Then I am the right person for you.

For more than 24 years, I have been helping companies develop software solutions, use data intelligently, and make business processes more efficient. I combine solid technical expertise with a deep understanding of business operations and economic relationships.

My focus is on developing custom software and database solutions as well as integrating existing systems. I have implemented numerous projects in which CRM, ERP, webshop, logistics, and other business systems were connected with each other. The result is automated processes, less manual work, and higher data quality.

I also develop business intelligence and data warehouse solutions as well as management reports that give decision-makers a reliable data basis at any time.

I get up to speed quickly in existing systems and also find practical, cost-effective solutions for complex requirements. I always keep the overall system in view - not just individual lines of code.

My services at a glance:

• Custom software development
• Database development and performance optimization
• Business Intelligence & Data Warehouse
• Management reporting and dashboards
• ERP, CRM, webshop, and logistics integration
• Interface development and process automation
• Analysis and optimization of business processes
• Technical consulting and solution architecture My clients value my structured way of working, my quick grasp of things, and my high standards of quality. I think like an entrepreneur, communicate on equal footing, and develop solutions that work well in the long run.

My goal is simple: simplify processes, make data usable, and help companies become more successful with well-thought-out software solutions.

• Complete redesign of IT infrastructure including setup of a server room according to BSI standards, new network concept and planning.
• Development of security concepts and IT security consulting for the DHCP/DNS election sector.
• Support of project management for the customer in the VOIS | MESO area.
• Technical support for setting up the IT infrastructure in new offices, including firewall configuration, router setup and network planning.
• Setup and configuration of the service management and ticket system JIRA.
• Implementation and administration of the Azure (Entra) environment for all employees.
• Setup and administration of the Confluence environment.
• Planning, setup, configuration and administration of the entire Atlassian Collaboration Suite.
• Development of BCM strategy options.
• Development and implementation of measures and creation of BCM plans, as well as evaluation of existing BCM.

• An old software has no documentation and the developers are not available. The data needs to be prepared for a new system. A long transition phase must be ensured.
• Create the database relationship diagram
• Develop a service for file exchange
• Prepare structures for new requirements
• Revise the old building authority program in Delphi
• Secure documents in the DMS
• Ensure parallel operation through data exchange via ETL processes
• C#, Visual Studio 2022, Git, Delphi, MS SQL 2022, T-SQL, DataGrip

• Development and implementation of backend components with PL/SQL and Oracle Forms 12c. Adaptation and further development of the policy administration system. Technical consulting in UI design with a focus on integrating existing Oracle Forms and the requirements of the BIPRO framework.
• The project takes place in the technical environment of BIPRO, SQL databases and Oracle Forms applications. The assigned work includes backend development and technical further development in the above project with the following tasks:
• Development and implementation of backend components with PL/SQL and Oracle Forms 12c to technically map the business processes and ensure a stable and efficient system architecture
• Adaptation and further development of the policy administration system to ensure system functionality in line with the requirements of the new broker communication program
• Analysis of the existing system to identify and avoid errors and technical problems during implementation, in order to enable a smooth transition to the new system
• Carrying out patching and further development of existing Oracle and Oracle Forms applications to ensure compatibility and security of the systems in use
• Technical consulting in UI design with a focus on integrating existing Oracle Forms and the requirements of the BIPRO framework.

Label: PL/SQL, Java, Oracle RDBMS and Oracle Forms

• Supporting the client in maintaining a custom monitoring solution for Oracle databases.

• Exasolution DBA server consulting and migration to version 8
• Analysis of SQL query performance and tuning
• Troubleshooting batch scripts
• Technologies: GitLab, EXACloud, EXAOperation, DBeaver, Control-M

• Patch management
• Support in database development
• Installation and upgrades of the following Oracle systems:
• Oracle Analytics Server (6.4)
• Oracle Enterprise Manager Fusion Middleware Control
• Oracle Data Integration Server
• Oracle BI Administration Tool
• Oracle WebLogic

• Database administration and performance tuning for Oracle databases on AIX 7.1, 7.2 with Oracle 12c and 19c
• Troubleshooting and resolution on RHEL 7
• Automation of operations with UNIX/Linux shell scripts, Perl programs, and PL/SQL
• Planning, preparation, execution, and customer-specific review of changes and upgrades for the LEASMAN and DOXIS applications
• Incident handling including communication with outsourcing service providers and business units
• Data exchange with Data Pump
• Visualization of database content and monitoring results
• Configuration of databases for Debezium and monitoring Debezium activities
• Preparation of Oracle databases for migration to cloud environments
• Implementation and monitoring of NIST requirements in databases
• Automation of release upgrades for the LEASMAN application
• Creation of operations manuals and instructions
• Generation of reports for GDPR information requests

• Oracle databases 11g, 12c and 19c RAC
• Installation, configuration and deployment of Oracle Fusion Middleware 11g & 12c (WebLogic, SOA, Oracle Forms and Report Server, etc., OBIA)
• Administration of Oracle 11g, 12c, RAC and 19c
• Applying patches
• Installation, configuration and deployment of Tomcat
• Oracle tuning
• The system includes several production, QA, test & development Oracle databases and WebLogic application servers 11g & 12c

• Developed automated tools for train passenger information with PostgreSQL/PostGIS (administration & development)
• Used imposm, osm2pgsql, pgsql2shp, GeoServer (WMS, WFS, WCS, etc.)
• Used various geo formats, e.g. OpenStreetMap (OSM)
• Technologies: PostgreSQL/PostGIS, imposm, osm2pgsql, pgsql2hp, ESRI Shapefiles, QGIS, Python 3.x, PyDev, Eclipse, Linux, AWS, OSM, XML, bash, pgsql, Docker