Microsoft SQL Server Experts in Hamburg

• Administration and further development of the M365 environment including Teams, Exchange Online, Intune and SharePoint Online
• Development of dashboards for performance monitoring using Microsoft Power BI
• Implementation of user requirements and processes with low-code/no-code technologies (Power Apps, Power Automate)
• Use of Jira and Azure DevOps to plan and implement user stories in an agile project context
• Participation in daily stand-ups, sprint planning, sprint reviews and retrospectives as technical point of contact
• Planning and implementation of security policies using Azure Conditional Access and multi-factor authentication
• Configuration and deployment of clients and applications via MECM (SCCM) and Baramundi

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

Migration from Exchange 2016 to Exchange 2019 and Exchange Online, as well as the introduction of a backup solution and an archiving solution. The goal was a secure, compliant, and high-performance modernization of the email and archiving infrastructure.

Responsibilities as IT PROJECT MANAGER: Overall project management and operational control / Ensuring adherence to costs and resources / Ensuring achievement of project objectives / Ensuring compliance with regulatory requirements and compliance guidelines, including ISMS, ITIL, and data protection regulations / Preparing and delivering management reports for the project sponsors and project committee / Coordinating interdisciplinary teams from Exchange, network, data protection, and IT security / Planning and executing the system migration from Exchange 2016 to Exchange 2019 / Planning and executing the system migration from Exchange 2019 to Exchange Online / Planning and implementing a backup solution for Exchange Online / Coordinating an EU-wide tender for an archiving solution including market analysis with potential vendors / Planning and implementing an archiving solution for Exchange Online / Coordinating and preparing the necessary BAS notifications in the project context / Coordinating and aligning with stakeholders (e.g. business units, external service providers, and suppliers) for requirements definition and implementation

Technical environment: MS Exchange 2016, MS Exchange 2019, MS Exchange Online, MS Office, MS Planner, MS PowerPoint, MS Project, MS Teams

• Development of ETL pipelines with Talend (7/ Enterprise)
• Development/adaptation of database schema/database functions (PostgreSQL)
• Development of GIT CI pipelines

Technologies: Talend Enterprise, Git, PostgreSQL, Dbeaver, SQL, PL-SQL, Liquibase

• Migration of customer data from a private cloud to AWS
• Optimizing data transformation jobs and migration from Talend to AWS Glue
• Automation of all migration steps
• Used technologies: AWS, Python, Lambda, CloudFormation, SQLServer, AWS Stepfunctions, Glue, PySpark

• Disciplinary and professional leadership of the IT and service team
• Definition and documentation of the Current Mode of Operation (CMO) in Confluence: application landscape, infrastructure, networks, backup & storage
• Development of the Future Mode of Operation (FMO) including process analysis & stakeholder interviews with all departments using BPMN and flowcharts
• Optimization of license management: reduction of ongoing software costs by approx. 17% p.a.
• Introduction and establishment of Jira as the central tool for project and service management
• Introduction and rollout of the HR software MindKey to digitize HR processes
• Introduction of a VoIP solution with Microsoft Teams incl. PSTN connection to replace classic telephony
• Introduction of the production and planning software OptiControl to digitize operational processes
• Rollout of Intune as a Mobile Device Management solution for Windows, iOS and Android
• Build-up of Power BI dashboards for machine park monitoring and financial reporting
• Planning and execution of the IT consolidation of two locations for 170 users
• Introduction of automated penetration testing with Pentera
• Coaching and mentoring the team in agile methods & project management
• Operational support in day-to-day business: administration, incident & change management
• Management of external service providers and assurance of the quality of outsourced IT services
• Responsibility for the IT budget incl. planning and controlling
• Direct reporting line to management with regular management reports on IT KPIs, budget and project status

• Migration and maintenance of a legacy system to the latest version of .NET for the asset management system
• Design and implementation of tests
• Creation of deployment pipelines and documentation
• Further development and implementation of change requests
• Technologies: C#, ASP.NET, Unit of Work, IOC, Three tier architecture, Entity Framework Core, DB First, Web API, Swagger, Open API, Monolith, Python, Oracle, Azure DevOps, GIT, xUnit, NSubstitute
• Methods: Agile development using Scrum

• Several projects in a police context
• Model and document police procedures/projects with Archimate (as-is/to-be) in the context of P20 (BKA)
• Create software architectures with microservices
• POC development with Springboot/Docker/Kubernetes
• Project size: 10 people
• Enterprise architecture management with Togaf and Archimate
• Backend software development Springboot
• DevOps with Kubernetes
• Implemented using: Java 17/21, Springboot 3, P20 architecture, Togaf, Archimate

• Data-analysis, Preparation, gathering and coordination of business requirements for retrieval of monthly- and long term (CLV – relevant) cost- and revenue-components per contract for a customer–base–grouping project (HUB–Project) for B2C-Postpaid-Controlling
• Concept and Implementation of cost- and revenue-KPIs calculation and corresponding CLV–reports (Oracle, Perl, SVN, MS SQL Server, MS Power BI, Serviceware Performance Analytics)
• Operational support of the HUB-Project – various ad-hoc reports, deployments, job-scheduling etc. (Oracle, SVN, BICSuite–Scheduler, DWSODA etc.)
• Analysis, implementation, retrieval and reporting of various physical and financial KPIs for B2P-Prepaid Business on an existing data-mart (Oracle, Perl)

• Project leadership and management
• Implementing reporting solutions in banks
• Enhancing and optimizing reporting processes in bank finance and risk departments
• Consulting through all phases of regulatory requirement implementation, including requirements analysis, defining business requirements, testing, tool development, and audit-compliant documentation
• Supporting regulatory implementation projects
• Analyzing business requirements and implementing reports
• Acting as a liaison between business and IT
• Publishing on regulatory changes
• Training internal colleagues on regulatory topics

• Creation of a platform where schools can run competitions to collect e-waste or old textiles
• Development of a shared PHP backend for administration by the client
• Connection of two separate WordPress sites via REST API
• Development of a custom WordPress theme with an extensive login area for students
• Setup of normally editable content pages using Elementor

• Development of modern web applications focusing on React and Next.js

• Implementation of e-commerce and business platforms for SMEs

• Analysis and optimization of software and data structures

• Design and development of custom IT solutions

• Structuring of data flows and system architectures

• Ongoing project work in web development and platform solutions

• Tax Advisor Platform with Client Portal and Admin System:

• Development of a web-based platform with an integrated client portal

• Implementation of a system solution including a website, admin panel, and client application

• Development of a role-based access system (admin / client)

• Implementation of document and invoice management

• Digitization of business processes

• Building high-performance frontend structures

• Integration of APIs and backend logic

• Coffee Business Platform with Admin System:

• Development of a web application for a café with administrative functions

• Implementation of internal workflows and user management

• Structuring of digital business processes

• Development of modern UI components with a focus on performance

• Shared Account Platform (Admin & Client Applications):

• Development of a scalable platform with separate applications for admins and users

• Implementation of a role-based access system

• Development of a modular frontend architecture with React and TypeScript

• Integration of API structures and data management

• Developed a web application for horse betting
• Converted components to script syntax

• Designed, implemented, and deployed two new microservice components, enabling new business functionalities and supporting regulatory compliance for enterprise clients.
• Ensured business continuity and system reliability within a high-transaction, microservice-based environment, taking ownership of backend systems under dynamic business conditions.
• Identified and refactored inefficient implementations, applying cost-benefit analysis to optimize performance, maintainability, and code quality.