What I Do

Hi, my name is Colin Douglas. I’m currently a SQL Server Database Administrator (DBA) at Dot Foods, the nation's largest food redistributor with an annual revenue of $7.5 billion. My primary purpose as a DBA is to make our SQL Server systems fast and dependable. My areas of specialty are performance tuning & optimization, troubleshooting, and automating tasks. I’ve contributed to open source projects such as DBATools, a Powershell toolkit for SQL Server Pros, as well as SQLWatch, a free SQL Server performance monitoring tool. When I’m not staring at database servers, I enjoy web, mobile, and game development.

Skills

storage

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.

arrow_forward_ios

Powershell

Automating and scripting SQL Server tasks in Powershell using a .NET-based class called SMO (Server Management Objects). Experience with developing unit tests with Pester. Check out my open source contributions to DBAtools here and here.

web

Web Development

Creating full-stack web applications using .NET Core, Bootstrap, Angular, and MySql. I created this site, www.colin-douglas.com, with HTML, CSS, Javascript, and the Bootstrap framework.

videogame_asset

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!

smartphone

Mobile Development

Developing cross-platform mobile apps using a wide range of web-based technologies, such as PhoneGap, Ionic, and Xamarin.

Portfolio

Card image cap
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
Card image cap
DBATools
Get-DbaRepPublication

Get-DbaRepPublication quickly finds all transactional, merge, and snapshot publications on a server or database.

Powershell SQL Server DBATools Open Source
Card image cap
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
Card image cap
Waters Mortgage
www.WatersMortgage.com

Developed, designed, and manage WatersMortgage.com, an online mortgage website.

Web Development HTML CSS Javascript

More Projects to come!

About Me

Thumbnail Image

Colin Douglas
SQL Server DBA

A SQL Server DBA with 4 years of DBA experience at Dot Foods. I received a BA degree in Computer Science from Monmouth College. I'm passionate about technology and love what I do. My hobby is programming and learning about new technologies.

Contact Me

Please feel free to reach out to me with any questions or opportunities