Database Developers 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

• 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.

• Migrating the existing Delphi 2010 version to Delphi 10.4.
• All software products must be made Terminal Server capable.
• Support and further development of the in-house forwarding software until it is replaced by a newly purchased version.
• Technologies: Delphi 2010, Delphi 10.4, Advantage Database, DevExpress, GIT, Devart, OOP.

• 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

• Client: Terex Corporation

• 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

• Replacement of a Java application and the Oracle DB for loading the internal WerWasWo system using SSIS.
• Development of SSIS packages to load text files into the database (SQL Server)
• Development of a database project for deployment on various servers
• Creation of queries to monitor the loading runs
• Development of a PowerShell script to automate the deployment of the SSDT projects.
• Oracle, SQL Developer, Microsoft SQL Server 2022 on-premises, SQL Server Management Studio v21, Visual Studio 2022, SSIS, SSDT, PowerShell.

• Advised and supported application developers on database topics
• Designed and developed interfaces
• Optimized database performance
• Automated rollout and release processes in the database environment
• Implemented security requirements
• Delivered metrics to management
• Developed new scripts to automate rollouts
• Adapted scripts for database deliveries
• Identified and resolved issues during Oracle 12 to 19 upgrades
• Adjusted database parameters, permissions and roles
• Conducted feasibility studies and migrations from AWS EC2 to AWS RDS
• Migrated database delivery versioning from SVN to Git/Artifactory using Ruby and Artifactory REST API
• Analyzed Statspack/AWR reports and optimized long-running SQL statements
• Configured SSL/TLS encryption for Oracle databases including proof of concept and rollout planning
• Configured Kerberos authentication for Oracle users with Active Directory and single sign-on
• Conducted database technology selection workshops for microservices (SQL, NoSQL, Amazon S3)
• Modeled and designed a PostgreSQL Docker instance with liquibase scripts for Git pipeline deployment
• Refactored mass data export interfaces and developed PL/SQL packages
• Developed PL/SQL packages for REST-service communication and SOAP data conversion
• Supported cloud migration of Oracle databases to AWS RDS with migration scripts
• Developed and refactored PL/SQL functions/packages for performance and business logic
• Planned and prepared new database schemas using execution plan analysis and AWR metrics

• Design and implementation of an OCI-based data warehouse and ETL system to replace legacy mainframe applications
• Developed a database optimization strategy and planned the rapid conversion of JCL and COBOL routines to PL/SQL using AI
• Developed an Oracle Apex-based app for internal administrative processes in the public sector (office equipment, staff training)
• Implemented PL/SQL workflows for approval processes and created a responsive mobile version with JavaScript and CSS
• Used Azure DevOps for backlog management and documentation, and Git for version control
• Developed REST interfaces to CRM systems
• Replaced and reprogrammed Oracle Forms screens with Oracle Apex and updated to the latest Apex versions
• Designed a Git branching strategy and conducted code reviews
• Maintained and further developed an EDI-based data exchange system based on Oracle Advanced Queuing for the public sector in Austria
• Performed data analysis and created charts in the Oracle Apex frontend; installed standalone ORDS and Apex 23.1
• Worked agile using the Spotify model; developed complex Apex pages with support from Oracle JET
• Rebuilt and customized existing PL/SQL packages, created workarounds for database version differences, and optimized queries
• Developed Apex applications for broker pools to manage and optimize Oracle databases in the banking environment, including SSO-based authorization systems with OAuth2 and Keycloak
• Built extensive Oracle Apex applications for BI and data mining modernization projects and developed manual and automated projection methods in the frontend
• Carried out data warehousing projects in the banking sector and used Scrum and Kanban in team projects

• Maintenance of a company-wide Oracle database that consolidates information from various internal databases, Active Directory, and other systems

• Data transfer via Oracle jobs between the monitoring database and other systems

• Data visualization and processing using APEX and Oracle Forms (with Forms being replaced by APEX)

• Gathering requirements from business units

• Designing the implementation

• Implementation at the database level and in APEX

• System maintenance

• Troubleshooting

Technologies: Oracle 12, Oracle 19, Oracle PL/SQL, Oracle APEX, SQL Developer

• 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