SELECT role FROM people
WHERE name = 'Shockley';

Joshua
Shockley

Project Manager & Database Administrator

Advanced Database Solutions · Nixa, MO

WEBjoshua-wd-shockley.com
@joshua.wd.shockley@gmail.com
INlinkedin.com/in/joshuawdshockley
GHgithub.com/joshua-shockley

Data & Ops

SQL ServerSSMSSQLMS AccessVBAVB .NETPowerShellIISVirtualizationProcess Automation

Web

JavaScriptReactNode.jsPythonASP.NETGraphQLReduxSassGit

Path

  • 2023–nowPM & Database Admin
    Advanced Database Solutions
  • 2021–2023Sales Coordinator
    Advanced Database Solutions
  • 2020–2021Programmer
    Advanced Database Solutions
  • 2014–2019Premise Technician
    AT&T, Springfield
5 live sites built & hosted on Cloudflare, listed below
Google IT Support & Business Intelligence certificates
Lambda School Full Stack Web & CS
or press F Contact me ↓

The longer version

I keep SQL Server databases backed up, secured and running, host our company sites, and turn manual business processes into automated ones. Before that I wrote Access VBA systems for clients, and before that I spent five years in the field for AT&T fiber.

Jan 2023 – Present

Project Manager & Database Administrator

Advanced Database Solutions

  • Maintain SQL Server backup automation with PowerShell and Task Scheduler
  • Run databases, security roles and logins on the company VPS
  • Host the company's marketing websites and manage their SSL certificates
  • Built and run the internal email marketing software and email warmers
  • Manage the LAN that connects internal applications and databases
  • Lead troubleshooting and planning with clients, including live screen-share support
May 2021 – Jan 2023

Sales Coordinator

Advanced Database Solutions

  • Wrote SQL tables, views, stored procedures and functions for client and internal projects
  • Led prospect meetings and built estimates from each client's processes
  • Produced database planning and client system documentation
  • Taught new hires databasing and Access VBA in a classroom setting
Aug 2020 – May 2021

Programmer

Advanced Database Solutions

  • Programmed VBA for Microsoft Access client databases
  • Ran QA and testing on client system updates and helped install them
Nov 2014 – Apr 2019

Premise Technician

AT&T · Springfield, MO

  • Installed and serviced in-home fiber connected from outside network lines
  • Recognized in 2016 for customer service in difficult situations
Education

Certificates & schooling

  • Google IT Support and Google Business Intelligence certificates (2025 – present)
  • Lambda School, Full Stack Web Development & Computer Science (2019 – 2020), with 4 team builds
  • Ozark Technical Community College, Associate of Arts (2008)

Sites I've built

Live web apps I designed, built and host myself on Cloudflare, outside my day job.

app.homegroupapp.comHomeBaseTasks, projects & calendar for the houseMow the yard · 5pmGroceries listFix porch rail ✓

HomeBase app.homegroupapp.com

A shared household app for tasks, projects, a calendar and dated shopping lists. Household admins assign work to members, and everyone gets push notifications when something is due. It also has a message board for the house. It runs as a home-screen app on iPhone, and several households use it today.

Cloudflare WorkersPush notificationsMulti-household
Visit HomeBase ↗
spouselingo · coming soonSpouseLingoWhat she said, what she meant"I'm fine."Translation: check in, ask whathappened today, and listen.spice ▮▮▮▯▯

SpouseLingo in development

A playful "spouse translator" that turns everyday comments into what the other partner will better understand, with a reverse mode, voice input, a tone slider from mild to spicy, and a shareable phrasebook. It reuses the account and admin system from Tunester and runs on the Claude API.

Claude APIVoice inputShared accounts

Contact me

Have a database, automation or web project in mind, or a role I'd fit? Send me a note and I'll get back to you.

This opens your email app with the message ready to send to joshua.wd.shockley@gmail.com. If nothing opens, copy the message and send it to that address.