Oracle SQL Developer Experts in Germany

• Restructuring of the network architecture/topology, followed by installation, setup and testing of the network at a small business.
• Resolution of server (permissions and roles) and connection problems (WAN, (V)LAN, WLAN).
• Infrastructure support and maintenance.
• Creation of documents such as manuals, architecture documents and design documents.
• Revision of manuals and technical documents, as well as creation of VBA macros.
• Use of AI and basic prompting, as well as formulation of AI requests.
• Adjustment of workflows due to legal requirements and optimization of existing workflows.
• Delivery of courses and training for adaptations, new features and changed workflows.
• Modeling basis: BPMN.
• System environment: MS Office 2019/365, Win10/11, Teams, Netgear (Switch), QNAP, Synology (NAS), Linux (Ubuntu).

• Focus: System architecture, cloud-native platforms, microservices, API design
• Product: Pflege-Pfad is a digital placement platform that directly connects relatives of people in need of care with verified care services and caregivers – without an agency and without ongoing fees.
• Business analysis & process design:
• Analysis of the German care market and identification of the key pain points of both target groups.
• Modeling of core business processes: registration, verification, care request, application, placement, and rating.
• Definition of the business model as a freemium/premium model with optional contact unlocking.
• Creation of user stories and requirements documentation for relatives, care services, and administrators.
• Design of trust and quality assurance mechanisms with document upload, admin review process, and rating system.
• Coordination with stakeholders and validation of product decisions with potential users.
• Technical implementation:
• Design and implementation of the entire platform architecture as the sole developer.
• Design and implementation of a REST API with Spring Boot and Kotlin, including JWT-based authentication.
• Development of the frontend as a single-page application with Angular 17.
• Implementation of the AWS infrastructure with EC2, RDS PostgreSQL, S3, CloudFront, and IAM.
• Document upload with AWS S3 using presigned URLs to verify care services.
• Email notifications via Resend API.
• AI-supported care service search via OpenAI API.
• Implementation of complete user flows such as registration, login, password reset, and the placement process.
• Development of an admin panel for user and care service management as well as analytics.
• CI/CD with GitHub Actions and containerized deployments with Docker.
• End-to-end tests with Playwright.

Technologies: Kotlin, Spring Boot 3, Spring Security, JWT, JPA/Hibernate, PostgreSQL, Angular 17, TypeScript, RxJS, AWS (EC2, ECS, S3, CloudFront CDN, RDS PostgreSQL, IAM), nginx, GitHub Actions, Playwright, Maven, Git, OpenAI API, Resend API, Docker, Scrum, i18n (DE/EN/TR), Kiro, feature flag architecture.

• Supporting the International Web Presence of the BA (IntWeb) project in the area of quality management, with the aim of taking responsibility for the quality of processes and project results while considering BA standards. The main objectives of the project are to give professionals abroad a quick overview of their opportunities for moving to Germany and to enable them to take the necessary steps consistently and with digital support by providing access to services.

• Defining the general guidelines in the QA handbook

• Summarising test results in QA reports for PLA

• Analysing project results for improvement opportunities

• Quality management of requirements analysis (particularly processes, methods, and tools)

• Ensuring compliance with SERA requirements

• Creating a cross-project test concept

• Agreeing on sprint completion reports

• Formal review of work results in accordance with requirements and/or the project plan

• Contact person for internal audit, external audits by auditors, or BRH (Federal Court of Audit)

• Technologies: JIRA, Confluence, MS Office, GitLab, Kubernetes

• Designed a migration strategy for WLS applications to BKA Cloud and Stack IT

• Created a hybrid cloud for internal testing and development with Kubernetes

• Transformed the IT landscape from an outdated monolithic architecture to a cloud-based architecture

• Integrated new CI/CD processes using Azure Pipelines

• Quadrupled the processing throughput for personnel security checks

• Migrated personnel security screening applications to Docker-based applications

• Implemented CI/deployment pipelines using Azure DevOps

• Environment: Java Springboot, Kubernetes, Oracle Weblogic, OpenID, Camunda, JUnit, TOGAF

Methodology: Agile project management

Goal: Digitization and implementation of CCD2 requirements within the Consumer Finance systems.

Analysis, identification, and assessment of business requirements, as well as their transfer into technical implementation requirements. Coordination and status reporting of the various requirements. Documentation and process management using UML and BMPN. Cross-functional stakeholder management, UAT testing, data management, API architecture management.

Tools: Jira, Confluence, Visual Code, Sql Developer, Enterprise Architect, MsOffice, Bruno, ALM, Camunda, Figma

