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.
Masters in Software Engineering.
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.
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.
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.
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.
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.