Go to Website
  • en
  • de

Rolf (Dipl. ing (fh)) G.

Developer & Designer

Hamburg, Germany

Experience

Jan 2019 - Aug 2025
6 years 8 months

Developer & Designer

Security Authorities

  • Migration of a case processing system with numerous interfaces to other systems from Spring and Activiti to a Java JEE application
  • further development into a cloud application
  • project role: Developer & Designer
  • Technologies/Methods: Oracle 19c, PL/SQL, dbms_aq, Oracle Text (ctxsys), Oracle Unified Audit Trail, ORDS, DB performance optimization, BPMN, Activiti, Groovy, WebLogic, Payara, Java, JavaEE, Spring, JPA, QueryDSL, JPQL, EclipseLink, JAXB, SOAP, CDI, JSON, XML, SUPERCSV, JSF, PrimeFaces, Serenity, Git, TortoiseGit, SVN, Scrum, Bitbucket, Jira, Confluence, SonarQube, MS Office, Maven, Jenkins, IntelliJ IDEA, Eclipse, Oracle SQL Developer, Oracle Data Modeler, Kubernetes, Artifactory, GitLab, Mattermost, GitHub Copilot, agile environment
  • Consulting
  • Development
  • gathered, specified and designed requirements
  • coordination with upstream and downstream systems
  • data modeling, further development, programming, implementation
  • support in code reviews and ensuring clean code in the PL/SQL context
  • documentation in Confluence
  • troubleshooting PL/SQL applications, including log analysis, session tracing and performance profiling
  • optimization and tuning measures in the PL/SQL environment
  • knowledge transfer & onboarding of new team members
  • use of Jira for task management, progress tracking and sprint planning
Jul 2017 - Dec 2018
1 year 6 months

Developer & Designer

Otto GmbH & Co. KGaA

  • extension of receivables management and implementation of new functional requirements
  • approach for evolving into a cloud application
  • project role: Developer & Designer
  • Technologies/Methods: Oracle 12, PL/SQL, utPLSQL, DB performance optimization, GlassFish, JavaEE, REST, JSON, XML, SVN, TortoiseSVN, Scrum, Bitbucket, Jira, MS Office, Maven, Jenkins, IntelliJ IDEA, Eclipse, Oracle SQL Developer, Oracle Data Modeler, Toad, AWS, FishEye, HP ALM, Crucible, Splunk Reports, agile environment
  • Consulting
  • Development
  • gathered, specified and designed requirements
  • coordination with upstream and downstream systems
  • data modeling, further development, programming, implementation
  • testing the application with utPLSQL
  • support in code reviews and ensuring clean code in the PL/SQL context
  • documentation in MS Office
  • troubleshooting PL/SQL applications, including log analysis, session tracing and performance profiling
  • optimization and tuning measures in the PL/SQL environment
  • knowledge transfer & onboarding of new team members
  • use of Jira for task management, progress tracking and sprint planning
Feb 2017 - Jun 2017
5 months

Developer & Designer

Otto GmbH & Co. KGaA

  • extension of supplier processing and implementation of new functional requirements
  • project role: Developer & Designer
  • Technologies/Methods: PL/SQL, SQL, utPLSQL, Java, GlassFish, SVN, Git, Bitbucket, Jira, HP ALM, FishEye, Crucible, Cherwell Service Management, AWS, Maven, Jenkins, Eclipse, IntelliJ IDEA, Oracle SQL Developer, Toad, Splunk, agile environment
  • Consulting
  • Development
  • gathered, specified and designed requirements
  • coordination with upstream and downstream systems
  • data modeling, further development, programming, implementation
  • testing the application with utPLSQL
  • support in code reviews and ensuring clean code in the PL/SQL context
  • documentation in MS Office
  • troubleshooting PL/SQL applications, including log analysis, session tracing and performance profiling
  • optimization and tuning measures in the PL/SQL environment
  • knowledge transfer & onboarding of new team members
  • use of Jira for task management, progress tracking and sprint planning
Sep 2016 - Feb 2017
6 months

Developer

