Organization using Peoplesoft on Oracle wanted to have an online application which tracked employee assets in a complex way that Peoplesoft did not offer. Existing corporate web server did not offer native OCI calls, just slower generic ODBC modules.

A local real estate agency purchased a Perl-based commercial real-estate listing management package and purchased a commercial realty office management software that used Microsoft Access with a Visual Basic back end. Agency wanted to integrate those two products and expand on functionality of online version. Met with principles of agency, and setup deliverables, timeline and budget. Lead DBA and programmer for project able to exceed client expectations and setup a new data-driven website that agency claimed was responsible for becoming the dominant agency in the region.

Client had 7 offices each connected via a T1. Each office had a Windows 2003 server with nightly backups via tape. Each system had roughly 100 Gigabyes of data to backup. Existing issues were that complete automation was impossible because individual office managers had to replace tapes, recovery was slow and required searching individual  tapes for the correct data, and the high cost of gigabyte tapes.

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.

Client had legacy Windows NT application (not connected to Internet, but running legacy system) that was running on VMWARE ESXi.

Client wanted to migrate to KVM/qemu however the old physical system had IDE emulation via Adaptec SCSI->IDE. And client had created the VMWARE emulation the same way. Thus when the VM was converted from VMWARE to KVM/qemu the system would not eboot. Got the infamous BSOD with "INACCESSIBLE BOOT DEVICE" error as it was looking for a SCSI drive controlled as IDE by an adaptec driver that didn't exist anymore.

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: