A few examples of the hands-on work I've done.
A national laptop repair depot handled more than 4,000 repairs and shipped more than 12,000 parts a day. I wrote and scheduled SSRS reports, built SQL Agent jobs that extracted data and emailed the results, and made a real-time Power BI dashboard of shop floor metrics.
I led a small team through 46 application queries. We identified the ones with the highest impact, rewrote them, and proposed index changes, tracking run time and reads for each one. On a later contract, I led a review of another application's database, normalized its core data areas, and handed off documentation the client's team could use without us.
I set up linked servers so SQL Server could query ODBC data sources, Claris FileMaker, and spreadsheets, and used OPENQUERY to read Active Directory.
I planned an on-premises to Azure migration and started carrying it out. I created and sized SQL instances, supported Microsoft Dynamics GP, and set up an on-premises data gateway that fed two customer-facing Power Apps.