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)

Project:

• Migration of existing VB6 applications to C# (Web API, web app)
• Report development and risk management systems (C#, API interfaces, databases)
• Document archive (API interfaces, databases)

Team size: 9 people

• Reports for Risk and Credit Management Development and maintenance of report structures to support risk and credit decisions, including data modeling, validation, and automated delivery for business departments.
• Migration and maintenance of a legacy system to the latest version of .NET for the asset management system Planning and execution of the modernization of an existing asset management system, including code refactoring, performance optimization, test automation, and sustainable maintenance after migration.
• Replacement of the COM-based archive connection with a REST API Redevelopment of the connection of the document archive (HYPARCHIV) to a REST API based on OpenAPI/Swagger, including archiving with index and stamp fields as well as PDF export into the customer portal.
• Redesign of payment receipt processing Replacement of an existing Oracle PL/SQL process with a new implementation in C# based on a business concept, including business alignment, data modeling, and test coverage.
• Design and implementation of tests, creation of deployment pipelines, and documentation
• Further development and implementation of change requests.
• Regular code reviews within the team as well as optimization of application scalability and stability

Technologies: C#, .NET 10, ASP.NET, Unit of Work, IoC, Three-Tier Architecture, Entity Framework Core, DB First, Web API, Swagger, OpenAPI, Python, Oracle, HYPARCHIV, Azure, PowerBI, DevOps, AKS (Azure Kubernetes Service), GIT, xUnit, NSubstitute, TypeScript, Vue.js, Pinia,

Methods: agile development using Scrum

• 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

• Environment: AWS, Ruby on Rails, GraphQL, React Native
• Penetration test for Backend, Android-App and iOS-App

• 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

• Gathering requirements from business departments
• Developing mockups
• Maintaining the backlog and moderating sprint meetings
• Managing developers
• Stakeholder management
• Skills used: Scrum, Requirements Engineering, Requirements Management
• Technologies used: various
• IT environment: Microsoft Dynamics Business Central
• Industry: Real estate
• Role: Project lead, Product Owner

• 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

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