SUMMARY

• Database Administrator with 7 years of core IT experience in database Installation, Designing, Administration and Troubleshooting database servers MySQL 5.6,5.5, 5.1, on nix, CentOS and Windows platforms, Aurora.
• Worked on MySQL Database with expertise in online transaction processing (OLTP) and online analytical processing (OLAP) on multi - user systems involving large databases for clients.
• Experience in migration of MySQL databases to the different cloud environment like AWS Aurora and Rackspace cloud (Opensstack)
• Experience in working with huge databases, VLDB, troubleshooting issues and documenting the causes. Provided support for mission critical production database systems powered by MySQL.
• Experience in database administration, development, design, maintenance and production support of relational databases, business applications, new server setup, MySQL server installation, upgrade, migration.
• Proficient in implementing different types of Replication models.
• Have successfully managed high availability of production systems for corporate sectors and Individual Organizations as MySQL DBA.
• Created MySQL Database Objects like Schemas, Tables, Views, Stored Procedures, Indexes (cluster/Noncluster), and Constraints, Triggers, Buffer Pools, User Roles and functions.
• Expertise in Shell Script.
• Experience in the administration of Web based Internet/Intranet Client/Server multi-tire distributed application, major in database technologies, Sales &Finance, Telecom, Quality &Standards domains.
• MySQL Error handling, Log maintenance and troubleshooting.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Experience with MySQL client programs (MySQL Admin, MySQL check, Mysqldump, MySQL import, MySQL show).
• Experienced in handling MySQL Security MySQL Database servers.
• Expertise in snapshot, import/export, Query optimization with help of Explain plan.
• Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning, refreshing test and development databases, Monitoring, Troubleshooting & Tuning.
• Experience in analyzing database & rebuild indexes to improve database performance.
• Involved in Client Production Support and Maintenance-Tasks including programming, debugging and testing of existing application that run in a production environment for purposes of remediation system errors or to extend application life span.
• Good analytical, problem- solving skills, verbal and written communication skills.

TECHNICAL SKILLS

Languages: C, PL/SQL,JSON, Power shell and UNIX shell

RDBMS: MySQL 5.1/5.5/5.6, MariaDB 5.5/10.MSSQL, Aurora MySQL

BI Tools: Qlik View 8.01, SSAS, Pentaho 1.6 GA (Kettle, Cube designer)

Tools: Dbforge, Toad for MySQL, MySQL Administrator, SQLways, SQLYog, Monyog MS- VISIO, Shell Scripting, Perl scripting, Percona toolkit, MySQL Utilities, New Relic, Github

Monitoring Tools: Nagios, openNMS, Box Anemomaster, Oracle Enterprise Manager, MySQL Enterprise Manager, solar winds, NewRelic

Operating Systems: Windows NT/XP/7/8, Windows 2000, Windows 2003, Windows 2008/R2, Ubuntu, Centos, RHEL 4,5,6 MAC OS X, AWS Aurora.

PROFESSIONAL EXPERIENCE

Confidential

MySQL DBA

Responsibilities:

• Responsible for requirement analysis Database architecture and Implementation, Data Modeling, Database Designing, Tuning Databases, Procedures, Functions, Triggers and Events.
• Responsible for Migration of MySQL datbases from on prem server to AWS Cloud Aurora.
• Responsible for Working on Migrating on current producton Rackspace Cloud Database servers to new Rackspace cloud as our current servers are getting old on hardware level .
• Responsible to setup the HA solution MHA between one master and one slave with the VIP’s.
• Worked on the Sysbench tool to check the server performnace before migration to the new servers in Rackspace.
• Worked to setup Database alerts and threashholds with the Solar winds and NewRelic for the differtent projects in our environmets.
• Worked on Percona Xtrabackup, Mydumper and Mysqldump MEB(MySQL Enterpris backup) to setup daily full backups and incremental backups and sync to the s3 bucket in AWS.
• Responsible for SQL Tuning using EXPLAIN, tuning Database Configuration parameters for optimal database performance.
• Assisted with sizing, query optimization, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Resolved concurrency and performance issues by configuring thread pooling at MySQL level.
• Maintaining and troubleshooting health parameters of the database such as Deadlocks, concurrent inserts, external locking, Buffer Pool, query cache, database/application heaps.
• In addition, this role is responsible for building and maintaining strong relationships with the appropriate Business Operations and IT Leadership Teams and their direct reports and serves as the main escalation point for issues which cannot be resolved by the members operating within the Database Engineering and Administration team.
• Participate in vendor management initiatives with a primary focus on continuous improvement of high availability solutions in environment.
• Managing Storage engines: INNODB, MYISAM, Percona XtraDB, MySQL Federated, MySQL Archive.
• Wokred to Perform threshold forecasting, sizing, capacity planning and trend analysis.
• Worked on MSSQL Backups and S3 sync of backups on daily basis.
• Documented each and every task and run books for the opscenter to run them in cases of any alerts in our Environment.
• Responsible for different High availability technologies like Master-Master, Master-Slave replication and Participate in vendor management initiatives with a primary focus on continuous improvement of high availability solutions in environment.
• Handling Release management and user acceptance and supported 24X7 on call.

