Summary

• Oracle Certified MySQL DBA/Architect
• MySQL Subject - Matter Expert
• Senior DBA with 12 years of experience with MySQL on both Linux and Windows
• Architected the content management system database of
• 5 years of experience with Oracle administration on both Linux/Unix and Windows
• 1 year managing SQL Server RDBMS, SSIS
• Over 1 year experience working on PostgreSQL and the infobright data warehouse
• Expertise in architecting ecommerce oriented databases from scratch
• Hands-on experience with Rackspace Cloud Computing
• Experience using Percona Toolkit to simplify complex MySQL and system tasks
• Hands-on experience with Percona XtraBackup streaming/compressed/incremental backups
• Hands-on experience with MySQL Enterprise Backup
• Hands-on experience working with MySQL/Oracle Engineer Support Team
• Installed, designed, upgraded and Tuned MySQL standalone and MySQL NDB Cluster databases
• Expertise in Setting up MySQL Multi-Master/Multi-Slave Circular Replication.
• Expertise in setting up 5 nines High Availability through MySQL NDB Cluster and Heartbeat cluster
• Relational Database Architecture from scratch. Great experience with Normalization/Denormalization
• Ability to work at MySQL binary logs level. Disaster recovery planning and point in time recovery
• Installing MySQL Enterprise Monitor. Monitoring standalone database servers and NDB cluster nodes through MySQL Enterprise Dashboard.
• Configuring proxy servers through MySQL Enterprise Monitor to set up the query analyzer component.
• Used Redgate to compare data and database schema changes
• Hands-on experience with MyISAM, Memory, Archive, NDB and InnoDB engines. Good understanding of the tradeoff of using those table engines based on client applications requirements.
• Hands-on experience with SQL/PLSQL, Perl and Unix Shell scripts
• Experience with ETL tools such Talend and Informatica
• Worked with third-party monitoring tools like Toad, Spotlight, Navicat
• Keeping pace with upcoming MySQL releases and some NoSQL technologies.

TECHNICAL SKILLS

Third part tools And Programming/software skills

Unix Shell, SQL, PL/SQL, Perl, Eclipse, JDK, APACHE, TOMCAT, Heartbeat, Mon, Toad for MySQL/Oracle, Spotlight, Navicat for MySQL, MySQL Administrator, pgAdmin III, Talend, SSIS, Confluence, Jira, Redgate

Database Management Systems

Oracle, MySQL, PostgreSQL, Infobright, Access, SQL Server 2012, Percona

Information Modelling

Network Background

AMC Designer, Win Design, UML, Toad, MySQL Workbench

LAN, TCP/IP, Putty, Yast, Sockets Interface, Multi-Threading

Cloud Computing

Experience working with Rackspace Cloud Database Solution

Operating Systems

UNIX AIX, Linux Suse, Red Hat, Ubuntu, Windows, 2000, NT4, XP, vista, Mac OS X

WORK EXPERIENCE

Confidential

Certified MySQL DBA

Confidential is the leading internet ordering software and service provider for the restaurant industry. It provides comprehensive on-demand ordering systems, which are fully customizable, easy to integrate and convenient to use by businesses of all sizes from independent restaurants to the world's largest pizza chains. One of its most important clients is pizzahut.com, ecommerce website generating more than 1 billion dollars per year in online sales.

Responsibilities

• Currently responsible for the overall website CMS database in the backend.
• Setting and administering 30 MySQL 5.5.30-ndb-7.2.12 instances in production, staging and QA environments on Linux Ubuntu .
• Upgrading production, staging and QA databases from MySQL 5.5 to MySQL 5.6
• Using Percona toolkit to simplify complex MySQL and system tasks
• Using Percona XtraBackup to back up staging and production databases
• Creating documents on Confluence outlining best practices to efficiently query databases, database architecture layout, disaster recovery planning and every aspect of the CMS database systems.
• Set up multiple innodb slaves replicating from multi-master database servers across interstate data centers.
• Implemented procedures for backing up databases using multiple technologies: ibbackup, ndb native backup command, SAN etc.
• Excellent knowledge and practice of different recovery tools: mysql, mysqlbinlog, ndb restore etc.
• Providing assistance to the development and business teams on query performance.
• Established and documented best practices and standards for using MySQL.
• Setting and optimizing MySQL NDB cluster and standalone servers based on business requirements.
• Set up MySQL Enterprise Monitor for monitoring of the cluster and standalone databases.
• On call in a 24x7x365 environment to respond to various database issues such as failure etc.
• Working experience with some Linux administration tasks, such as creating/managing user profile etc.

