Database Developer and Data Cloud Engineer

2/2023 – 11/2023

Creating a strategy for reading parquet files from a data lake to a Synapse Dedicated SQL pool by metadata driven integration pipelines. Implementing the strategy as a POC and training junior developers for completing the entire task with more than 100 database tables.

Azure Synapse Analytics, Datawarehouse / DWH, Datenbankentwicklung, Microsoft Power BI

7/2018 – offen

Data Integration by using Azure Data Factory, Databricks, SSIS, Azure Functions, SQL Stored Procedures. Python, Skala, C# programming.

Azure Databricks, Azure Synapse Analytics, C#, Microsoft Power BI, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Analysis Services (SSAS), PostgreSQL, Python, Scala, Transact-SQL (T-SQL)

7/2018 – offen

MS SQL Servers 2017 administration, Windows Server Failover Cluster with SQL Server administration and upgrades on Azure Windows VMs. MS SQL Databases design and development, optimization and maintenance. Stored procedures and jobs development. Servers performance monitoring by Azure Monitoring Service.
Creating Synapse SQL serverless and dedicated SQL pools and Spark pools, including integration services and Power BI reports to reporting operational data.

Azure Databricks, Azure Synapse Analytics, C#, Microsoft Power BI, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), PostgreSQL, Python, Scala, Transact-SQL (T-SQL)