Greg Duffie

Experience

Work History

Four companies over 20+ years. Each one left me with something I still use.

Randstad Digital

Senior SQL Server Database Architect, Administrator, and Lead Developer

Spearheaded all data aspects for a custom-built online scheduling solution managing 2,500+ dialysis clinics nationwide for client Fresenius Healthcare. Primary architect for feature expansion and legacy remediation.

December 2017 – Present

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.

SQL ServertSQLtCI/CD
Read more

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.

SQL ServerT-SQLPerformance Tuning
Read more

Accelerated Enterprise Reporting by 90%

Patient experience and KPI report downloads were taking approximately 10 minutes for 60MB+ datasets, blocking clinical and operations staff from timely access to the data they needed to run clinics.

SQL ServerT-SQLSSMS
Read more

Engineered "ThePurge" — Batch Deletion Framework

Production transaction log growth was becoming unstable.

SQL ServerT-SQLPowerShell
Read more

Modernized Security Infrastructure

Permission management across all environments was handled manually, creating risk of configuration drift, inconsistency, and human error during deployments and environment refreshes.

PowerShellDevOpsSQL Server
Read more

Architected Schema Migration (Multi-Config → Single-Clinic)

The legacy "multi-config" pod/chair schema was creating data duplication and maintenance complexity that slowed development velocity and made the system harder to reason about as the clinic count grew.

SQL ServerArchitectureSchema Design
Read more

FTI Consulting / Ringtail / Nuix

Senior Software Engineer II, SQL Server Developer

FTI Consulting's e-discovery product Ringtail was a Gartner Magic Quadrant leader in legal discovery. Lead SQL developer on a web-based evidence collection and processing platform. The product was later acquired by Nuix.

April 2007 – December 2017

Built a Universal Auditing System Using Dynamic SQL

The platform lacked a consistent way to track changes across client databases.

SQL ServerT-SQLDynamic SQL
Read more

Built SSIS-Equivalent Ingestion Pipelines in Pure T-SQL

Licensing SSIS across hundreds of client servers was cost-prohibitive, but the platform needed robust ingestion pipelines to reliably process evidence data.

SQL ServerT-SQLtSQLt
Read more

Lead SQL Developer on Evidence Collection Platform

The Ringtail e-discovery platform required a dedicated SQL developer to own all database development and coordinate with a cross-functional SCRUM team building a web-based system for legal evidence collection and processing.

SQL ServerT-SQLAgile
Read more

Communifax Direct Marketing

SQL Server Data Analyst, Developer, and DBA

B2B direct marketing firm running high-volume data operations for enterprise clients. Worked across the full data stack — cleansing, warehousing, ETL, reporting, and server administration — on databases up to 200GB for household-name clients. Cranberry Twp, PA.

January 2002 – April 2007

Data Operations for Enterprise Clients at Scale

Delivered data cleansing, warehousing, and reporting for campaigns run on behalf of Verizon, LendingTree, CheckFree, Audible, Bank One/Chase, and Sheetz — handling databases up to 200GB and processing millions of records using custom SQL scripts, SSIS Fuzzy Lookup/Grouping, and third-party matching tools.

SQL ServerT-SQLETL
Read more

Led SQL Server 2000 → 2005 Migration

Converted DTS packages to SSIS during the company's platform migration, while assisting the senior DBA with hardware configuration, capacity planning, and security management across 20+ servers and 50+ workstations.

SQL ServerSSISDTS
Read more

Built and Administered MicroStrategy BI Platform

Administered MicroStrategy installations, maintenance, and upgrades.

MicroStrategyBIReporting
Read more

37SOLUTIONS, LLC

Owner & Principal Engineer

Boutique managed hosting and web services company serving small businesses since 2006. Independent SQL Server consulting, WordPress management, and content operations. Registered trademark since 2016.

January 2002 – Present

20+ Years of Managed Hosting and Web Services

Small business clients needed reliable hosting, migrations, and ongoing web support — services that larger agencies ignored or overcharged for.

WordPressLinuxDNS
Read more

Acquired and Grew a Digital Marketing Agency

Client demand for SEO, paid advertising, and social media services exceeded what 37SOLUTIONS could provide under its existing scope.

SEOPPCDigital Marketing
Read more

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.

SQL ServertSQLtNext.js
Read more

Custom MCP Server for Zendesk Integration

Existing community repos for Zendesk integration with Claude AI were incomplete, leaving gaps in the tools needed for daily support ticket operations at 37SOLUTIONS.

PythonMCPZendesk
Read more