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 to ~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 to 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