SUMMARY

• 7+ years experience in Database Administration, maintenance and production support of relational databases, business applications, new server setup, Data modelling, Installation, Configuration, upgrading and troubleshooting MySQL databases.
• Expertise in Database optimization and developing MySQL Database Objects like Schemas, Tables, Views, Stored Procedures, Indexes (cluster/Non - cluster),Constraints, Triggers, Buffer Pools, User Roles and functions.
• Involved extensively in Data modelling, Installation, and Configuration, upgrading and troubleshooting MySQL databases.
• Strong MySQL and SQL Server skills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient writing shell scripts, Perl script for Linux/Unix as well as noledge in general systems administration tasks.
• Successfully managed High Availability and Scalability for MySQL using Distributed Replicated Block Device (DRBD) and Linux HA Heartbeat of production systems for Corporate Sectors and Individual Organizations as MySQL DBA.
• Expertise in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Expertise in snapshot, import/export, DB optimization wif the halp of explain plan
• Expertise in database migration from MYISAM storage to INNODB storage engine to increase performance and betterment of integrity constraints.
• Expertise in handling MySQL Security, establishing MySQL Replication and MySQL Clustering between two or more MySQL Database servers.
• Experienced in Capacity planning, Backup, Restore, and log Shipping, Corruption and Recovery.
• Involved in client Production Support and Maintenance - Tasks including programming, debugging and testing of existing applications that run in a production environment for purposes of remediation system errors or to extend application life span.
• Pro-Actively identify risks and problems involved wif existing/new database design and come up wif Optimal Solution and communicate it across the Team.
• Involved in designing, developing, testing and rolling out of complex enterprise applications to completion in terms of Database as well as frontend, wif different project development model like Waterfall, Agile, and SCRUM.
• MySQL Error handling, Log maintenance and troubleshooting.
• Installation and Maintaining MySQL 5.6/5.5/5.1 enterprise and community versions.

TECHNICAL SKILLS

Operating Systems: RedHat Linux, UNIX, Solaris 2.4, Windows XP.

Languages: SQL, Core Java, C, Shell scripting.

Database: MySQL 5.6/5.5/5.1.

Tools: MySQL Workbench, MySQL Toad, MySQL Migration Toolkit, MySQL GUI MySQL Query Browser and MySQL Administrator, MySQL Percona

PROFESSIONAL EXPERIENCE

Confidential, Dover

SQL Developer

Responsibilities:

• Migration of legacy data from MySQL 5.1 Windows Servers to MySQL 5.6 Linux Servers.
• Migrated around 100+ instances to MySQL 5.6
• Implemented Multi-threaded replication to improve replication performance. Also enabled semi-synchronous plugin
• Improved Write workload by changing the IO scheduler to deadline
• Removed duplicate indexes using pt-duplicate-key-checker
• Used optimizer hints like USE INDEX,FORCE INDEX and IGNORE INDEX to improve performance
• Maintaining databases and tuning database parameters and queries for effective performance.
• Installation of PERCONA XTRABACKUP Open source backup solution for effectively backing up MySQL databases on Linux.
• Configuration and Setup of various MySQL performance monitoring tools like Nagios, myTop and PERCONA TOOLKIT.
• Continuous monitoring of MySQL servers.
• Handling deployment activities for upgrading and executing patches and releases.
• Automating various database specific routine tasks through procedures/events and bash scripts.
• Scheduling full and incremental database backups, transferring them to file servers and restoring the same.
• Designing of database and data flow in the system, creation of various objects like procedures, functions, views and sequences.
• Migrating databases or schema movement as per the requirements.
• Accomplished Installation and Setup of database wif MySQL 7.2 Cluster for achieving write-scalability insharded and multi-master architecture thus by massively improving the speed of large, complex JOIN operations that span multiple partitions (shards).
• Maintaining and monitoring MySQL Cluster environment in which tables are sharded across sites on multiple server wif synchronous replication between them.
• Installation of third party storage engines like DeepDB and TokuDB to achieve high performance.
• Performance tuning of application queries for better performance and analyzing datatypes and changing them as per required.
• Profiling MySQL queries and using pt-query-digest to monitor and analyze slow and general query log for slow queries.
• Sharding & Partitioning large tables to improve performance, manageability, simplification of maintenance and reducing the cost of storing large data.
• Setup of tungsten replicator for Master-Master Replication Setup.
• Accomplished setup of MySQL Fabric to maintain farms of MySQL servers for high availability and sharding to scale out reads and writes by partitioning rows into multiple shards.

Environment: MySQL 5.6/5.5/5.1,Percona Xtrabackup, Nagios Monitoring, Percona toolkit, MySQL 7.2 CGE, Red Hat Linux, Windows 2003 Server, Tungsten Replicator, MySQL Fabric.

Confidential, Austin

Responsibilities:

• Administration and management of the entire development, QA and production environment.
• Installed and configured MySQL on Linux and Windows environments.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL configuration changes, multiple instances and by upgrading hardware.
• Assisted wif sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Ensured production data being replicated into data warehouse wifout any data anomalies from the processing databases.
• Worked wif the engineering team to implement new design systems of databases used by the company.
• Effectively configured MySQL Replication as part of HA solution.
• Designed databases for referential integrity and involved in logical design plan.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Developed stored procedures, triggers in MySQL 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 bash commands.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc.
• Created data extracts as part of data analysis and exchanged wif internal staff.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Documented all servers and databases.
• Database engineering is based on SDLC pattern. Involved all the steps like requirement analysis, Design, Development and Testing and then deployment.
• ER Studio for database architecture design.
• Bash script is being used for some data migration and backend work management.
• Supporting management wif different database related decisions.
• Handling Release management and user acceptance.

Environment: MySQL 5.1.6, Shell Script, LINUX.

Confidential 

Responsibilities:

• Designing of database and data flow in the system, creation of various objects like procedures, functions, views and sequences.
• Creation of triggers for audit log of database.
• Installation and setup of MySQL 5.1 Enterprise and Community servers on Windows/Linux and SUN Solaris Servers.
• Installation and Configuration of MySQL database servers on Sun Solaris systems
• Configuring Active-Passive Cluster setup on SUN Solaris Servers.
• Configuration of Primary and Disaster Recovery sites for Application and Database servers.
• Configuring parameters for database tuning.
• Scheduling snapshot incremental and full backups of MySQL database using third party tools like VERITAS Net Backup and Zmanda.
• Scheduling hot and cold backups using MySQL dump.
• Database optimization by tuning queries for various modules in the project for better performance.
• Setting up Master-Slave replication between MySQL Servers for high availability of data.
• Continuous 24*7 monitoring of MySQL servers having about 2 TB data using MySQL Performance monitor and various OS specific commands and scripts.
• Creating Procedures and Functions for Reporting and ETL Purpose.
• Implementing Event objects through Database for extract, loading and transfer data Reports.
• Administering Users, Roles and Privileges.
• Scheduling backup through batch file.
• Upgrading from My SQL 5.0 to My SQL 5.1.
• Tuning database by partitioning tables.
• Implementing MySQL database replication.
• Migration of legacy Oracle database to MySQL database.
• Working wif various MySQL tools like MySQL Workbench, MySQL Administrator, MySQL GUI Tools, SQL Yog, MySQL Performance Monitor, MySQL Migration Toolkit, SQL Developer and Toad.
• Leading Database team and Coordinating wif various module teams towards smooth completion of the project.
• Facilitated requirements collection, documenting database through Entity- Relationship diagrams.