Looking for a job

John Penn

@johnpenn

SQL Server developer and performance engineer who cut Kroll’s hourly database sync to 1–2 minutes and tuned InComm Payments queries.

United States

Message

What I'm looking for

I'm seeking contract and full-time database development and performance engineering roles.

At Kroll, I corrected datatype mismatches and revised mis-declared columns to cut hourly database synchronization to 1 to 2 minutes. I also refactored stored procedures, optimized indexes, and redesigned tables to reduce the memory footprint of legacy SQL Server applications.

At Asembia, I resolved a production bottleneck in a 10 TB database caused by PDF document storage. A targeted query redesign shortened weekly backups by more than an hour.

At Amtex Systems Inc., I led query and stored-procedure code reviews across 8 development teams and tuned queries for InComm Payments’ Healthcare and OLS divisions. I also partnered with architects on database designs.

I’ve consulted on database design, performance tuning, and T-SQL query optimization for enterprise clients. Since June 2026, I’ve also designed, built, and released a generative-music relaxation app for iOS and Android.

Experience

Work history, roles, and key accomplishments

Current

Independent Mobile App Developer

Current

Self Employed

Jun 2026 - Present (4 months)

Designed, built, and released a generative-music relaxation app on both iOS and Android.

iOS Android Mobile Application Developer Generative Music

Senior SQL Server Developer

Amtex Systems Inc.

Jun 2025 - Feb 2026 (8 months)

Led query and stored-procedure code reviews across 8 development teams and partnered with architects on new database designs. Tuned queries and stored procedures for client InComm Payments across its Healthcare and OLS divisions to improve throughput.

T SQL SQL Server Query Optimization Stored Procedures Code Review Database Design

SQL Server Consultant

Penn Creative Group LLC

Jun 2006 - Feb 2026 (19 years 8 months)

Independent consulting in database design, performance tuning, and T-SQL query optimization for enterprise clients.

Database Design Performance Optimization T SQL Query Optimization

Software Engineer Manager, SQL Server Development

Kroll, Inc.

Oct 2021 - Dec 2023 (2 years 2 months)

Cut database synchronization to 1 to 2 minutes for hourly jobs and about 2 hours for the full weekly sync by correcting datatype mismatches in join predicates and revising mis-declared columns. Refactored stored procedures, applied index optimizations, and redesigned tables to reduce memory footprint. Designed and implemented a proof-of-concept with row-level security (RLS) for GDPR compliance. Me

T SQL SQL Server Query Optimization Index Tuning Stored Procedures Row level security GDPR Mentorship

SQL Server Developer

Asembia LLC

Apr 2018 - Oct 2021 (3 years 6 months)

Resolved a production bottleneck in a 10 TB database caused by PDF document storage; a targeted query redesign cut weekly backup duration by more than an hour. Rewrote a suboptimal subquery in a legacy stored procedure that was delaying clinician patient processing. Increased throughput of a specialty-pharmacy prescription-tracking application on SQL Server 2012/2016/2017 using RedGate SQL Toolbel

T SQL SQL Server Query Optimization Index Tuning Stored Procedures Redgate SQL Toolbelt SQL Server Data Tools LINQ to SQL

SQL Server Developer

Visual Lease LLC

Jun 2017 - Mar 2018 (9 months)

Optimized queries through execution-plan analysis and deployed indexes, stored procedures, and inline functions. Analyzed production database performance and presented tuning recommendations to the business.

T SQL SQL Server Query Optimization Execution Plan Analysis Index Tuning Stored Procedures

SQL Server Developer

Verizon Wireless

Oct 2015 - May 2017 (1 year 7 months)

Tuned indexes and optimized a SQL Server 2012 database backing a One Identity/Quest Identity Manager instance. Authored deployment scripts for optimizations and partnered with developers on code reviews.

T SQL SQL Server Index Tuning Query Optimization Deployment Scripts Code Review

SQL / Web Developer

Business Edge Services & Technologies

May 2015 - Sep 2015 (4 months)

Developed efficient SQL Server queries to compile drug-program statistics and enhanced ASP.NET WebForms applications supporting daily pharmacy operations.

SQL Server T SQL ASP.NET Web Forms

SQL Server / Application Developer

US Golf Association

Mar 2014 - May 2015 (1 year 2 months)

Optimized dynamic SQL and converted DB2/SQL Server logic into stored procedures for handicapping applications. Built features for ASP.NET tournament and scoring apps (C#, VB.NET, jQuery, Bootstrap, SQL Server 2008).

T SQL SQL Server DB2 Stored Procedures ASP.NET C#VB.NET jQuery Bootstrap

Senior Application Developer

NRT, LLC

Mar 2012 - Mar 2014 (2 years)

Contributed to the design and development of an enterprise real-estate accounting and reporting application; extended a WCF/SOAP service with new data interfaces and persistence methods.

C#WCF SOAP SQL Server Application Development