Qualifications Summary

• 5 years experience administering large MySQL production and development database servers
• 4 years experience administering Linux and Mac OS X web/dns servers
• 5 years experience programming in PHP using AJAX, JQUERY, SOAP, HTTPS POST, other web services
• 3 years experience developing websites using HTML, CSS, Javascript
• 5 years 24/7 support of production web servers in remote data centers
• 5 years developing complex queries, reports, views, stored procedures and triggers

Employment

Database Administrator:

• Administer large databases with millions of records and transactions MyISAM and InnoDb tables
• Setup and maintain database replication master slave, master master HA
• Setup and monitor database security measures
• Monitor and maintain database optimization with use of indices and normalization
• Setup and maintain data backup and restoration
• Maintain wiki page with server and database structure as well as explanations of stored procedures,etc.
• Develop complex queries for reporting, data import and maintenance archiving
• Manage database optimization to improve performance and prevent system lag and table locking
• Create new tables and structure to fulfill business needs of company
• Create stored procedures, triggers and views to optimize reporting interfaces and maintenance
• Database Administrator:
• Administer large databases with millions of records and transactions MyISAM and InnoDb tables
• Setup and maintain database replication master slave, master master HA
• Setup and monitor database security measures
• Monitor and maintain database optimization with use of indices and normalization
• Setup and maintain data backup and restoration
• Maintain wiki page with server and database structure as well as explanations of stored procedures,etc.
• Develop complex queries for reporting, data import and maintenance archiving
• Manage database optimization to improve performance and prevent system lag and table locking
• Create new tables and structure to fulfill business needs of company
• Create stored procedures, triggers and views to optimize client interfacing portals

Confidential

PHP Programmer

• PHP 5 programming using MVC and Darwin.
• Version control using Subversion
• MySQL 5 development and Linux command line interfacing
• Collaborative project team member
• Web development using HTML, CSS, JQuery and Ajax
• Information Developer II
• C Programming
• UNIX development
• Oracle 10g PL/SQL development
• Import Medicaid health record XML data into system, parse it and import data into database
• Updated client interface to make data input database driven instead of manual
• Project Team Leader
• Workforce Reduction program causes loss of job, April 2010
• Database Administrator/PHP Programmer
• MySQL 4/5
• Administer large databases with millions of records MyISAM and InnoDb tables
• Setup and maintain database replication master slave, master master HA
• Setup and monitor database security measures
• Monitor and maintain database optimization with use of indices and normalization
• Setup and maintain data backup and restoration
• Create technical instructions for different functionality in system backend
• Develop complex queries for reporting, data import and exporting
• Manage database parameters to improve performance and prevent system lag and table locking
• Create new tables and structure to meet and exceed client requirements
• Create stored procedures, triggers and views to optimize client interfacing portals
• PHP development and programming PHP4 and PHP5
• Web Development HTML, CSS, JavaScript
• Developed elaborate reporting system using multivariate template testing
• Complex visitor tracking and conversion analysis
• PHP development importing and exporting data via web services such as HTTPS POST, AJAX, cURL, SimpleXML, nuSOAP
• Program data validation code with Javascript and external system validation using JQuery and AJAX
• Create and update intranet portal to automate daily processes and improve efficiency using PHP and MySQL
• Create sophisticated reporting UI for clients and internal employee
• Create modularized code using Class structures, Interfaces and Functions to reduce redundant code and improve productivity
• Optimize existing PHP code and MySQL queries to improve system performance and efficiency
• Develop backend functionality for E-commerce system, including Virtual Call Center and Shopping Carts using corporate marketing focuses.
• Our VCC system mimicked the user experience if a customer called an order in on the phone, including upsells, last chance offers, third party upsells, email optins and survey taking stages
• Develop integration with credit card processing companies Litle, Transfirst, Paypal Pro, Authorize.net, PowerPay, USA Epay
• Setup system to use GoDaddy API for domain purchases and renewals and Comodo API for purchasing and setting up SSL certificates
• Integrated BadCustomer, Bing Cashback and other services into existing system
• Export client fulfillment data using various web services and transport protocols HTTPS POST, cURL, SFTP, LFTP, email, XML, SOAP envelopes, Expect in real time or in batch files
• Encrypt export data using PGP encryption or password protected ZIP files
• Debug PHP code with unit testing and syntax checking
• Utilized Subversion for versioning of code for upload to production system and development system
• Setup weekly backup of PHP code
• Network administration Linux, Mac OS X servers, CISCO routers and firewalls
• Network security User administration and setup, well formed PHP code
• Operations team member and leader of Quality Assurance and Customer Relations committee
• Domain registration and administration DNS, Apache, Domain Registration and SSL certificates

Confidential

Project management in a team environment

• Time management and individual initiative to complete projects
• Alter, update and setup client Web sites and portals
• Implement Helpdesk CRM solution for client ticket submission and project management
• Integrate Helpdesk into existing web portal with MySQL and PHP program coding.
• Utilize Website Baker, Sugar CRM in servicing of client web sites.
• PHP programming to add functionality to client websites and customize applications such as OsCommerce, SugarCRM, HelpDeskPilot.
• MySQL: Create complex queries and new database structure client requested functionality requirements