# Greg Duffie

gregduffie.vercel.app · Remote

---

## Summary

Senior SQL Server Architect, Administrator, and Developer with 20+ years of experience in healthcare, legal (e-discovery), direct marketing, and managed web services. Proven track record of improving system stability, performance, and release quality through disciplined architecture, mandatory unit testing, and automated CI/CD pipelines. Individual contributor by preference — the person who solves hard technical problems, not the one who runs meetings about them.

---

## Experience

### Randstad Digital (Client: Fresenius Healthcare) — Pennsylvania
**Senior SQL Server Database Architect, Administrator, and Lead Developer**
December 2017 – Present

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

- Accelerated release cycles from bi-monthly to every two-week sprint by implementing mandatory tSQLt unit testing for all stored procedures
- Improved core staff shift retrieval performance from 1,500ms+ to under 200ms via targeted nonclustered indexes on high-churn temporary tables
- Reduced enterprise report download times by 90% (10 min → ~1 min) on 60MB+ datasets by refactoring view systems and eliminating iterative lookup joins
- Built "ThePurge" — a parameterized batch deletion framework for 60M+ row tables — to stabilize production transaction log growth and ensure nightly sync compliance
- Automated global server permission management using PowerShell scripts and JSON-based configuration files, replacing a fully manual process
- Designed and executed migration from legacy "multi-config" pod/chair schema to a streamlined clinic-centric architecture
- Administered GitHub database repository; conducted code reviews and enforced SQL standards across a global developer team
- Authored SQL standards documentation and developer onboarding materials

---

### FTI Consulting / Ringtail / Nuix — Green Tree, PA
**Senior Software Engineer II, SQL Server Developer**
April 2007 – December 2017

Lead SQL developer on a web-based evidence collection and processing platform. Ringtail was a Gartner Magic Quadrant leader in legal e-discovery before being acquired by Nuix.

- Built a universal auditing system using triggers and dynamic SQL to track changes across any SQL Server 2000/2005 database without schema-specific customization
- Engineered T-SQL-based ingestion pipelines as a full SSIS replacement, eliminating SSIS licensing costs across hundreds of client servers
- Lead SQL developer on evidence collection application used to track and process hard drive data for legal discovery
- Delivered features using SCRUM/Agile methodology in two-week sprint cycles

---

### 37SOLUTIONS, LLC — Remote
**Owner & Principal Engineer**
January 2002 – Present

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

- Managed hosted WordPress environments, migrations, DNS, SSL, and email deliverability (SPF/DKIM/DMARC) for a roster of small business clients since 2002
- Acquired Think BIG Engine (2016), a digital marketing agency offering SEO, PPC, and social media management
- Built and launched sqltesting.com, a consulting and content site targeting SQL developers working with tSQLt and CI/CD pipelines
- Built a custom Python/FastMCP server integrating Claude AI with the Zendesk API for ticket management

---

### Communifax Direct Marketing — Cranberry Twp, PA
**SQL Server Data Analyst, Developer, DBA**
January 2002 – April 2007

- Data cleansing, warehousing, and reporting on databases up to 200GB for enterprise clients including Verizon, LendingTree, CheckFree, Audible, Bank One/Chase, and Sheetz
- Migrated DTS packages to SSIS during SQL Server 2000 → 2005 transition
- Administered MicroStrategy BI installations; developed reports analyzing direct mail, email, and web metrics
- Assisted senior DBA with hardware configuration, capacity planning, and security across 20+ servers

---

### SCB Computer Technology (Indiana State Department of Health) — Indianapolis, IN
**Programmer, Application Support**
May 2000 – November 2001

- 1st–3rd tier support across HIV/STD programs, Time & Activity systems, and Inventory applications
- Built a VB 5.0 utility to update Access databases via email, eliminating up to 3-hour download waits for 200+ remote dial-up users
- Developed ColdFusion 4.5 intranet app to track inventory and surplus items; converted FoxPro database to Oracle 8i

---

## Skills

SQL Server 7.0–2022, T-SQL, tSQLt, Query Optimization, Index Design, Schema Design, ETL/SSIS, Data Warehousing, PostgreSQL, MySQL/MariaDB, PowerShell, Bash, Python, Jenkins, Git/GitHub, Docker, Proxmox, Linux, Windows Server, Nginx, Apache, DNS, SSL/TLS, Email Deliverability, cPanel/WHM, Cloudflare, WordPress, Next.js, Vercel, Jira, Zendesk, Agile/Scrum

---

## Education

**California University of Pennsylvania** — California, PA
Accounting, 89 credits completed — December 1995