Application Development

I have experience in the following areas:

Functionality

Integrating APIs from payment processors and support desk suites into application code

Creating secure bill pay pages for handling PCI-DSS compliant transactions

Creating a templating system for rebranding of partner portals in current application codebase

Performance

Speeding up page load time by optimizing MySQL queries

Creating a more responsive UI by loading assets after page load and before user action

Rewriting application code to split requests between web servers and application servers

UI/UX

Creating an assistance callout of FAQs and support articles to reduce call volumes and support tickets

Integrating applications to use a single sign-on (login share)

Converting a UI for international, multi-language support

Working internationally with an application development team overseas to solve issues and provide bug fixes for their software

Tools of the trade: PHP, jQuery (Javascript), XML, SQL, HTML5, CSS, APC/xCache, Wordpress, Zend Studio, SVN

Some experience in: Drupal, C#, C++, Java, Android Studio

Database Administration

I have experience in the following areas:

Replication

Designing and implementing Master-Master replication systems with multiple slave servers in high performance & high availability environments

Rolling back datasets and stepping through transactions

Backup

Automating database backups by writing custom cronscripts

Performance

  • Auditing slow queries then rewriting queries more efficiently
  • Creating appropriate table indexes for slow queries with poor index usage
  • Converting tables to appropriate table engines
  • Failing over and Upgrading database servers in production environments
  • Splitting database servers and the application for read/write queries
  • Tracking table sizes and increasing memory to keep data sets in RAM

Tools of the trade: MySQL Server, Innodb, sysbench, Memcached

Systems Administration

I have experience in the following areas:

Virtualization

Managing web, application, database, storage, and DNS servers in virtualized environments

Cloning application servers to turn up more instances based upon higher demand

Setting up test and QA servers

High Availability

Automating storage and database server failover using DRBD and Heartbeat

Server Performance

Analyzing IOPS on database servers and recommending upgrades based upon findings

Auditing Apache logs to identify performance issues

Modifying Apache server variables to improve performance

Automation

Writing scripts to push out server updates automatically on Linux and Windows servers.

Tools of the trade: Debian, Apache, rsync, SCP, SSH, iostat, htop, NFS, Jmeter, Wireshark, DRBD, VMWare ESXi, Plesk, Bash

Some experience in: IIS, Squid/nginx