📞 +49 178 9364265
✉️ manuel.hagen@datrexx.de
📍 21614 Buxtehude near Hamburg · Remote & on site (DE / EN)
When grown databases, applications or processes slow down: measure first, then solve with precision.
I combine more than 30 years of hands-on IT, database and software engineering experience with a commercial mindset from budget controlling. Instead of prematurely recommending costly server hardware, SQL Server core licences or multi-year rewrites, I make bottlenecks and historically grown dependencies measurable – and provide executive and IT management with a sound decision template covering cost, risk and rollback.
30+ years
Experience in databases, C#/.NET, DevOps & controlling (Dipl.-Wirt.-Inf. FH)
64 bn rows
VLDB app ownership (4 TB, 1.4 bn rows/month) in 24/7 manufacturing at NXP
7+ yrs SSIS & FDA
SSIS Data Warehouse (Würzburg) & clinical study reporting (Clario / ERT)
19 source types
Deterministic on-site IT landscape analysis with proprietary toolset COMPIDDA
SQL Server Performance & VLDB
When queries, reports or nightly batch runs crawl or locks block production:
- Diagnosis without reading table contents via system views & execution plans.
- Index before code before hardware: avoids five- to six-figure licence/server upgrades.
- Entry point: 2–3 day Performance Check (fixed-scope package) including management decision summary & before/after proof.
Team Coaching, DevOps & .NET
When teams are stuck in firefighting, releases feel risky or legacy apps need replacing:
- Hands-on in the code (“steady rock in rough seas”): no slide-deck consulting, joint implementation.
- Safety nets: Azure DevOps CI/CD, Docker, NUnit & SHA-256 checksum tests before refactoring.
- Modernisation & ETL: Overhauling hundreds of procedures, SSIS / data warehouse pipelines & migrating (Oracle/Desktop → MS SQL & Blazor).
COMPIDDA IT Landscape Assessment
When documentation is missing, key staff are retiring (“island knowledge”) or a rebuild is planned:
- X-ray in 2 days on site: parses up to 19 source types (SQL, Oracle, SSIS, jobs, C#, VB) locally & deterministically without cloud/AI.
- Every dependency with exact source location (Read / Write / Execute down to line number).
- Commercial leverage: replaces an estimated 30 to 40 person-days of manual searching.
Selected Case Studies & Written References
- NXP Semiconductors (24/7 semiconductor manufacturing): Technical app owner of the global QA platform TDLog (64 bn records, 4 TB). Real-time duplicate checks in < 15 ms via Redis queues; zero-downtime batch migration during 24/7 production.
- Stock Spirits (formerly Borco, spirits industry) & Hesse State Police: Guided the IT reorganisation from bureaucratic legacy processes to modern DevOps practices (acting as documentation architect, establishing systematic ticket & problem-ticket support, code reviews and Scrum daily meetings). Disentangled and replaced ~130 grown MSSQL procedures during live operation; operated Always On Availability Groups (AOAG) with alternating node switchover for zero-downtime updates (also at Hesse State Police) and Backup & Recovery for dataset comparisons and regular live-to-QA test system restores.
- Clario (formerly ERT / CareFusion / Viasys, Würzburg & USA): Over 7 years as a freelancer (2007–2014 & re-engaged 2021–2022 for the Würzburg site): building an intermediate data warehouse layer with SSIS and C# (.NET) to resolve heavy normalisation (key-value) plus FDA-regulated clinical study reporting (MS SQL / Oracle).
- Import wholesaler & PHOENIX-AG: Modernisation of a 20+ year Oracle/desktop application to C#/Blazor & MS SQL; career roots in budget controlling & IT at PHOENIX-AG.
“Mr Hagen has exceptionally profound technical expertise in the areas of databases, application architecture and performance optimisation. […] His work significantly improved the transparency, maintainability, stability and performance of the IT systems in use.” — Excerpt from the written reference · Stock Spirits (formerly Borco)
For Executives, Procurement & HR
- 100% vendor-independent: No resale of hardware, cloud capacity or third-party licences – objective advice strictly in the client’s interest.
- Privacy & confidentiality: Diagnosis without reading table contents; mutual non-disclosure agreement (NDA) before the first look at the system.
- Contract models (Procurement): Direct contract (fixed-price package for check/assessment or time & material) or smoothly via your existing preferred supplier / MSP.
- Core stack: MS SQL Server 2019–2025 (T-SQL, Always On / AOAG, Backup & Recovery / QA Restores, SSIS, SSRS), Oracle PL/SQL, PostgreSQL, Redis, COMPIDDA, C#/.NET, Blazor, EF Core, PowerShell, NUnit, Selenium, Docker, Azure DevOps, Scrum, PRTG, ITIL-aligned processes.
- Detailed specialist profiles (PDF & Word): Complete Master CV (PDF) · (.docx) · SQL & DB Architect Profile · .NET & DevOps Architect Profile