MMP Services

  • creation of a configuration tool for direct marketing systems with Ruby on Rails
  • project role: Developer
  • Technologies/Methods: MySQL, PL/SQL, SQL, Ruby on Rails, IntelliJ, MS Office, Oracle SQL Developer, Scrum, agile environment
  • Consulting
  • Development
Sep 2016 - Jan 2017
5 months

Developer & Designer

Deutsche Post Brief

  • Oracle DB migration and extension of interfaces from Oracle 11 to Oracle 12
  • project role: Developer & Designer
  • Technologies/Methods: Oracle Database 12c, Data Pump, PL/SQL, Unit Tests, Java, Spring
  • Consulting
  • Development
  • coaching internal developers
  • takeover and adjustment of the existing database schema using Oracle Data Pump
  • customization and extension of PL/SQL packages
  • data transfer with Oracle Data Pump
  • creation of unit tests with Java/Spring
Jul 2013 - Aug 2016
3 years 2 months

Developer & Designer

Otto GmbH & Co. KGaA

  • New development of a backend system for handling customer orders in multichannel retail
  • Role in the project: Developer & Designer
  • Technologies/Methods: Oracle Database 11g, PL/SQL, SQL, utPLSQL, Java EE, GlassFish, SVN, Jira, FishEye, Crucible, HP ALM, Cherwell Service Management, Maven, Jenkins, Oracle SQL Developer, Toad, agile environment
  • Consulting
  • Development
  • Setting up a test environment
  • Coaching internal developers
Jul 2012 - Jun 2013
1 year

Developer & Designer

Bombardier

  • Maintenance of a train scheduling system
  • Role in the project: Developer & Designer
  • Technologies/Methods: Oracle Database 11g, PL/SQL, Advanced Queuing, XML, SQL, C++, MFC, Microsoft Visual Studio, Qt Creator, SVN, Jira, HP ALM, FishEye, Oracle SQL Developer, Toad
  • Consulting
  • Development
  • Coaching internal developers
Jun 2011 - Feb 2012
9 months

Developer & Designer

Deutschepost Brief

  • Migration of the Deutschepost Brief track and trace system hardware and software
  • Role in the project: Developer & Designer
  • Technologies/Methods: Oracle 10+11, Sun Solaris, RedHat, Tomcat 4/5 and 6, Apache v1.x and v2.x, System V packages, RPM packages, PL/SQL, C++, Maven, ksh/bash/cshell scripts, JUnit tests, Oracle Data Pump, JMeter, MS Office
  • Consulting
  • Development
  • Setting up a VM for the development team
  • Taking over and adapting the existing database schema with Oracle Data Pump
  • Data migration with Oracle Data Pump
  • Taking over an archive of documents
  • Supporting performance measurements
  • Adapting existing Maven builds
  • Switching from System V packages to RPM
  • Adjusting various scripts
  • Adapting C++ interface programs
  • Adapting JUnit tests
  • Creating load test scenarios with JMeter
  • Creating system documentation
  • Migrating a document archive
Nov 2003 - May 2011
7 years 7 months

Developer & Designer

Deutschepost Brief

  • Extension of the Track & Trace Brief system: adding and expanding various new interfaces and components
  • Role in the project: Developer & Designer
  • Technologies/Methods: setting up a VM for the development team, taking over and adapting the existing database schema with Oracle Data Pump, data migration with Oracle Data Pump, performance measurements, adapting existing Maven builds, switching from System V packages to RPM, adjusting various scripts, adapting C++ interface programs, adapting JUnit tests, creating load test scenarios with JMeter
  • Consulting
  • Development
Dec 2002 - Oct 2003
11 months

Developer & Designer

Deutschepost Brief

  • Further development of the Track & Trace Brief system
  • Role in the project: Developer & Designer
  • Technologies/Methods: migrating an existing document archive from Reliant Unix to Solaris, extending various existing interfaces, adapting C++ backend processes
  • Consulting
  • Development
  • Coaching internal developers
Jul 2001 - Nov 2002
1 year 5 months

Developer & Designer

