A car dealer had an ADP DMS access via "Reflections" and remote access only via modem. I was approached by a company with the problem that nightly updates were being done by hand to pull from the ADP system in order to upload them to a web server. This was a complex problem requiring scripts in Windows, ADP “English statement” scripts, Reflections Visual Basic Macros, and finally a bash/PHP script to move the downloaded data into a MySQL database. Met with client and setup a completely automated system.

2001-2006: Lead Application Architect, DBA for system integrating multiple universities' and colleges’ admissions databases into a centralized "Sports Recruiting Management System." Led a team which built the web service used by NCAA schools across the country so that coaches and recruiters could adhere to strict NCAA recruiting and reporting requirements.

Multiple realty agencies using the Paragon MLS system wanted to have their own individual pages each with the houses listed. Individual Reator agencies wanted to pull all data from the MLS system (including images) and display them on web sites. System needed to be able to connect daily to the MLS system, download incremental data and relevant images and listing data and then import into MySQL database for real-time display with search capabilities. MLS system originally used XML data as defined by IDX rules, but later changed.

Often clients with mission-critical applications need to track every update and change to a MySQL database system. This is useful not just for security but to also for replicating user actions when there's a complaint.

Being able to say "User X logged in and did these exact actions" from a DB review is often invaluable both in Q/A and in production and the time to resolve database-related user trouble tickets can be done in minutes when 100% of a user's actions can be replicated.

In 1998 the concept of "middleware" for the web was just getting started.

Created bid, set deliverables and timeline, persuaded a key decision maker about feasibility of the emerging technology of web-based information management despite incredulity from hospital IT staff.

A few interesting MySQL replication scenarios: 

Encrypted WAN Replication:
A company with mission-critical database services wanted real-time WAN backup of MySQL database. I setup remote, ssh-encrypted MySQL replications across WAN for real-time backup of SQL database. System supports “catch-up” replication in case network is slow or down.  Allows client to recover to any moment in time if main server goes down.

Worked with embedded device team to create a vertically integrated system from field devices to server system to end user. Part of the investigation was looking at raw TCP/IP to generate minimal HTTP requests to minimize network traffic from the numerous, mobile-connected devices. 

Investigated technologies and built from scratch web-system used to manage of deployment, monitoring, reporting, TFTP updates, calculations, and real-time display of data from sensors deployed along roads and connected via mobile traffic.

Led team to build demo mobile traffic and travel ap.

Application recorded a users driving via GPS probe points and then used
real-time traffic data to estimate travel time over the routes that were recorded.

System was used as the framework for a system built later for Fortune 5 automotive company.

Demo:

Led team in Sprint that in two weeks had designed system to build fully functional in-car demo for one of the world's largest companies integrating web, voice (VXML), traffic, phone and mobile application.  Assisted with sales for final demo which used real-time, in-car, routing, voice-activated system using potential client's in-car, voice-activated system. Stepped in to program the voice activated system leveraging VXML tools when team ran into difficulty. 

Full system: