SQL Server Performance & Data Engineering
Query and ETL tuning, large migrations, high availability.
When SQL Server is the bottleneck, I look at execution plans, wait stats, and contention, then fix the cause: indexing, query and stored-procedure rewrites, set-based batching with table-valued parameters, and concurrency that accounts for the isolation level.
I also handle large data migrations - moving millions of rows with validation and reconciliation - and set up high availability where uptime matters. T-SQL and EF Core, plus Oracle / PL-SQL and MySQL in mixed environments.
More work
Fee-calculation performance on a high-volume public-sector platform
Fee calculation ran for tens of seconds on the heaviest records and blocked the UI. Measured 3.4x to 15.4x faster.
Migrating legacy systems into a platform that models the work differently
Close to two million records moved out of ten separate legacy systems, each from a different vendor with its own idea of what the data means. Getting the rows across is the easy part.
Business-intelligence dashboard for mid-market operations
A management dashboard that turns years of operational data into real-time financial-health, profitability and collections insight.
IUCN Red List - species-assessment data-entry system (SIS DEM)
Built and enhanced the data-entry module behind the IUCN Red List of Threatened Species.