We provide IT Staff Augmentation Services!

Mysql Dba Php Resume

Bothel, WashingtoN

Professional Summary:

  • 5 years of experience in MYSQL Database Administration in single server and High Availability with replication environments.
  • Expert in implementing High Availability solutions around MYSQL database using MYSQL HA with replication option.
  • Expert in supporting MYSQL databases on all flavors ofUNIX operating systems like AIX, HP-UX, Sun Solaris and Linux.
  • Expert in supporting 100 plus databases.
  • Expert in handling planned and unplanned database outages and providing the RCA’s (Root Cause Analysis).
  • Expert in support databases running on Production and Non-production environments.
  • Expert on Oracle, MSsql server and PostgreSQL databases
  • Expert in Database Design, Analysis and Development of MySQL
  • Excellent knowledge in Object Oriented Concepts (OOP)
  • Well versed with complete Software Development Life Cycle (SDLC) process which includes Designing, Developing, Testing and Implementation.
  • Expert in multi-tier architecture Development
  • Expert in database recovery and optimization, MySQL server monitoring using tools
  • Proficient in developing and maintaining of functions, procedures, triggers, tables, indexes using MYSQL database programming language.
  • Experienced in IDEs like Dream weaver, Eclipse, Microsoft Visual Studio and Zend.
  • Expert in converting all databases from MyISAM format to Innodb storage engine to improve referential integrity as well as to increase performance.
  • Good knowledge in import, export, snapshot, optimization using analyze and explain plan.
  • Expert in upgrading MYSQL from 4.1 to 5.1 and above.
  • Expert in both WAMP and LAMP platforms.
  • Managed Database Storage Structures. Managing Database blocks, table’s paces and data files, generating DDL.
  • Self-motivated with strong problem solving and analytic skills and Ability to handle multiple tasks
  • Excellent communication skills with vary levels of management and user groups.
  • Education Qualifications:
    Masters in Software Engineering.

    Skill set:
    PHP 4/5, MySQL 5, PHPMYADMIN, LAMP, WAMP, Zend, Oracle 9i , Postgres, SQL Server, HTML, DHTML, CSS, JavaScript, AJAX, Microsoft Office, Dream Weaver, Adobe Flash, Shell, C, Java, Visual Source Safe, Smarty 2.6.7, Microsoft Visio 2003, Erwin, Drupal and Joomla

    Projects Summary:

    Confidential,Bothel, Washington 06/2008 - Present
    MySql DBA / PHP Developer
    Confidential,is a software technology company that enables high-quality voice and messaging services across multiple devices and locations over broadband networks. The project involves design and support of the databases in such a way that the availability was enhanced, clustering, query performance issues and data migration scripts.
    Hardware/Software:
    MySql versions 5.2.22, Oracle 9i, MS-DOS, Solaris, Linux, UNIX, IBM AIX, Sun UltraSparc, Intel Compatable, Perl, PL/SQL, Javascript.

    Responsibilities:

  • Administered and controlled Development and Quality Assurance environments for team of 10 developers by pushing development code through each stage of development life cycle.
  • Configured all aspects of MySql database structure among 9 instances across each stage of development including InnoDB and MySql-Replication related parameters.
  • Designed and configured all aspects of high-availability database replication and clustering, in specific master-master and master-slave replication processes and testing of MySql Cluster.
  • Reviewed all changes to Java code and applets to reform coding practices and to restructure poorly performing blocks to efficient stored procedures and functions in both MySql and SQL Server.
  • Responsible for sizing, tuning, installations, upgrades and security including other administration functions.
  • Involved in MySQL database backup and recovery strategies.
  • Involved in complete redesign of an entire web-based client login interface written in PHP
  • Involved in Maintaining and Developing PHP web applications
  • Created Indexes and foreign key constraints.
  • Created, tested, and maintained PHP scripts, MySQL programming, triggers and procedures
  • Collected specifications from client and designed the templates using PHP
  • Involved in Performance tuning of MySQL scripts and procedures using different methods.
  • Worked with development team on Query Performance issues from explain plan analysis through architectural analysis of data structures
  • I/O tuning of server memory to ensure optimization of high transaction environment which processed up to 2200 statements per second under peak load.
  • Implemented PHP session variables and cookies to maintain accuracy
  • Expert in MySQL on both Linux and Windows.
  • Designed new data definitions to support evolving application and business needs.
  • Diagnosed database corruption problems and hanging issues and proposed solutions.
  • Developed all data-migration scripts and coordinated database conversion efforts among developers in project tasked with conversion of portions of Oracle database to equivalent MySql functionality through a series of Perl-driven code that converts and cleanses data in process of migration.
  • Worked in conjunction with on-going development efforts to write “health-check” data-integrity scripts that ultimately identify faulty data patterns resulting from code-driven logic error.
  • Confidential,Brooklyn, New York 06/2006- 06/2008
    MySql DBA / PHP Developer
    Confidential,provides facility managers with a single platform to procure manage and pay for facility maintenance services from their own network of contractors. The project involved database design including query analysis and index optimization. Installing mysql database and support software at client side.
    Hardware/Software:
    MySql versions 5.0, Oracle 9i, MS-DOS, Solaris, Linux, UNIX, IBM AIX, Sun UltraSparc, Intel Compatable, Perl, PL/SQL, Javascript.

    Responsibilities:

  • Configured and troubleshot activities in to the real time systems and production MySQL databases for SMS and push services.
  • Handled the technical escalation related issue from 1st line at high priority and on call 24*7 support to team for DB issues.
  • Made shell scripts for data extraction from the raw data (Logs) as per required by the clients.
  • Created forms to collect and validate data from the user and in PHP
  • Maintenance and support activities of MySQL v5.0 environment.
  • Upgraded MySQL environment to take advantage of features in v5.1
  • Programmed PHP search function for clients database.
  • Built PHP and CSS system for controlling text display issues cross-platform and cross browser
  • Development of Maintenance and migration scripts (PERL).
  • Designed and documented MySQL disaster recovery and fail-over plan
  • Integrated availability monitoring for MySQL and primary website (PERL,PHP)
  • Database designing including query analysis and index optimization.
  • Implemented, installed MySQL DB and support of software products at the client site and involving client interactions.
  • Extensively used Sandbox testing to execute secured transactions through PAYPAL.
  • Extensively used JavaScript for better display of data.
  • Extensively used SqlYog to manage MySQL.
  • Confidential,Watchung, New Jersey 04/2005-06/2006
    MySql DBA / PHP Developer
    Confidential,provides discovery lifecycle management solutions. Its solutions are used for the retention, acquisition, processing, review, and production of documentary evidence required by the legal and compliance marketplaces. It involved in monitoring activity, back up strategy from replicated nodes Including schema redesign optimized for reports.
    Hardware/Software:
    MySql versions 5.0, Oracle 9i, MS-DOS, Solaris, Linux, UNIX, IBM AIX, Sun UltraSparc, Intel Compatible, Perl, PL/SQL, JavaScript.

    Responsibilities:

  • Performed all tasks associated with daily operations such as database availability, monitoring activity, installations, upgrades, and back-up strategy.
  • Created Perl scripts to perform administrative tasks like running ANALYZE and OPTIMIZE on database tables.
  • Implemented back-up strategy from replicated nodes.
  • Identified reporting functionality and create and design server node to handle all reporting and read-only queries.
  • Created and designed Data Warehousing solution for reporting and data mining aspect of application, including schema redesign optimized for reports, and all ETL scripts necessary for loading and archiving of data.
  • Retrieved all statements from Slowquery log to analyze for performance tuning.
  • Restructured SQL statements for improved efficiency utilizing views, HEAP tables where possible, and advanced index use in some cases.
  • Split out all read-only and reporting functionality into slave nodes as to lighten traffic on primary nodes.
  • Monitored all memory consumption for MyIsam and InnoDB tables.
  • Performed index analysis to find cases where indexes are missing, and where there are duplicates which can be removed in both MySql and SQL Server.
  • Configured all aspects of high-availability MySql Cluster installation across a 6-node deployment.
  • Converted existing application using master-master replication to function in a Clustered environment, including modifying schema for row sizing when necessary.
  • Confidential,Indianapolis, IN 10/2004 – 3/2005
    PHP ,MySQL Developer/ DBA
    Confidential,is an online store for Bath and Kitchen Fittings and accessories. They sell Faucets, Bars, etc. through their website and other shopping sites. The aim was to provide products through categories and manufacturers.
    Hardware/Software:
    MySQL 4.1,JavaScript, PHPMYADMIN, CSS, MS Excel 2003, Window XP, Microsoft Word 2003, Microsoft Visio 2003, MS Outlook, Drupal.

    Responsibilities:

  • Maintained and supported activities for 20 production instances of MySQL.
  • Redesigned and implemented multi-homed environment to linear.
  • Development and support of core domain management application base on Zend Framework
  • Designed new data definitions to support evolving application and business needs.
  • LAMP (PERL, SOAP) development of automation and import services of third party business metrics (Omniture, Google Analytics).
  • Developed custom plugins/tests for the Nagios fault notification system
  • Embedded images and Flash videos in the website
  • Involved in SQL optimization for usability and performance of production systemsDatabase architecture, design and data modeling
  • Instructed Junior Developers, Data Design Best Practices, SQL optimization, Advanced reporting techniques.
  • Experienced with analysis of Google Ad-sense metrics and other web based revenue sources.
  • Exported data from excel sheets to database.
  • Analyzed requirements and delivered the change requests as per schedule.
  • Deployed in Linux Server and configured LAMP.
  • Hire Now