David Johnson

Experience

• 

  GoDaddy

  Jan 2011 - now

  Support MySQL infrastructure at GoDaddy by means of automation including:• Automated patching and failover of MySQL clusters using Apache Airflow for workflow. Automation tasks written in Python.• MySQL User API using Python (Flask). Provides developers with ability to request new users, source servers, grants, and user removal. • Masterless Puppet for server provisioning. Extensive use of Hiera (hashes) to allow easy deployment of any number of MySQL instances, user grants, and server configuration per node or environment. Fashioned to use roles & profiles for easy maintenance. Cassandra infrastructure engineering and support. Show less As an SRE III, my work has been oriented more towards long-term project work where I have been tasked with designing and executing large scale foundational projects for the MySQL group. With this role, I have transitioned into a heavier DevOps workload. Notable projects I have completed:• Configuration Management with Puppet 4 and CI/CD pipeline to enforce configuration across servers and to allow for rapid and consistent deployment of files and packages.• Cross-datacenter migration of 400,000 databases, netting the removal of 140 physical servers and environment from old datacenter. Show less Reaching a Sr. level, tasked largely with improving current infrastructure including developing and deploying automation code. I coordinated with internal teams to deploy monitoring, perform deep diagnostics, and improve performance. • Created semi-automated LVM snapshot script used to rebuild broken replicas and provisioning new replicas. This was used thousands of times, saving DBAs 15+ minutes of work per instance rebuilt.• Built queuing and detection into pre-existing backup script severely increasing success rate.• Created user rotation scripts to automatically create, rotate and remove management users with zero downtime. Show less

  • Site Reliability Engineering Manager

    Sept 2021 - now

  • Site Reliability Engineer IV

    Sept 2016 - now

  • Site Reliability Engineer

    May 2015 - Sept 2016

  • Sr. MySQL Database Administrator

    May 2011 - May 2015

  • Assisted Service Department

    Jan 2011 - May 2011