Environment : MySQL, MySQL NDB Cluster, Linux Ubuntu 12.04.4, Windows Vista, SAN, Toad for

MySQL, Spotlight, Navicat, Perl , PHP, TCP/IP, Putty, Yast, Percona, NAS

Confidential

Certified MySQL DBA

Confidential Data Systems is the leading business-to-business fulfillment and data management service. Hallmark offers integrated data management solutions across print, email, and web platforms allowing publishers to manage print data files, email records, digital subscribers, website logins, and gated content.

Responsibilities

• Managed/Administered multiple MySQL 5.5.25a instances in production and dev environments on Linux SUSE and windows. Some have more than 1.5 TB of data.
• Worked on data warehouse design and ETL tool in order to consolidate data coming from different sources
• Ability to come up with the best database designs Normalized Denormalized that better fits business needs
• Proficiency in MySQL query optimizer, triggers, stored procedures, events etc.
• Proficiency in troubleshooting countless MySQL server issues and tuning queries on a daily basis.
• Provided assistance to the development team on query performance and database security
• Created documents outlining best practices to efficiently query databases
• Implemented procedures for backing up databases using multiple technologies: ibbackup, SAN etc.
• Proactively created documents and processes outlining different possible database failures and the recovery method to use to bring the database to a consistent state.
• On call in a 24x7x365 environment to respond to various database issues such as failure and performance
• Configured the MySQL Enterprise Dashboard tool for monitoring database alerts
• Documented and creating processes to make MySQL and SQL Server work efficiently together
• Managed multiple database replications and high availability solutions to make sure that data is always available even in case the primary database node fails. Setting up MySQL NDB Cluster on multiple servers.
• Managed and implementing load-balancing solutions using both master and slave databases.
• Developed standards for database promotions, synchronization between test, dev and production.
• Implemented processes communicating between SQL Server SSIS, Linked Servers, AS400 DB2 and MySQL
• Established good practices and standards of MySQL for the development and business teams.

Environment : MySQL, MySQL NDB Cluster,Linux Suse 10.1, CentOS 5.2, Windows Vista, SAN, SSIS,MS

SQL Server, Heartbeat, AS400, Toad for MySQL, Spotlight, Navicat, Perl , PHP, TCP/IP, Putty.

Confidential

MySQL DBA

Responsibilities

• Managed/Troubleshoot MySQL 5.1.30 in production and dev environments on Linux Red Hat
• Architected new databases schemas meeting the requirements of 1NF, 2NF and 3NF
• Provided assistance/recommendations to developers on a daily basis
• Proactive maintenance, improving recording into big tables undergoing at least 20 million daily inserts
• Ability to implement PL/SQL, stored procedures, triggers for lowering traffic between servers clients and for customer reporting
• Excellent experience with repairing tables from crash and system failure. Shrinking and Optimizing MyISAM and Innodb tables with lots of holes
• Databases Tuning on a daily basis for preventing issues and providing capacity planning. Familiar with Mysqltuner script for grabbing statistic metrics and recommendations to enhance MySQL performance.
• Deployed shell scripts for taking daily incremental backups, InnoDB Hot backup and for making sure daily backups are successful otherwise notification email is sent out.
• Excellent writing and communication skills and good practice of technical documentation
• Problem solving mindset and can-do attitude
• Hands-on experience with data warehouse for improving data compression and data retrieval from large dataset.
• Upgraded from MySQL 4.1 to MySQL 5.1.30
• Set up and troubleshoot Master-Slave/Multi-Master replication scheme, MySQL Cluster, failover from scratch.

Environment : MySQL 5.1.30, Linux Red Hat, Windows XP, Spotlight, Navicat, pgAdmin III, Perl , Java ,

Putty, Cisco VPN, infobright data warehouse, Heartbeat, Mon,Pacemaker.

Confidential

MySQL DBA contract

Confidential Networks has developed patent-pending machine-learning technology to index and rank real world places, based on movement data between these places at different times. The movement data, or location data, is collected in bulk and real-time from devices with GPS or WiFi positioning technology, such as mobile phones and automobiles. I had been monitoring, by my own, 6 MySQL DB servers at the back end of this machine-learning-based technology.

Responsibilities

• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and dev environments on both Linux Suse 10.1, Red Hat CentOS 5.2 and Mac OS X including installation, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Hands-on experience with database architecture design From ERD to physical model . Good understanding of the tradeoff of using Normalization/Denormalization depending upon client requirements.
• Normalizing database schemas satisfying the requirements of 1NF, 2NF and 3NF
• Providing assistance/recommendations to developers and Scientists from MIT and Columbia University
• DB proactive maintenance, improving access of big tables over 140,000,000 records each, repairing tables from crash and system failure. Shrinking table with lots of holes
• Performance Tuning on a daily basis for preventing issues and providing capacity planning
• Query optimization using a threshold along with the slow query log file
• Ability to work at MySQL binary logs level
• Implementing from scratch and monitoring MySQL Multi-Master/Multi-Slave circular replication scheme, fail-over/High availability using a virtual IP address, Perl, Heartbeat and Mon services.
• Shell scripts for taking daily incremental backups, InnoDB Hot backup and for diagnosing MySQL Health
• Writing Shell scripts and stored procedures for monitoring updates delay across databases and processing ETL across data repository for reporting purpose
• Ability to prepare documentations for non-technical colleagues and assist them in their daily tasks
• PL/SQL, stored procedures, triggers for lowering traffic between servers clients
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server
• Proficiency in Unix/Linux shell commands. Creation/deletion users, groups and set up restrictive permissions, configuration of the sudo files etc.
• Hands-on experience with installing/monitoring PostgreSQL 8.3.3 on Linux
• Ability to configure the RSYNC protocol for spreading backup files on multiple other servers
• Configuring/Installing/Troubleshooting Apache/Tomcat and PHP
• Ability to quickly Troubleshoot MySQL /OS problems and fix issues
• Ability to work on multiple projects without supervision

Environment : MySQL, Linux Suse 10.1, CentOS 5.2, Windows XP, Mac OS X , Mon, Heartbeat, Toad for

MySQL, Spotlight, Navicat, pgAdmin III, Perl , PHP, TCP/IP, Putty, Yast

Confidential

MySQL DBA contract

Confidential is a telecommunication company delivering local, long distance and calling card services to millions people all over the world. A few years ago IDT acquired the web site Zedge.net, fast-growing/high traffic social network around mobile content that allows creating ring tones, wallpapers, screensavers, themes, messages and mobile videos. My work was basically focused on monitoring multiple MySQL DB servers at the back end of this related website.

Responsibilities

• Managing MySQL 5.0.22 in production/QA/dev environment on both Linux and Windows including installation, new databases design, configuration, backup, recovery, upgrades and schema changes, etc
• Participating to Zedge.net website architecture and migration to a new platform more powerful
• Deploying shell scripts for taking MyISAM backup, InnoDB Hot backup and for diagnosing MySQL Health
• Excellent experience with query optimization at Back end database level
• Monitoring/Repairing MyISAM, Memory and InnoDB tables. Good understanding of the tradeoff of using those table engines based on client applications requirements.
• Setting/Troubleshooting MySQL Multi-Master/Multi-Slave replication and fail-over schemes
• Hands-on experience with relational database architecture. Normalization/Denormalization
• Tuning and troubleshooting at parameter level for preventing issues and providing capacity planning
• Ability to work at MySQL binary logs level
• Disaster recovery planning and MySQL security management
• Aptitude for documentation, reporting, innovation and process improvement
• Providing assistance and recommendations to developers on a daily basis
• Deploying PL/SQL stored procedures for ensuring better database security and for avoiding poor performance with data load between server and clients
• Diagnosis MySQL servers problems and fix issues

Environment : MySQL, PHP, Linux Red Hat, Windows XP, Mon, Heartbeat, Toad for MySQL, MySQL

Administrator, Spotlight, TCP/IP, Putty, Yast, PHP

Confidential

MySQL DBA contract

Confidential is leading the way in providing real choice in international air travel and travel related services. Its extensive background is focused on travel industry. Database-wise, it has multiple instances running with MySQL with a size near 300GB.

Responsibilities

• MySQL database environment versions 4.0.24, 5.0.22
• MySQL database administration on a large scale MySQL installation
• Strong Experience with MySQL on both Linux and Windows
• Excellent practice of db architecture design, both physical and logical. Normalization/Denormalization
• MySQL database backup and recovery strategies and Replication and synchronization
• MySQL processes, security management and queries optimization
• Implement Stored procedures processing ETL for reporting purposes
• Managing MyISAM, Memory and InnoDB tables
• Setting/Troubleshooting MySQL Multi-Master/Multi-Slave replication scheme. Fault-tolerant process and load balancing using heartbeat and Mon
• Ability to tune and troubleshoot at parameter level for preventing issues and providing capacity planning
• Ability to work at MySQL binary logs level
• Disaster recovery planning and query optimization
• Assistance and advices to developers on a daily basis. Strong analytical abilities
• Strong background on stored procedures and Shell scripting
• Ability to work on multiple projects with minimal management supervision
• Ability to quickly diagnose MySQL servers/OS/hardware problems and fix issues
• Managing MySQL in production/QA/dev environment including installation, configuration, backup, recovery, upgrades and schema changes, etc.

