Greg Duffie

Available for senior technical & leadership roles

Greg Duffie

Senior SQL & Infrastructure Engineer. I fix things, build things, and ship things.

“Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.

Code for readability.”

John F. Woods
September 1991, comp.lang.c++ newsgroup

Randstad Digital

Accelerated Release Velocity with Mandatory Unit Testing

Release cycles were running every two months and regression issues were frequent, leaving the client without confidence in the system's stability. Every release was a risk event rather than a routine delivery.

Result

Cut release cycles from every two months to every two-week sprint.

Read more

Randstad Digital

Optimized Core Shift Retrieval Engines

Core staff scheduling stored procedures were running at 1,500ms+ per call, impacting the responsiveness of the scheduling solution used across 2,500+ clinics. Under peak load the latency compounded across concurrent sessions.

Result

Improved performance of core staff scheduling stored procedures from 1,500ms+ per call to under 200ms — better than a 7x improvement in response time.

Read more

37SOLUTIONS, LLC

Built and Launched sqltesting.com

SQL developers had plenty of reference sites but almost nothing purpose-built for tSQLt unit testing and CI/CD pipeline integration. The information existed but was scattered and lacked practical, opinionated guidance.

Result

Established sqltesting.

Read more

Side Projects

Looking for a senior database or infrastructure engineer?

I'm available for full-time W2 roles. Prefer working on real problems with teams that ship.

Download CV