Jonathan Gnagy

About Jonathan Gnagy

Systems Engineer experienced with GNU/Linux, virtualization, cloud infrastructure, and a backgroundin supporting a variety of services. Technology Manager with experience leading small teams with diverse technical backgrounds. Heavy emphasis on high-availability and scalable architectures across a variety of technologies and platforms. Well-rounded IT background with a solid understanding of networking and infrastructure, core Internetservices (DNS, SMTP, HTTP, etc.), and modern approaches to solving complex large-scale problems. Experienced leader and mentor, with a long history doing both internal and client training, leadingworkshops, conference speaking, and serving as a senior escalation point to other team members. Honed skill set for administering, performance tuning, and engineering reliable solutions for webservers, application servers (Java and Rack-based), database servers (MySQL, PostgreSQL, DB2,and others), caching and balancing proxy servers, and many others on Linux and FreeBSD. An \"automate myself out of a job\" mindset, based a desire to sleep through the night andthoroughness to ensure reliable, repeatable, and maintainable processes. Not only considered a Jack-of-all-trades for most things IT, but also regarded as a subject matterexpert for API Gateways, LDAP and identity systems, Ruby Development, Kubernetes, and more.

Experience

1. Staff Production Engineer, Database Platform

   Shopify

   Nov 2021 — Present

   Maintained \"KateSQL\", our Ruby on Rails control plane for managing thousands of MySQL databases on GKE. Championed the development of our self-service MySQL upgrade tooling, allowing us to upgrade thousands of MySQL databases and servers safely with zero downtime and minimal user intervention, all during our busiest time of the year. This tooling was built into our Ruby on Rails-based MySQL management platform. Mentor junior team members in MySQL, Kubernetes, and Linux, helping them grow their skills and become more effective contributors to the team. Wrote a MySQL GRANT statement parser and generator, allowing us to implement a much richer user permissions model. As Team Lead, I\'m heavily involved in most technical discussions about the Platform my team provides. I create and update our roadmap, work with leads from other teams to ensure we meet their current and future needs, and am a stakeholder for projects across many areas. I leverage my extensive knowledge of Kubernetes and Linux to guide the team in making architectural decisions that improve the platform\'s performance, scalability, reliability, and capabilities. I\'ve worked hard to consolidate and simplify our systems while ensuring our platform provides our users\' desired features.

Education

• Arizona Western College

  A.A.S., Computer Information Systems

  2003 — 2008

• Northern Arizona University

  Bachelor's Degree, Technology Management

  2014 — 2019

Skills

• Jvm Tuning
• Troubleshooting
• Ruby on Rails
• Ldap
• Jabber
• Freebsd
• Ubuntu
• Mail Server
• Virtualization
• Websphere
• Oracle
• Firewalls
• Cisco Technologies
• Leadership
• Teaching
• Debian
• Mercurial
• Bash
• Amazon Web Services (Aws)
• Web Hosting
• Apache
• Servers
• IT Infrastructure Architecture
• Php
• IT Infrastructure Management
• Http
• Postgresql
• Mysql
• Javascript
• Solr
• Tomcat
• Web Applications
• Java
• Ruby
• Git
• Performance Tuning
• Perl
• Operating Systems
• Network Security
• Network Administration