What I Do
Hi, my name is Colin Douglas. I’m currently a Software Engineer at Dot Foods, the nation's largest food redistributor with an annual revenue of $10+ billion. I focus on building and optimizing solutions on the Optimizely (Episerver) ecommerce platform, using technologies like .NET, Vue.js, and Azure. My strengths include full-stack development, performance tuning, and solving complex integration problems. Before moving into software engineering, I was a SQL Server DBA, where I specialized in performance optimization, automation, and high availability. During that time, I also contributed to open-source projects such as DBATools, a PowerShell toolkit for SQL Server professionals, and SQLWatch, a free SQL Server performance monitoring tool. When I’m not building software, I enjoy web, mobile, and game development.
Skills
Software Engineering
Building scalable, maintainable systems using technologies like .NET Core, Vue.js, Azure Functions, and REST APIs. Recent work includes ecommerce platform improvements, system integration, and performance-focused backend development.
SQL Server DBA
Handling all administrative tasks such as backup & recovery, high availability & disaster recovery, monitoring, performance tuning & troubleshooting, patching, licensing, and more. Check out my open-source SQLWatch contribution here.
Web Development
Creating full-stack web applications using .NET Core, Bootstrap, Angular, and MySql. I designed, developed, and mangage www.WatersMortgage.com and www.ColinDouglas.com
Game Development
Creating cross-platform games in Unity using best practices and development patterns. I currently have a mobile-based game in development; stay tuned!
Mobile Development
Developing cross-platform mobile apps using a wide range of web-based technologies, such as Apache Cordova, Ionic, and Xamarin.
Portfolio
SQLWatch
Index Advisor
Created the underlying process for the Index Advisor dashboard in SQLWatch. This process periodically collects missing index information over time and provides the impact, new index definition, and much more.
T-SQL SQL Server SQLWatch Open-Source
DBATools
Get-DbaRepPublication
Get-DbaRepPublication quickly finds all transactional, merge, and snapshot publications on a server or database.
Powershell SQL Server DBATools Open-Source
DBATools
Test-DbaRepLatency
Test-DbaRepLatency creates tracer tokens to determine the latency between all parts of the transactional replication topology for a server, database, or publication.
Powershell SQL Server DBATools Open-Source
Waters Mortgage
www.WatersMortgage.com
Developed, designed, and manage WatersMortgage.com, an online mortgage provider.
Web Development HTML CSS JavascriptMore Projects to come!
About Me
Colin Douglas
Software Engineer
I'm a Software Engineer at Dot Foods, the nation's largest foodservice redistributor. I started my career as a SQL Server DBA, where I focused on performance tuning, automation, and high availability. Now, I build and optimize ecommerce solutions using technologies like .NET, Vue.js, and Azure. I have a BA in Computer Science from Monmouth College and earned my MBA in IT Management at Western Governors University. I'm passionate about problem-solving and always exploring new technologies.