Greg Duffie

Skills

What I Know

No progress bars. No percentages. Either you know something well enough to use it in production or you don't. These are the things I do.

SQL & Data

The core of most of my work. I write queries that perform, design schemas that hold up, and build ETL pipelines that run reliably in production — not just in demos.

SQL Server 7.0–2025T-SQLStored ProceduresQuery OptimizationExecution PlansIndex DesignSchema Design & RefactoringtSQLt Unit TestingETL PipelinesSSISSQL Server AgentDatabase Backup & RecoveryMigration PlanningPerformance Tuningsp_Blitz / FirstResponderKitData WarehousingReporting & AnalyticsDynamic SQLPostgreSQLMySQL/MariaDBRedisMS Access

Hosting & Infrastructure

Linux administration, web server configuration, DNS, email deliverability, and security hardening. I know how the stack actually runs because I have run it — without a DevOps team behind me.

Linux (Ubuntu, Debian, CentOS)Windows ServerNginxApacheDNS ManagementSSL / TLSEmail Deliverability (SPF, DKIM, DMARC)Server HardeningcPanel / WHMBash ScriptingPowerShellSSH Key ManagementCron / SchedulingVercelGit / GitHubJenkins (CI/CD)DockerProxmoxVMwareParallelsVirtualizationFirewall / UFWVLANsLoad BalancersUniFiSonicWallJuniperSyslogCloudflareDigital OceanAzureAWSGCPCloudwaysimapsync

Entrepreneurship & Side Projects

I've built and run real businesses — not side projects that never shipped. 37SOLUTIONS has been in continuous operation since 2002, serving clients ranging from local Pittsburgh shops to national steel building retailers. I understand scope, trade-offs, and what it takes to keep something running without a team.

WordPressJoomlaDrupalSquarespaceShopifyWooCommerceMagentoDiviNext.jsManaged HostingWebsite MigrationsFull-Stack Site BuildsNiche PublishingContent StrategySEOPPC / Paid AdvertisingAffiliate Program IntegrationEmail MarketingPerformance OptimizationCost ManagementSelf-Directed DeliveryP&L OwnershipQuickBooksBookkeeping & AccountingZendeskJiraTrellon8nMatomoGoogle AnalyticsGoogle Search Console

Leadership & Process

I have mentored junior engineers, led cross-functional projects, and delivered under real constraints. I've screened, interviewed, and hired technical candidates. My leadership style is straightforward: be clear about what needs to happen and make sure it does.

Technical MentorshipCode Review / Pull RequestsSQL Standards DocumentationDeveloper OnboardingHiring & InterviewingCross-Functional CommunicationRunbook WritingInternal DocumentationIncident ResponseCI/CD Pipeline OwnershipAgile / ScrumStakeholder CommunicationProject ScopingPost-MortemsOffshore Team Management

Tooling & Workflow

The tools I actually use day-to-day — not a keyword dump. If it's on this list, I've used it in a real project or production environment.

SSMSRed-Gate SQL PromptRed-Gate SQL MonitorBeyondCompareGitKrakenVS CodeLM StudioOllamaPythonFastMCPSnagItConfluenceSlackZoomWebExTeamsmacOSWindowsGrafanaPrometheusLokiProxmox