I provide expert consulting for companies needing help with DB2, Linux, Site reliability engineering, project management, automation, etc.
- Provides expert consulting for organizations needing DB2 and Mysql/Mariadb database assistance
- Provides expert consulting for organizations needing Linux/Unix assistance
- Wrote DB2 patching automation for Fortune 100 company bringing patching time for 550 instances from “never been done before”, to nine months by fifteen resources, to two months by a single resource
- Wrote DB2 monitoring/alerting process for small company with custom in-house reporting system
- Organized and upgraded neglected Puppet environment for company managing ~1500 Linux hosts
- Lead cleanup of ~100 instance Mysql environment that had broken replication, no backups, and no monitoring before training the new Mysql resource
Lead Database Administrator
-
DST Systems
Apr 2013 - Nov 2018
I worked as a database administrator in the DB2 environment. Most of my time was spent writing automation so that we could manage a large environment with a minimal number of DBAs.
- Managed ~2000 DB2 databases on (mostly) AIX, Linux and Windows
- Lead effort to upgrade ~850 databases from DB2 v9.x to v10.1 and v10.5
- Main point of contact for vendors (Commvault, Data Domain, IBM DB2) in resolving issues
- Designed and implemented workload manager implementation for 45TB DPF database
- Automated processes to upgrade DB2 servers, add partitions to partitioned tables, and do weekly maintenance
- Lead Optim Performance Manager implementation and Data Domain POC
- Wrote standards check automation to bring consistency to ~100 servers, hundreds of instances, and ~2000 DBs
- Wrote audit processes for privileged access and user level access
- Wrote processes for Data Domain implementation and custom backup audit/reporting
DB2 Advanced Support
-
IBM
Jul 2007 - Apr 2013
I worked on the tools, engines, and engines advanced support teams to assist customers with problems and critical down systems.
- DB2 security, connectivity, programming interfaces, and GUI tools
- DB2 backup/recovery, high availability, performance, and data movement
- Accepted escalations and critical down system issues
- Organized weekly meetings, creates education, and manages metrics as lead for ten person high availability team
- Prioritized backlog of 20-30 concurrent issues
- Collaborated with junior team members team to expedite problem resolution and transfer skill
- Coordinated between multiple stakeholders (clients, management, sales team, development, etc.) as single point of
- contact to drive issues to resolution
I helped with the management of the campus network and wrote automation to manage 1000+ devices at scale.
- Maintained 1250 Cisco switches and routers spread across multiple campuses
- Maintained compliance for standardized configurations and software levels across all network devices
- Built 802.1x test environment
- Created scripts using bash and expect to automate network management tasks