TransUnion
Reston, Virginia
Sr Manager Database
Dec 2021 to Jun 2025
Résumé · scottjohnson.tech · Sterling, Virginia
Sterling, Virginia
Scott Johnson
Retired. More than 30 years in databases and data architecture, and a hands-on builder of software and systems.
From 1991 to 2025, Scott Johnson worked in databases and data architecture. The later roles were database services leadership at Neustar and Sr Manager Database at TransUnion, with data warehouse architecture at Neustar and Nextel before that.
He lives in Sterling, Virginia. Aerial Aspect Media is his business, and he is a Part 107 drone pilot. He still builds full-stack applications, automation, and self-hosted systems, and he prefers concise, documented, performant code.
He is open to focused technical projects: data-heavy applications, self-hosted services, and automation with a defined purpose.
- Education
- Management Science, Virginia Tech
- Certifications
- PostgreSQL 9.3 Associate, ITIL Foundation
- Skills
- Data Warehousing, Business Intelligence, Integration
Experience
Database services, data architecture, and earlier engineering roles, 1991 to 2025.
Neustar, Inc.
Sterling, Virginia · 24 years 3 months
Neustar was acquired by TransUnion in December 2021.
Database Services Manager
Jan 2016 to Jun 2025
He led a team supporting 800+ databases on Oracle, MySQL, Postgres, and SQL Server. High availability, disaster recovery, and backups were implemented and tested to each business line's SLA. The team supported both on-premises and AWS cloud database technology.
Manager, Database Services
Jan 2014 to Jan 2016
Senior Data Architect
Apr 2001 to Jan 2014
Senior Data Warehouse Architect for Neustar.
Nextel
Herndon, Virginia
Data Warehouse Architect
Aug 1997 to Mar 2001
SHL Systemhouse
Reston, Virginia
Senior Systems Engineer
Sep 1994 to Aug 1997
PRC
McLean, Virginia
Developer
Jan 1993 to Sep 1994
System Engineer
SONEX Enterprises, Inc.
Fairfax, Virginia
Programmer
Jun 1991 to Jan 1993
Education
1986 to 1991
Bachelor's degree, Management Science. Pamplin College of Business, Virginia Polytechnic Institute and State University (Virginia Tech).
Certifications
- PostgreSQL 9.3 Associate
- ITIL Foundation
Skills
Data Warehousing, Business Intelligence, and Integration.
Selected work
Four projects that show how he builds: a relational web application, event photo sharing, a personal photo catalog, and a home lab organized so it can be rebuilt.
Wishlist
Python · Flask · PostgreSQL
A gift registry with affiliate monetization, implemented in Flask and PostgreSQL. Lists and claims live in the relational model. The application around them is kept concise, documented, and fast.
PhotoShare.Events
Cloudflare R2 · Stripe
Self-hosted photo sharing for events. Photographs are stored in Cloudflare R2, and Stripe handles payment. A public edge sits in front of storage that stays with the project.
Family photo gallery
Docker · PostgreSQL
A self-hosted way to browse a personal photo library. Hierarchical keyword filters narrow the collection by subject. Place labels open a map. Docker runs the application, and PostgreSQL holds the catalog.
Homelab
Proxmox · Docker · pfSense · Home Assistant
A home lab organized around Proxmox, Docker, and NAS-backed git and backups. pfSense provides the network edge. Home Assistant runs household automation. The aim is a setup that can be recreated and backups that can be restored.
Also built
- Raspberry Pi Halloween projections with networked playback control.
- A private nutrition log for foods and macros, with label-photo OCR and confirmed entries.
Capabilities
Tools he uses, grouped by the kind of work.
Data
Oracle · PostgreSQL
Schema design and SQL, with a preference for keeping correctness in the database. That practice ran through the database services work, and it is still how he builds.
Applications
Python · Flask
Full-stack applications that stay close to their data: request handling, persistence, and clear interfaces. Development and testing sit in the same loop, aimed at code that is concise and documented.
Automation
Docker · git · Ansible · Terraform
Services packaged in Docker, changes kept in git, and environments described with Ansible and Terraform so a machine can be rebuilt from the files that describe it.
Edge and payments
Cloudflare Pages · Workers · R2 · Stripe
Static hosting on Cloudflare Pages, small edge programs on Workers, and object storage on R2. Stripe covers checkout where a project needs it. PhotoShare.Events uses R2 and Stripe together.
Contact
LinkedIn and GitHub are the public profiles. An email address is not published on this site.