Cloyd Smith, Senior PHP Web Developer, MySQL DBA in Seattle, WA

---

 

Employment History

Flowplay

• Senior Database Administrator and Systems Engineer - OurWorld.com
  • Technology Summary: MySQL, Apache

Adapp Solutions

• Senior Development Engineer - HasOffers.com
  • Technology Summary: OO PHP, CakePHP, MySQL, Apache, Nginx, Memcached, Javascript, Jquery, Ruby, Chef, FirePHP, Xdebug
  • ~2900 Customer Databases with up to 10 million rows per database
  • Developed database schema upgrade and management tool
  • Developed database schema verification tool
  • Developed self contained deployment code for direct to customer sales for external hosting
  • Enhanced error reporting code to help proactively catch and fix customer facing issues
  • CO-lead agile development team of 5 developers
  • Reduced 'brand' creation time from an average of 7 minutes to 22 seconds
  • Improved core CakePHP libraries to prevent cross sub-domain login exploits
  • Created peer code review process to help ensure quality code and to prevent architecture issues
  • Standardized staging environment to ensure valid testing pre production deployment
  • Added internationalization features to support multiple currencies and timezone support
  • Audited database schemas to ensure proper indexes and data types and ensured proper relational mapping
  • Improved developer debugging tools to allow production debugging without any customer impact
  • Audited MySQL server and recommended improvements that reduced average queue processing time by 12%
  • Improved Nagios health check scripts to verify installed packages meet application requirements

Name Intelligence

• Lead Developer, Team DBA, Release Manager - DomainTools.com
  • 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, 1.2 billion rows, 250 tables, replicated in 2 clusters
  • Reduction of deployed errors to production environment with the creation of a staging environment
  • Managed team of 5 developers, assigning tasks to fit skill-sets and project direction
  • Lead the design of a middle tier unified API layer for product access and control
  • Performance tuning of site module that is getting ~700,000 unique visitors per day
  • Reduced average page generation time from 4.4 seconds to 1.5 seconds
  • Refractor of existing code to remove logic errors and reduce memory footprint
  • Development and deployment of customized flash-based client push server for live auction system
  • Developed deployment scripts to standardize code rollouts in a diverse environment
  • Designed an access control system for site resource limits with predefined failure characteristics
  • Enhanced shared security framework to remove potential XSS issues
  • Increased search engine visibility by optimizing pages for linear rendering for certain user-agents
  • Designed and implemented peruser 'click stream' tracking for usability studies and enhancements
  • Refactor billing system to remove issues and increase reliability
  • Utilized SEO improvements to increase placement in major search engines
  • Increase ad revenue by changing placements following user experience research

Silicon Mechanics

• Lead Developer
• MySQL Database Administrator
• Developer
  • Technology Summary: OO PHP, MySQL, Apache, Memcached, Javascript, PrototypeJS, Scriptaculous, Xdebug, Xcache
  • Code-base of approximately 120,000 lines and 800 files
  • Database of approximately 2.2 gigs of data, 1.2 million rows, 200 tables
  • Cross departmental requirements gathering, working directly with 3 vice presidents at once
  • Precise estimation of implementation time
  • Code architecture planning and implementation
  • Convert existing procedural code by objectification
  • Clarify existing code to reflect best practices
  • 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

• IT Manager
  • Managed help desk technician for ~100 users
  • Planned and deployed workstations, VoIP phones, and other infrastructure
  • Fulfilled System Administrator role in tandem

• System Administrator
  • Technology Summary: CentOS, Fedora, MySQL 5.0, PXE, Apache 2.1, Procurve Switches, Xen, Shorewall, NFS
  • Worked with Development team for growth planning
  • Architecture planning to satisfy growing needs
  • Infrastructure planning allowed unobstructed internal growth of 100% over 6 months
  • 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
  • Technology Summary: PHP, MySQL, VB 6

Contract History

Schedules Direct

• System Administration, Database Administration, Virtualization
  • Technology Summary: MySQL, CentOS, Xen, Perl

Wartsila Canada

• Core site improvements for government mandated database application
  • Technology Summary: OO PHP, MySQL, Apache

iFloor

• Web 2.0 Marketing Banner Widget
  • Technology Summary: Javascript, PrototypeJS

Enetics

• University of Washington, CTCS - Firewall Deployment, Network Re-architecture
  • Technology Summary: CentOS, Shorewall, Ulog, Samba, Apache

AMQ Software

• System Administrator, LAMP Performance Tuning
  • Technology Summary: CentOS, Apache, OpenLDAP, MySQL, PHP, Xcache

Volunteer History

Schedules Direct

• Advisory Council Member - Technical, Community

MythTV

• Developer
  • Technology Summary: OO PHP, MySQL, C++, Perl, Python, GDB, QT

Transgaming

• Beta Tester - Cedega
  • Technology Summary: C, GDB, strace

Lirc_mod_mce

• Code Contributer
  • Technology Summary: C, GDB

Certifications

MySQL AB

• MySQL 5.0 Performance Tuning
  • 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

References

Public recommendations are available at http://www.linkedin.com/in/kormoc. Direct contact information available upon request.