A Global-scale, financial-services company adopted MySQL for their internal user application DB and needed real-time replication setup across 5+ systems. Pulled in as a 3rd party integrator to setup and load test.

2016: Infrastructure as a Service (IAAS) and Application Architecture:

Client requested upgrade of a legacy system for an organization that engages potential voters in U.S. elections across dozens of campaigns. Migrated to a full virtualized IAAS microservices architecture with virtual firewalls, virtual LANs, and virtual DEV/TEST/PROD servers. Negotiated contract for service, did load testing to predict needed allocation of resources, and led team for a successful roll-out, and hosted solution.

Originally setup in MySQL and moved to MariaDB

Client had a Drupal7 site that had the (not yet discovered) bug in that version of Drupal where the views cache was being rebuilt for anonymous users accessing the front page.

While the root cause could be covered up with proxy/cache servers an ultimate solution needed to be found.

One test was to see if replacing MySQL with MariaDB increased speed. It did.  Because the cache was broken in that version of Drupal it was causing excessive DB lookups. Changing from MySQL to MariaDB resulted in a 2x to 7x performance improvement.

Customer had a Java/Tomcat/Apache/MySQL application that was unable to absorb real-time GPS probe point data from millions of vehicles without choking. Vendor sending the real-time GPS data would get errors and stop the feed.  Lead programmer for application insisted that the only way to fix the issue was to "upgrade to 'Enterprise class' software like WebSphere and Oracle" 

Client had an emergency situation regarding a custom Windows .NET application that was an online store, a CRM system, an enterprise shipping/printing management system, and an employee management system.

Was able to immediately identify key security issues and attack vectors to stop ongoing attacks.

Assisted legal teams/law enforcement with chain of evidence and reports. Worked with legacy system code/server and client’s IT team to identify further weaknesses in system.

Led teams in multi-year process to modularize and replace legacy infrastructure without impacting business continuity. Upgrades included:

Web-based, vertically-integrated billing, accounting, and facility management system for condominium association management group.

Internally called "quickbooks for Condos" this web-based application was designed specifically for condos. Client had specific accrual-based accounting and tracking requriements for multi-decade planning and management. Client had complex goals set by outside designers who had never designed for web-based media before, a compliance group, and a finance group.

Web-based billing/accounting system and patient management software for associated network of doctors across Iowa.

Allowed doctors move to a paperless medical record system. Managed allowed procedures for doctor/patient interactions and automatically created PDFs in format required by insurance agencies and state regulators. Final implementation nearly completely automated billing/reports to state regulators and insurance agencies, saving client hundreds of person-hours per month.

An Enterprise Medical Facility had a new EPIC system to rollout. Both new and old systems used  Intersystems Database based on Cache (Mumps, M).

2004

Web-based Orthopaedic patient/schedule management system. Allowed doctor to track patient statistics, CMEs, meetings,
and allowed staff to provide doctor with documents needed on trips anywhere in the world.

Created bid, deliverables, and timeline for third party as sub-contractor. Lead
DBA, hired additional programming staff for project, trained them in
PHP-database programming, and managed project from inception to completion.

Project so successful for first physician that many other physicians in office setup the same
thing.