• Support for one of the largest logistics service providers in handling ServiceNow tickets in the areas of SAP MDG, Business Partner (BP), customer and supplier master data
• Technical analysis and resolution of tickets through in-depth review of various database tables
• Creation and maintenance of accounting clerks in the system
• Deactivation of company codes using transports
• Carrying out mass changes with LSMW (Legacy System Migration Workbench)

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

• Fixing issues in the program logic

• Covering the changes with unit tests

• Analyzing and documenting the data structure of the various applications

• Analyzing and documenting the parameters for configuring the applications

• Analyzing and documenting the measures required to ensure the operation of the applications

• Analyzing and designing the separation of the individual database structures

• Analyzing and estimating the effort for planned extensions

• Analyzing, maintaining and documenting a heterogeneous legacy system landscape for a print media service provider

• Technology: C#, VB.NET, C, Python, Microsoft SQL Server, Visual Studio 2010, JetBrains Rider, Visual Studio Code, arc42, Draw.io, Jira, GitLab

• The goal of BIENE is to provide a unified tax collection program for all federal states.

• Tax collection involves collecting the taxes that have been assessed. This includes, for example, taking due dates into account, recording incoming and outgoing payments, and initiating reminders or refunds. Limitation periods and payment reminders are also important. BIENE handles all payment transactions with banks and accounting.

• Set up the architecture and coordinated the provision of development and test environments at the Hannover site

• Installed and configured the environments on Linux servers (Apache Kafka, PostgreSQL)

• Interface coordination: coordinated and aligned the connection of software products from other departments and their test data

• Migrated the application server, JDK, and Maven project structure

• Coordinated environments and managed builds

• Implemented external interfaces

• Delivered business requirements

• Designed and implemented RESTful APIs and OpenAPI specifications

• Designed and implemented a microservice architecture

• Set up and maintained CI/CD pipelines

• Deployed applications on OpenShift

• Created technical documentation and diagrams

• Worked with SQL databases (Oracle and PostgreSQL)

• Set up authentication and authorization for the application and users

• Containerized the application (automated deployment through the CI/CD pipeline)

• Lead programmer, architect and deputy product owner
• Completed transition from zPDV to STEP
• Ensured quality of C++ and Perl sources through automated and manual checks
• Supported resolution of incidents and errors in testing
• Implemented batch for supplementary assignment of payment run numbers
• Implemented batch for distribution of SGB 2 information to the central payment unit
• Supported replacement of Solaris with Linux
• Upgraded gcc from 7.4 to 9.3
• Programmatically generated Makefiles from Borland projects for builds
• Extended funding data with new attribute “Kennzeichen Fahrtkosten Praktikum”
• Programmatically generated XSD and WSDL files from IDL definitions
• Represented the product owner when needed
• Implemented batch for one-time payment processing
• Developed generator for Liquibase files
• Implemented and maintained regular anonymization of production data
• Supported migration from SLES 12 to SLES 15
• Supported introduction of mutual TLS
• Implemented batch for sending deletion impulses to EDA BE
• Organized script directory structure
• Investigated potential introduction of String-Latin and implemented minimal solution
• Remediated security findings identified by CheckMarx
• Supported PAP recalculations and general change notices
• Converted ERP interfaces from SOAP to REST
• Planned technical and business topics such as register modernization, cash register security, training costs, four-eyes principle

• Analysis and audit of the current situation on-site and at customer locations
• Planning of IT infrastructures and advice on new hardware purchases as well as migration planning
• Planning and management of the IT budget
• Configuration and support of IT hardware under Windows 7, 8.x, 10 and Mac OS
• Review and update of documentation with regard to GDPR
• Analysis and expansion of technical and organizational measures in accordance with GDPR and BDSG
• Training of employees
• Training in AI-Assistant Consulting and Cybersecurity with AI
• Recording the current state and planning the target state
• 2nd/3rd level support (C/S/N)
• Technical environment: Exchange Administration, Active Directory, MS Server 2016 R2, MS Server 2022, MS SQL Developer, MS SQL, Visual Studio 2013+, Tivoli Monitoring, Tivoli Remote, TeamViewer, weclapp CRM Solution, RA-Micro, IT Compliance, Citrix, UltraEdit, SCCM, Windows XP–11, Office 2010–M365, VPN Solutions, Lexware Solutions, OKI Management Solutions, LogMyTime, SAGE Systems

PHP and React redesign of a web-based ERP system.

• Development of the header and parts of the navigation
• Development of various modules in React, such as a calendar, chat and various tables

• 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

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