Environment: MySQL, Java, Linux Red Hat, Windows XP/Vista, Opencms, JavaScript, Mon, Heartbeat,

Toad for MySQL, Spotlight

Confidential

Oracle DBA/MySQL DBA contract

Confidential based Company, provides Software Development, Software Outsourcing, Database Administration, Website Design and Web Application Development Services to Clients Globally. Some of its focus industries include financial services, e-commerce, healthcare, and Media.

Responsibilities

• Performed troubleshooting of the various company Oracle database servers 9i, 10g
• Relational database architecture design physical and logical . Normalization/Denormalization
• Designed and created schema objects using OEM of Oracle 10g
• Strong MySQL databases, administration and Performance Tuning experience
• Helped out MySQL developers on a daily basis
• Troubleshooting MySQL DB issues both in test and production environments
• Deploying shell scripts for taking MyISAM backup, InnoDB Hot backup and for diagnosing MySQL Health
• Managing MySQL in production/QA/dev environment including installation, configuration, backup, recovery, upgrades and schema changes, etc.
• Managing MyISAM, Memory and InnoDB tables
• Setup the MySQL Multi-Master/Slave replication. High-availability architecture
• Maintained system security across MySQL servers and monitoring access from outside
• Ability to tune DB parameters for preventing performance issues and providing capacity planning
• Monitored Database activities using Oracle Enterprise Manager
• Created different databases as per the requirements for Development and Testing
• Performed MySQL/Oracle tuning and troubleshooting db/OS issues and fixed them
• Experience with capacity planning and query optimization
• PL/SQL programming on a daily basis
• Performed day-to-day server administration and ensure integrity, security and availability of the databases and applications.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, passwords
• Analyze system problems including any needed recovery process to ensure a quick restoration of service without loss of data

Environment: Oracle 10g, Oracle 9i, MySQL, Java, Sun-Solaris, OEM, Windows NT, SQL Plus and iSQL Plus, Javascript

Confidential

Oracle DBA/MySQL DBA

Responsibilities

• Installation/Upgrade/Monitor MySQL and Oracle database 10g, Control Grid on UNIX and WINDOWS
• Advanced practice of relational database architecture design, both physical and logical
• Great experience with database Normalization/Denormalization
• Created primary database storage structures, i.e. tablespaces, database objects, users and roles
• Implemented procedures for MySQL Multi-Master/slave replication and fault-tolerant using a virtual IP address, Perl, Heartbeat and Mon services. .
• MySQL database backup, InnoDB Hot Backup. Automate scripts for disaster recovery planning
• MySQL processes and queries optimization in both test and production environments
• Exported and Imported database 10g objects from development to production.
• Controlled user privileges and roles such as granting and revoking privileges and roles, allocation of resource limits and table space quota for users
• DB proactive maintenance, monitoring/improving access of big tables, repairing tables from crash and system failure. Shrinking InnoDB/MyISAM tables with lots of holes.
• Hands-on experience with UNIX scripts, PL/SQL programming, forms, reports, triggers
• Ability to tune and troubleshoot MySQL at parameter level for preventing issues and providing capacity planning in production environment
• Tuning of Oracle scripts and procedures using different methods including Explain Plan and TKPROF.
• Excellent experience with working at binary logs level.
• Providing daily assistance and MySQL recommendations to developers.
• Troubleshooting database/OS issues and proposed solutions.

Environment: Oracle 9i, MySQL, Oracle 10g, Sun-Solaris, Windows NT, SQL Loader

Confidential

Oracle DBA/MySQL DBA

Responsibilities

• Installation/Monitoring of MySQL and oracle 9i on UNIX platform in both in test production environments
• Management and estimation of database size and table space.
• MySQL database administration, Architecture physical design, backup and recovery
• Ability to tune DB parameters for preventing performance issues and providing capacity planning
• Maintenance and monitoring of multiple database parameters for all production and test databases.
• SQL and Database tuning. Explain plan, tkprof, statspack, auto trace.

Environment: Oracle 9i, Unix AIX, Solaris, Windows XP/NT, Toad, Tomcat, Apache