Deutschepost Brief

  • Migration of Track and Trace for letters from Reliant Unix to Sun Solaris
  • Role in the project: Developer & Designer
  • Technologies/Methods: Migration of interfaces from Reliant Unix to Sun Solaris, adaptation of C++ backend processes
  • Consulting
  • Development
Jun 1999 - Jun 2001
2 years 1 month

Developer & Designer

Deutschepost Brief

  • Further development of Track and Trace for letters and migration from Reliant Unix to Sun Solaris
  • Role in the project: Developer & Designer
  • Technologies/Methods: Creation of various data transfer scripts, optimization of a high-volume system, performance measurements on a high-volume system, creation of C/C++ programs for data conversion, package building on Unix systems, PL/SQL procedures for statistical data analysis, import functions into an Oracle database, extension of C++ processes for controlling a document archive, extension of a Java application, creation of various interface concepts
  • Consulting
  • Development
Jul 1998 - Apr 1999
10 months

Development and Design

Dräger

  • Calibration of a CO2 sensor: determination of limit and characteristic values from raw data for creating a protocol
  • Role in the project: Development and Design
  • Technologies/Methods: Delphi 3.0, Mathematica, Windows NT 4.0
  • Consulting
  • Development
Sep 1994 - Apr 1999
4 years 8 months

Development and Design

AFS

  • Object-oriented programming of a system to support a refueling service at multiple airports
  • Role in the project: Development and Design
  • Technologies/Methods: Microsoft Visual C++ 5.0, MFC, Oracle Forms, Oracle DB v7.x, Windows NT 4.0, Windows 95/98
  • Consulting
  • Development
Apr 1993 - Jul 2001
8 years 4 months

Development and Design

EFT Gummiwaren

  • Development of an order management system in Clipper to handle customer and product master data, order entry, invoice creation, dunning process and statistical analysis of orders
  • Role in the project: Development and Design
  • Technologies/Methods: Win 3.11, Windows 95, dBase, Clipper
  • Consulting
  • Development
Apr 1993 - Sep 1994
1 year 6 months

Independent Development and Design

Bendig Inkasso

  • Development of a system to manage debtors and their debt cases in Clipper
  • Role in the project: Independent Development and Design
  • Technologies/Methods: DOS, Windows 95, dBase, Clipper
  • Consulting
  • Development
Aug 1992 - Feb 1993
7 months

Development and Design

Siemens AG

  • Creation of an order processing system in a test and diagnostic center using Informix with the 4GL programming language
  • Role in the project: Development and Design
  • Technologies/Methods: Sinix, Informix DB, 4GL
  • Consulting
  • Development

Summary

  • Oracle databases (up to version 19c) – development and design of PL/SQL solutions and database models
  • Performance optimization and tuning of Oracle databases
  • Java development – backend-oriented with a focus on maintainable and scalable high-performance applications

Languages

German
Native
English
Advanced

Education

Sep 1992 - Aug 1998

FH Wedel

Diploma in Engineering · Computer Engineering · Wedel, Germany

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Ulrich C.

Java Architect/Developer – Freelancer

View Profile
Rainer D.

Application System for Asset Managers

View Profile
Michael K.

Software Developer

View Profile
Patrick W.

AI Software Engineer

View Profile
Werner K.

Test Coordinator, Designer and Engineer

View Profile
Timo K.

Senior Fullstack Developer

View Profile
Johannes E.

Senior Application Developer

View Profile
Jürgen B.

Software Developer

View Profile
Thomas R.

Architect, Developer

View Profile
Mohamed K.

15 years of practical experience, expert in digitization, process automation & custom software solutions for SMEs

View Profile
Robert M.

Backend Developer

View Profile
Jan fabian R.

Software Engineer / Software Architect / Team Lead

View Profile
Rodrigue K.

Fullstack Development

View Profile
Jan M.

Founder, Senior Solution Architect, TeamLead, Senior DevOps-Engineer

View Profile
Rainer B.

Senior Developer

View Profile
fratch Part of Bitkom logo
linkedIncrunchbaseyoutube
  • English
  • Deutsch

2025 © FRATCH.IO GmbH. All rights reserved.