Senior LAMPS Architect [E-Commerce]

PROFESSIONAL EXPERIENCE

EIM Sensor Corporation Reston VA Jan 2008 - Present

Remote Data Application Manager

Web application developer for a start-up company specializing in development of smart buoys for offshore environmental monitoring.

• Developed web-based interface for aggregating and visualizing data from remote sensors. Written in PHP on top of a MySQL database. Performs automated queries to remote data sources parses and filters incoming data and inserts into appropriate MySQL database table. Allows user to perform complex MySQL queries using an intuitive web interface.

• Managed a MySQL database of 100+ tables containing mission critical remote data that is continuously updated from environmental monitoring buoys deployed along the Gulf Coast.

• Supported the deployment of a DOD special ops groups on task to the US Border Patrol. Developed a field-based MySQL-driven set of tools that enabled the rapid identification and categorization of incoming threat data management of remote sensors and visualization of complex real-time data.

RED DOOR SOFTWARE LLC Manassas VA Sep 2007 May 2009

E-Commerce Database Manager

• Managed 50 MySQL database on approximately 10 different servers encompassing more than 4000 discrete MySQL tables serving 40 customers. All databases were tied to mission critical E-Commerce applications.

• Routinely integrated product information involving as many as 20 000+ SKU s 20+ dynamic entry interfaces 80+ database tables encompassing 10+ GB of information.

• Managed all performance issues for 10 web servers in the LAMPS stack (linux/apache/mysql/php) and provided frequent troubleshooting for MySQL-dependent PHP and Java applications.

• Set up MySQL tables to support WordPress Joomla Drupal Red Door Commerce PHPMyAdmin and other CMS apps on 10 remote servers.

• Performed routine MySQL management functions including: installation upgrading and removal of MySQL from Linux and Unix servers; configuring new users setting permissions creating tables and associated columns; performed management functions via command line msqladmin tool.

• Created customized automated applications for performing periodic MySQL queries extracting and filtering results converting to end-user format (xls doc txt xml etc) preparing end product and transmitting to user.

• Did troubleshooting of MySQL data analyzing misbehavior of PHP applications correcting datra formatting issues

• Very knowledgeable of MySQL commands within PHP; knowledgeable about other database applications including: Excel Access MS SQL. Familiar with the evolution and current state of Structured Query Languages in general.

• Expert in the use of PHPMyAdmin for managing large numbers of MySQL databases and users.

• Developed Web 2.0 applications for E-Commerce. Expert in the use of Javascript CSS XML HTML 4.0. Developed a proprietary library of dynamic javascript functions to extend the capabilities of open source Ajax libraries.

• Routinely performed data output/input tasks on large records of 50 000 products and more. This often included the development of custom PHP scripts to fine tune data. Expert in the conversion of data between various formats.

• Managed operational performance washed out log files as needed monitored automated in-house and off-site backups (generally daily incremenetal and weekly full) installed modules and patches as needed or as per customer request.

• Performed frequent security analysis of MySQL-dependent PHP applications specifically looking for SQL injection attack vulnerabilities.

• Advised application developers on possible conflicts between their applications and the format of the MySQL tables tied to their applications. Generally these involved issues with data types unique keys and duplicative records.

SWAN ISLAND NETWORKS INC. Portland OR May 2004 Aug 2007

Web Application Developer

• Developed data models and performed planning of architecture functions modules recovery standards and implementation.

• Worked with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure.

• Set up MySQL replication to manage load balancing online back-up and fail-over scenarios

Created modified and deleted indexes; also identified duplicate indexes to optimize MySQL servers' performance.

• Managed all aspects of the MySQL database portfolio using PHPMyAdmin and the command-line tool msqadmin.

• Acted as liaison with customers.

• Tested designed applications.

• Analyzed and determined information needs and elements data relationships and attributes data flow and storage requirements and data output and reporting capabilities.

• Monitored table space usage and used database metadata to facilitate application look-up efficiency.

• Dealt with typical performance bottlenecks and lock-contention problems.

• Configured MySQL and leveraged available settings to their full potential.

• Managed MySQL user accounts and assigned appropriate privileges.

• Managed the schema by adding and removing columns from tables choosing a suitable storage engine and character set for individual needs.

• Added a new primary key column to a table already filled with data and also managed and automated database schema evolution in the context of application updates.

• Managed on-site installation of strategic Homeland Security E-Business network in Southern Louisiana involving dozens of state/federal agencies and critical petrochemical facilities. Managed master database of open source intel. Managed key relationship with DOD s Advanced Concept Technology Demonstration (ACTD) program which resulted in continued funding.

• Developed PHP/MySQL applications for use in web-based data mining open source intelligence data manipulation GIS visualization and social networking.

• Performed data conversion and normalization to/from MySQL database tables.

NTT/VERIO Springfield VA Sep 2002 Apr 2004

E-Commerce Account Manager

Provided senior technical support services to high-value E-Commerce accounts primarily Asian companies with U.S. operations. Liaised frequently with on-site NTT managers conducted teleconferences nightly for technical managers in Japan and worked with U.S. counterparts in remote Verio data centers to facilitate change requests and problem resolution. Acted as customer advocate for complex problems that required the coordination of multiple people across wide technical/geographic/time domains.

• Stepped into newly created role in Enterprise Business Unit of a global Internet Service Provider (ISP) to provide strategic oversight of high-value E-Commerce accounts.

• Managed strategic technical E-Commerce support for all Japanese customers with revenues in excess of $1 000 000 per month.

• Performed account reconciliation that revealed over $100 000 in under-charged services.

GOSSAMER INC. Reston VA Jan 1996 Sep 2002

Web Application Developer

Provided expert software architecture and development services to a dot-com start-up specializing in E-Commerce applications. Pioneered methods for selling complex products on the Internet including multi-tier pricing structures customer-specific pricing schedules profile-based customer experience management internal/external product discovery interdependent product variations and web-based methods for data interoperability. Developed complex database frameworks for assembling web-based product and transaction data. One of the early developers of real-time shipping calculation and presentation modules for UPS and USPS. An early integrator of real-time payment processing services.

• Developed proprietary Perl-based multi-table database system for an early E-Commerce customer.

• Architected and managed development of first-generation E-Commerce engine specifically designed for SME industrial marketplace.

• Managed 10 software developers combination of on-site external consultants off-shore.

Contact this candidate