Hi, I'm Dmitrij — a Microsoft SQL Server Engineer.

I've been a professional database expert since 2008 — tuning queries that wouldn't finish, building CI/CD pipelines for database deployments, and helping teams ship schema changes the way they ship application code. I love to automate everything I can see or touch.

Based in Lithuania, I've worked across diverse industries — banking, leasing, fintech, and delivery — accumulating deep hands-on experience with SQL Server in production environments. I'm an easy collaborator and enjoy explaining complex concepts clearly.

On the open-source side, I'm a contributor to the tSQLt SQL Server unit testing framework and author of a Visual Studio Code extension with 32k+ downloads.

What I'm best at

• Performance tuning. Query plans, indexes, wait stats, in-memory tables, stored procedure rewrites — diagnosed and fixed with measurable before/after numbers.
• Database development & CI/CD. SSDT projects in source control, tSQLt unit tests, automated deploy pipelines with GitHub Actions, Bamboo, or Bitbucket.
• Version upgrades & migrations. Moving between SQL Server versions, server consolidations, and schema re-organisations — with rehearsed rollback plans.
• ETL & reporting. SSIS packages, DataVault data warehouse patterns, and SSRS reports wired into automated pipelines.
• Automation & scripting. PowerShell, T-SQL, and TypeScript automations that eliminate repetitive manual work.

What I won't pretend to do

• Front-end or application-tier work outside the database.
• Open-ended “data strategy” engagements with no measurable outcome.
• Ten things at once. I'd rather do one thing well than be on five projects half-time.

Stack & tools

Core: SQL Server 2012 through 2022 (on-premises), T-SQL, SSDT, SSIS, SSRS.

Testing & quality: tSQLt unit testing framework (contributor), code review via pull requests, branching with git flow.

CI/CD & source control: GitHub Actions, Atlassian Bamboo, Bitbucket, Jira, DACPAC / SQL Package, PowerShell deployment scripts.

Diagnostics: Query Store, Extended Events, sp_WhoIsActive, sp_BlitzFirst, Brent Ozar's First Responder Kit, dbatools.

Other: PowerShell, TypeScript, Bash scripting; Salesforce / Dynamics CRM integrations; DataVault data warehouse design; VisualCron, REST APIs.

How engagements usually go

1. Free 30-min consult. You describe the symptoms. I tell you whether I can help and roughly what it would take.
2. Scoped phase. A small, time-boxed first phase with a clear deliverable, so you can judge fit before committing further.
3. Ongoing if useful. Many clients then keep me engaged on a regular basis. Some don't need me again, and that's a good outcome too.