Rob Smith, Senior PHP and MySQL Devops in Seattle, WA


Employment

FlowPlay
Senior Database Administrator and Systems Engineer
February 2010 - Present

Technology Summary: MySQL, InnoDB, XtraDB, CentOS, 3ware, Supermicro, HP Procurve, Nagios, Cacti, OpenVPN
  • Multimaster MySQL setup over 10 servers
  • Monitoring via Nagios and Cacti
  • Networking architecture improvements targeting latency
  • Developed backup, archival, and validation procedures
  • Audited and improved queries and schemas
  • Setup and administered firewalls using Shorewall
Adapp Solutions
Senior Development Engineer
June 2009 - February 2010

Technology Summary: CakePHP, MySQL, Apache, Nginx, Memcached, Jquery, Ruby, Chef, FirePHP, Xdebug, Nagios
  • ~2900 Customer Databases with up to 10 million rows
  • Developed database schema upgrade and management tool
  • Developed database schema verification tool
  • Developed self contained deployment code
  • Enhanced error reporting code
  • CO-lead agile development team of 5 developers
  • Improved 'brand' creation time by a factor of 20x
  • Improved core CakePHP libraries to prevent exploits
  • Developed peer code review process
  • Standardized development and staging environments
  • Added internationalization features
  • Audited and repaired production database schemas
  • Improved developer debugging tools
  • Audited and tuned production MySQL servers
  • Improved Nagios health check scripts
Name Intelligence
Lead Developer
June 2008 - June 2009

Technology Summary: OO PHP, MySQL, Apache, Memcached, Javascript,Jquery, PrototypeJS, Ruby, Xdebug, ExtJS
  • Code-base of approximately 700,000 lines and 4,000 files
  • Database of approximately 3.5 terabytes of data
  • Development of staging process
  • Managed team of 5 developers
  • Lead the design of a middle tier unified API layer
  • Performance tuning of modules that is getting ~700,000 uniques
  • Reduced average page generation time from 4.4 seconds to 1.5
  • Refractor of existing code to reduce memory footprint
  • Development and deployment of customized live auction system
  • Developed deployment scripts to standardize code rollouts
  • Designed an access control system for site resource limits
  • Enhanced shared security framework to remove potential XSS
  • Designed and implemented peruser 'click stream' tracking
  • Refactor billing system to remove issues and increase reliability
  • Utilized SEO improvements to increase placement
  • Increase ad revenue by following UX research
Silicon Mechanics
Devops
March 2005 - June 2008

Technology Summary: PHP, MySQL, Apache, Memcached, Javascript, PrototypeJS, CentOS, PXE, HP Procurve, Shorewall
  • Code architecture planning and implementation
  • Clarify existing code to reflect best practices
  • Convert existing procedural code by objectification
  • Added Web 2.0 functionality with prototype and scriptaculous
  • Performance tuning in critical areas to get the largest ROI
  • Work directly with end users to solve process inconsistencies
  • Architecture planning to satisfy growing needs
  • Addition of redundant servers for critical services
  • Internal and off site backup coordination and restoration plans
  • Networking architecture implementation and improvements
Reprint Management Services
Application Developer
January 2003 - March 2004

Technology Summary: PHP, MySQL, VB 6

Contract / Volunteer / Misc

Wingman Brewers
Director
August 2010 - Present
Schedules Direct
System Administration, Database Administration, Virtualization
January 2009 - Present

Technology Summary: MySQL, CentOS, Xen, Perl
Wartsila Canada
Core site improvements for government mandated database application
September 2008 - Present

Technology Summary: OO PHP, MySQL, Apache
iFloor
Web 2.0 Marketing Banner Widget
May 2008

Technology Summary: Javascript, PrototypeJS
Enetics
University of Washington, CTCS - Firewall Deployment, Network Re-architecture
September 2007

Technology Summary: CentOS, Shorewall, Ulog, Samba, Apache
Schedules Direct
Advisory Council Member - Technical, Community
September 2007 - Present
MythTV
Developer
February 2007 - Present

Technology Summary: OO PHP, MySQL, C++, Perl, Python, GDB, QT
Transgaming
Beta Tester - Cedega
May 2005 - October 2011

Technology Summary: C, GDB, strace
AMQ Software
System Administrator, LAMP Performance Tuning
March 2004 - March 2008

Technology Summary: CentOS, Apache, OpenLDAP, MySQL, PHP, Xcache
Lirc_mod_mce
Code Contributer

Technology Summary: C, GDB

Certifications

MySQL AB
MySQL 5.0 Performance Tuning
March 20 - 23, 2007

  • Develop a tuning strategy
  • Display knowledge of MySQL architecture
  • Display knowledge and ability to use diagnostic tools
  • Display knowledge and ability to use tuning tools
  • Write queries against the INFORMATION_SCHEMA database and be able to decipher the metadata obtained
  • Understand the relational database model and both the positive and negative implications on performance
  • Display, decipher and edit server configuration variables to improve performance of your applications
  • Display and analyze status variables to ensure that their applications are utilizing the settings in the most effective manner
  • Write queries that take advantage of the MySQL 5.0 performance enhancements dealing with queries and indexing
  • Decide which of the storage engines could be used in their specific application needs
  • Evaluate the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance
  • Evaluate hardware and OS for effects on performance
  • Evaluate techniques for loading data into the database and effects on performance