Phaiston IT Consulting GmbH

... at a glance

20+ years of experience in database design and administration

20+ years of software development experience

Microsoft® certified since 2005

SAFe® certified since 2022

Fluency in English and German

SQL / T-SQL .NET C# Blazor UI Docker Python REST Kafka EDA Micro Services Linux PowerShell Jira / Confluence TeamCity DevOps

... about me

Born and grown up in Saxony, former GDR

Started with software development and databases around 1997

Always hungry for knowledge, forever-student, pragmatic thinker

Hobbies: Golf, Scuba, Exercising

... about Software Development

T-shaped know-how in various programming platforms and architectures

Technologically focused on the Microsoft .NET stack and Python

DevOps and DataOps thought leader and passionate implementer of practices

Accompanying software projects through their whole lifecycle

... about Data Work

Intensive understanding and practical use of various data technologies

Built and contributed to many data integration systems

Reliably operated data estates with > 150TB volume for years

Proven skills in performance tuning (execution plan analysis and indexing)

Bridging the gap between SW Devs and DBAs with hands-on support

Deep experience in exploring and understanding customer data models

... about Team Work

Many years of team work experience both as member and leader

Ability to fill many of the 9 Belbin® Team Roles

Certified SAFe® Scrum Master/Team Coach, Agile Practitioner, Lean Portfolio Management, and DevOps

cert_mark_SA cert_mark_SDP cert_mark_SSM cert_mark_LPM

Project Briefs

Migration from MongoDb to SQL Server

exploration of existing document model
prototyping new relational model
support for referential integrity and translations
writing 2-step ETL process from MongoDB to SQL
CI/CD pipeline for full and iterative migration

MS SQL Server .NET / C# MongoDB JSON Docker TeamCity

Price Data Revision Tracking

developed event-sourcing concept with CQRS
building event aggregators through Actor concept
verified business logic through unit testing
implemented routing for different revision aspects
persistence in SQL Server relational databases
setup of multi-node Kafka cluster
deployed as mesh of docker containers

Akka.NET .NET / C# Kafka Protobuf Docker MS SQL Server

Continuous SQL Database Backup Service

automation for SQL database backups and restores
relying on native backup features of MS SQL Server
support for full, differential, and log backups
continuously checking RPO and triggering of backups
propagation of backup events to automated restore
Swagger/OpenAPI-enabled REST Service for reporting

MS SQL Server .NET / C# Akka.NET REST

DevOps Environment Virtualization

Hyper-V based virtualization of production-like environments for development and testing
Allowed running parallel development streams
Avoidance of data and scope conflicts
Reduction of manual labour by 80%
PowerShell scripting to automate Hyper-V provisioning
Integration with continuous backup service

MS SQL Server PowerShell Hyper-V

Refactoring of black-box REST API

Analysis and reproduction of existing endpoints
Development of .Net 7 Minimal API based set of data endpoints
Testing equality of responses against old REST API
Performance optimization through preemptive caching of hot request patterns
Automated CI/CD and deployment as docker containers

.NET / C# Docker

Bi-Temporal Data Model for Trading Data

Conceptual design of a bi-temporal data model
Support for time-travelling views on all entities/attributes
Allowed different perspectives and levels of certainty
Optimization by capturing changes at write-time
Caching hot time perspectives through materialized views
Forward/Backward compatible generation of SQL code
Generation engine driven by .NET/Razor, later Python/Jinja

MS SQL Server .NET / C# Python

CONTACT

Phaiston IT Consulting GmbH

Gotthardstrasse 41

CH 6410 Goldau

Tel.: +41 78 6961210

contact@phaiston.biz

Handelsregister: CHE-345.616.512