Confidential, Austin, TX

MySQL DBA

Responsibilities:

• Administration and management of the entire development, QA and production environment.
• Resolve issues related to slow performance caused by blocking, deadlocks, long running queries. And Troubleshooting the Deadlocks on the server with the help of application team.
• Installed and configured MySQL on CentOS 6.4 environments through YUM and RPM packages.
• Troubleshooting the Deadlocks on the server with the help of application team.
• Work on Log maintenance (error logs, query log, binary log, slow query log and relay log).
• Capturing and rebounding General Logs on the Problematic queries or sessions.
• Working closely with OS and Virtualization teams on the OS level Issues.
• Tables optimization, Index optimization, Query optimization.
• Troubleshooting MySQL servers for problems. Proactively and routinely looking into the file system for space issues.
• Increased database performance by utilizing MySQL configuration changes, upgrading hardware.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Participate in on-call rotation to support SQL Server production issues.
• Running MySQL check commands to check/resolve database consistency and troubleshooting errors.
• Managing over 150 MySQL databases in various environments-Prod, staging, Dev, on boarding, test, etc.
• Successfully restored about 1.5TB missing data.
• Upgraded MySQL Server 4.1.22 to Percona 5.1.73
• Moved roles with the help of DB knob(in-built tool) and maintain within the SLA
• Adhering to PCI compliance and making data PCI compliant.
• Perform test on changes before deployment to the production environments.

Environment: Percona 5.6, MySQL 5.7, CentOS 5, 6.4-6.9, MySQL Aurora, Jira, Shell Scripting, SED. New Relic, Solar Winds, Fresh service ticketing system.

Confidential, Glen Mills, PA

MySQL DBA

Responsibilities:

• Administration and management of the entire development, QA and production environment.
• Installed and configured MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL 5.1.69 and 5.6.24 in production and developer environments on both Linux (5.0, 5.1) and Mac OS X.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Assisted with 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 without any data anomalies from the processing databases.
• 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 shell commands.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc.
• Configuring/Installing/Troubleshooting Apache and PHP.
• Created data extracts as part of data analysis and exchanged with internal staff.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Handling Release management and user acceptance and supported 24X7 on call
• Documented all servers and databases.
• Data replication / data migration development - with all major ETL software applications
• Database engineering is based on SDLC pattern. Involved all the steps like requirement analysis, Design, Development and Testing and then deployment.
• Shell script is being used for some data migration and backend work management.
• Supporting management with different database related decisions.
• Handling Release management and user acceptance.
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Backup and restore mongo databases using LVM snapshots and Ops manager backups.
• Administering replica set health using Mongo OPS Manager to maintain data using high availability and automatic failover.

Environment: MySQL5.1,5.6 PHP, Shell Script, Apache, LINUX 5.0, 5.1, OSX,Nagios, AWK, SED, Galera Cluster, PL/SQL, MySQL workbench Utility, Percona Xtrabackup, Proxysql load balancer.

Confidential, Boston, MA

MySQLDBA

Responsibilities:

• MySQL administration on production environment; installation, tuning, backups, resources optimization and distribution, InnoDB and MyISAM storage engines, replication in large-scale environments.
• Installed and configured MySQL on CentOS 6.4 environments through YUM and RPM packages.
• Created Database Objects like Schemas, Tables, Views, Stored Procedures, Indexes (cluster/Non-cluster), and Triggers, Buffer Pools, User Roles, User Defined Types (UDT) and functions.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Perform backup and recovery for MySQL databases using Percona Xtrabackup.
• Experience with MySQL GUI tools MySQL Workbench, MySQL Administrator, MySQL Query Browser and MySQL Migration Toolkit.
• Cleaned and rotated/automated the error logs and slow query logs - MySQL log maintenance
• Incorporated check MySQL health plugin into existing Nagios monitoring tool
• Created and refined stored procedures, routines and triggers.
• Implemented Column Level Encryption and Decryption on some highly secure financial tables.
• Developing technical strategy of all Database OLTP, Data Warehouse OLAP initiatives for the business clients.
• Experience with MySQL utility programs: MySQLbinlog, MySQLhotcopy, MySQLaccess, MySQLdumpslow, MySQL manager etc.
• Designing and maintaining Database standards and best practices. Physical database design for all database initiatives
• OLTP / OLAP, Data Warehouse programming code development.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Database performance problems analysis, diagnoses and optimum performance resolution employing preventive measures to maintain high applications availability, performance monitoring, identifying and resolving database performance bottlenecks, SQL tuning, Explain SQL query, Indexing, MySQL and Linux OS level optimization
• Restored MySQL Replication setup and administration on Master-Slave and Master-Master.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc.
• Analyzed code to improve query optimization and to verify that tables are using indexes.
• Responsibilities also, included removing row chaining for better performance deciding the naming conventions of data file, redo log file, tablespaces and segments.

