We provide IT Staff Augmentation Services!

Database Administrator Resume Profile

FL

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

Hire Now