During hurricane Sandy, the JPMC data center in NJ was 2 inches from getting flooded. The failover procedure was completely manual, and estimated to take two full days. It was never implemented.
🡒 Wrote Ansible playbooks to fail over databases and service applications, reconfigure routers, load balancers, DNS, etc. The automated failover took less than two hours, providing much wanted preparedness.
At the New Jersey Turnpike, the shift summarization process needed to run three times daily. It was taking over 24 hours, creating a backlog and delaying payments.
🡒 Replaced an overly complex join with a 11 parallel linear scans, merging on the client side reducing runtime to 20 minutes, quickly eliminating the backlog.
Accountants at Entergy were concerned they were spending money on licenses for unused databases.
🡒 Developed an inventory plugin for Ansible to scan the network for SQL Server and Oracle databases, and a playbook to check if they were being actively used, saving the unnecessary license money.
At Cybersoft, a false positive virus pattern indicated operation system installation media as infected. Testing on a large enough enough collection of OSes took too long time to allow daily pattern releases.
🡒 Created a 4-gram index over the known good files, allowing virus analysts to check each new pattern created, getting a response in seconds, keeping daily releases free of false positives.
At AT&T, when moving DNS databases to new hosts and software, they were concerned about any errors the migration might induce. It was not feasible given the millions of names in the domains, to take 10-100 ms to query each name, one after the other.
🡒 Used Net::DNS::Async to allow the comparison to be done in parallel, and finished in minutes, giving assurance about the correctness of the migration.
Migrating UniData database and applications from HP-UX to Red Hat.
Developed software in support of Protegrity tokenization.
Automated data center resiliency procedures.
Automated operational procedures.
Provided Logging as a Service.
Supported the SevOne Network Monitoring System.
Provided subject matter expertise for DNS.