Environment: MySQL5.6,5.5, Percona Xtrabackup, Proxysql load balancer, Web Services, Shell Script, Apache, perl script LINUX.

Confidential, TX

MySQL DBA

Responsibilities:

• Responsible for MySQL DB architecture, installation, configuration setup, DB systems administration, provisioning, troubleshooting database performance problems. Linux OS, server and data storage systems configuration, capacity planning, utilizing scaling methodologies
• Experience with the Meta data tables in INFORMATION SCHEMA.
• Extensive experience with various backup and recovery methods - Mysqldump, enterprise backup, percona xtrabackup.
• Performs daily database backup of development and test environments, use production data to refresh development and test schemas for testing
• Data loading and exports using LOAD INFILE,MYSQL limport.
• Used MYSQL binlog utility to identify and rectify the corruption in relay logs
• Experience with RPM installs as well as binary installs
• Recovered multiple MyISAM tables after corruption using Check and Repair
• Worked on auto recovery for Innodb and MyISAM tables
• Used MySQL workbench, query browser utilities
• Enabled slow query log for query analysis and used the write to table option
• Wrote shell scripts to monitor replication, take backups and other routine DBA tasks
• Set up Innodb file per table option and other innodb standard parameters to standardize tablespaces
• Worked on adding foreign key constraints as per the application requirements.
• Database operation, maintenance, security, provisioning, administration, replication, automation, disc I/O / space management.
• MySQL best practice engine, demon variable configuration and optimization
• Managing Storage engines: InnoDB, MyISAM, Falcon, Percona, XtraDB, MYSQL Federated, MYSQL Archive, Aria
• Developed solution for complex joins, creating dynamic SQL scripts to support system analysis, and troubleshooting of legacy bugs / issues.
• Data conversion from any data source to MySQL database - custom code development configuration and implementation
• Developing ad-hoc and custom reports for business analysis.

Environment: MySQL 5.6/5.5/5.1,Percona Xtrabackup, Nagios Monitoring, Percona toolkit, MySQL 7.2 CGE, DeepDB, TokuDB, Red Hat Linux, Windows 2003 Server, Tungsten Replicator, MySQL Fabric, MMS,Python,Perl,Shell Scripting.

Confidential

MySQL Database Administrator

Responsibilities:

• 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
• 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.
• Configuration of Primary and Disaster Recovery sites for Application and Database servers.
• Configuring parameters for database tuning.
• 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.
• 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.
• Tuning database by partitioning tables.
• Implementing MySQL database replication.
• Migration of legacy Oracle database to MySQL database.
• Working with various MySQL Administrator, MySQL GUI Tools, SQL Yog, MySQL Performance Monitor, MySQL Migraton Toolkit, Oracle PL/SQL Developer, SQL Developer and Toad.
• Leading Database team and Coordinating with various module teams towards smooth completion of the project.
• Migrating legacy data to PostgreSQL databases and maintaining them.

Environment: MySQL 5.1.6, PHP MyAdmin, PHP 4.x, 5.x, Web Services, Shell Script, Apache, LINUX.

Confidential

MYSQL Database Administrator

Responsibilities:

• Master-Slave and Master-Master. Leading Database team and Coordinating with various module teams towards smooth completion of the project.
• 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.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Worked with the engineering team to implement new design systems of databases used by the company.
• 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 Percona Toolkit(pt-query-digest).
• Proficiency in Unix/Linux shell commands.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc.
• Performed MySQL Replication setup and administration on.

Environment: MySQL 5.0,5.1, Galera Cluster, Percona Xtrabackup, Proxysql load balancer, Web Services, Shell Script, Apache, perl script LINUX.