SQL Server, Data Warehouse, BI and Azure Data Platform

Development, administration, performance tuning, DevOps and operations for business-critical SQL Server platforms.

Data Vault, Kimball, ETL, data quality, BI delivery, Azure Data Platform and technical documentation.

Power BI data models, DAX measures, dashboards, Row-Level Security, governance and reporting built on clean data platforms.

Azure Data Factory, Synapse, Databricks, Microsoft Fabric, Data Lakes, DevOps, CI/CD and modern cloud data platforms.

Analysis and optimization of slow SQL Server queries, indexes, execution plans, Query Store, Wait Statistics, ETL and reporting workloads.

Robust ETL and ELT pipelines with SSIS, T-SQL and Azure Data Factory: incremental loading, error handling, idempotency, testing and orchestration.

Data Vault 2.0 with hubs, links and satellites, hash keys, Raw and Business Vault, plus query-ready Kimball structures and automated loading.

End-to-end BI architecture from the star schema through the semantic layer in Power BI and SSAS Tabular to DAX, Row-Level-Security and governance.

Oracle 8i to 19c, PL/SQL packages and procedures, performance with explain plan and hints, plus migration to SQL Server.

Data wrangling with pandas, exploratory analysis in Jupyter, PySpark/Databricks, Parquet and Delta Lake, and integration with Azure.

Automating SQL Server and Azure with dbatools, CI/CD and deployment pipelines, inventory, and repeatable operational processes.

Replacing Informatica PowerCenter, Oracle Data Integrator, and Teradata BTEQ with SSIS and Azure Data Factory.

Shell and Python automation, systemd and cron, Proxmox, Docker, NGINX, WireGuard, and backup pipelines for reliable operations.

Operations and architecture documentation, runbooks, Confluence, data dictionaries, docs-as-code, and automated docs from metadata.

A well-planned branching workflow with dev, test, and main, feature, bugfix, hotfix, and release branches, selective releases, Bitbucket standards, and CI/CD for SSDT, SSIS, and SSRS.