PROFESSIONAL SUMMARY:

• 7 years of experience in the IT industry renders me as a very well rounded RDBMS specialist excelling both as a Development, QA and Production DBA like MySQL 5.7, 5.6, MySQL 5.5 MySQL 5.1, MS SQL 2012, on Windows, Linux, Solaris, UNIX and CentOS platforms.
• Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySQL Server installation, upgrade, migration
• Comprehensive knowledge in Database architecture and Implementation, Data Modeling, Database Designing, Tuning Databases and Queries, Procedures, Functions, Triggers and Event.
• Have successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as MySQL DBA.
• 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 as well as knowledge in general systems administration tasks.
• Expertise with Shell Script, PHP backend, C# application integrations & development.
• Experience in the administration of Web based Internet/Intranet Client/Server multi - tire distributed application, major in database technologies in Consulting, Sales & Finance, Telecom, Quality & Standards domains.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL, NoSQL.
• Experienced in designing, modeling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints.
• Strong experience in Data modeling and their different tools like Oracle Designer, Power Designer, Erwin, MS Visio and DDT.
• Involved in designing, developing, testing and rolling out of complex enterprise applications to completion in terms of Database as well as frontend. With different project development model like SDLC, Agile, SCRUM etc.
• Expert of writing shell scripting, Perl script for Linux/Unix.
• Orchestrated full Software Development Life Cycle (SDLC) starting from collecting Business specifications, Analysis, Design and Development, Testing and documenting the entire life cycle using various methodologies like Agile, SCRUM, Waterfall, Domain Driven Design and Test Driven Development.

TECHNICAL SKILLS:

Databases: MySQL 5.7/ 5.6/5.5/5.1 , MySQL Cluster 7.2 CGE, Mongo dB 3.2, 3.0, NoSQL

Database Tools: MySQL Workbench, MySQL Toad, MySQL Migration Toolkit, MySQL GUI Tools- MySQL Query Browser and MySQL Administrator, Jasper ETL, Pentaho data integrator for ETL Purpose, ManYog, Percona Xtrabackup, Percona toolkit, MySQL Enterprise Monitor, Microsoft Visual studio.NET, Tungsten Replicator, MySQL Fabric, Microsoft Visual studio.NET

ETL Tools: Pentaho, SAP BI

Languages: Shell Scripting, PHP

Environment: Red Hat Linux, Sun Solaris, HP UNIX, Mac, Windows Server, Fedora

PROFESSIONAL EXPERIENCE:

Confidential, Salt lake city, UT

MySQL Database Administrator

Environment: Windows, Linux, MySQL Enterprise monitor, Agile, TCP/IP, PHP.

Responsibilities:

• Administration and management of the entire development, QA and production environment.
• Experience with the Meta data tables in INFORMATION SCHEMA.
• Installed and configured MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL 5.7, 5.6 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, 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.
• Effectively configured MySQL Replication.
• 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 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.

Confidential, Hartford, CT

MySQL DBA

Environment: MySQL, RDBMS, Innodb, MyISAM, MongoDB, MMS, Performance Monitoring.

Responsibilities:

• MySQL administration on production environment; installation, tuning, backups, resources optimization and distribution, Innodb and MyISAM storage engines, replication in large-scale environments.
• Performance monitoring and tuning; analyzing database metrics and assisting with capacity planning
• Configuration and execution of installations, upgrades and migrations, and implementing security controls
• Installation of MySQL server and client software applications in a large environment
• Perform backup and recovery for MySQL databases using Percona Xtrabackup.
• Responsible for database management and monitoring (alert log, memory, disk I/O, CPU, database network connectivity)
• MySQL query optimization and performance problem solving
• Creating user accounts and appropriate privileges as well as maintaining database security.
• Ensure daily export backups are completed and valid for restore and recovery.
• Monitoring and analyzing RDBMS for performance, and administering performance tuning.
• Setup and Monitor MySQL database replication in Multi master and slave environment and providing HA solutions.
• Database management for scheduling, tuning, taking backups using on premise MMS monitoring and backup solution.
• Point in time Backup and recovery in MongoDB using MMS. Worked on MongoDB database design and indexing techniques.

Confidential, Austin, TX

MySQL DBA

Environment: Linux, Windows, MySQL server, TCP/IP, Agile, Performance Tuning.

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 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.
• Worked with 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 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.
• 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 with 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.
• Supporting management with different database related decisions. Handling Release management and user acceptance.

Confidential, Long Island, NY

MySQL DBA

Environment: MySQL Server, PHP, MySQL Migration Toolkit, ETL, MySQL 5.1, RFC.

Responsibilities:

• Provision MySQL instances, both in clustered and non-clustered configurations.
• Ensure performance, security, and availability of databases.
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Created database application using PHP and MySQL as the database to monitor customer profiles and complaints.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• MySQL processes, security management and queries optimization.
• Recovering the databases from backup in disasters.
• MySQL processes and queries optimization. Exported and Imported database 10g objects from development to production.
• Migrated Oracle 9i databases to MySQL using the MySQL Migration Toolkit.
• Performed query analysis for slow and problematic queries.
• Analyzed code to improve query optimization and to verify that tables are using indexes.
• Performed PHP/MySQL coding on Web applications that are driven by MySQL database.
• Contribution in designing database, creating database schema, creation using RDBM, data migration.
• Involved in migration and re-engineering of MySQL database from 4.1 to MySQL 5.1.
• Migration and re-engineering is based on SDLC pattern. Involved all the steps like requirement analysis, TS Design, Test Plan, Development and Testing and then deployment
• Implemented procedures processing ETL for reporting and ETL tool for data migration.
• Setup PHP MyAdmin online.
• Shell script is being to maintain the gateway and its scheduler part.
• Development on stored procedures, triggers, cursors, views, joins etc. Developing application using algorithm techniques.
• Design and develop different RFC raised for different releases for the project.
• Writing test cases for RFC. Time line estimation for RFC verification of DA activity etc.

Confidential, Wallingford, CT

MySQL DBA

Environment: Linux, Windows, Mac OS X, TCP/IP, Agile, MySQL 5.5 and 5.6.

Responsibilities:

• Administrator and manage the entire development, QA and production environment.
• Install and configure MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL 5.5 and 5.6 in production and developer environments on both Linux and Mac OS X.
• Increase database performance by utilizing MySQL configuration changes, clustering and by upgrading hardware.
• Assist with sizing, query optimization, backup and recovery, installations, upgrades and security including other administration functions.
• Work with the engineering team to implement new design systems of databases used by the company.
• Effectively configure MySQL Replication.
• Perform MySQL Replication setup and administration on Master-Slave and Master-Master.
• Document all servers and databases.
• Support management with different database related decisions. Handle release management and user acceptance.
• Install and configured MySQL on Linux and Windows environments.
• Troubleshooting MySQL 5.1- 5.6 in production and development environments
• Perform installation from binaries and rpm to company’s customization needs.
• Manage query optimization, backup and recovery, installations, upgrades and security.
• Work with the engineering team to implement new design systems of databases used by the company.
• Effectively configured MySQL Replication as part of HA solution.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning.
• Generate procedures, triggers in MySQL for lowering traffic between servers & clients.
• Manage database clustering.
• Perform query and schema analysis for efficient SQL processing.
• Work in 24/7 production support.

Confidential

MySQL DBA

Environment: MySQL 5.1/5.5/5.6, RPM, Agile, Percona Toolkit, TCP/IP.

Responsibilities:

• Maintained, monitored, tuned, and support existing MySQL 5.1/5.5/5.6 database environments for production, staging, QA and development.
• Automate various DBA tasks using shell scripts.
• Installed and configured MySQL databases using binaries, source and RPM.
• Optimization of database performance.
• Served as an escalation point for any defined database issues regarding performance, security, and ongoing maintenance.
• Worked with the OS and development team to optimize queries and performance functionalities.
• Analyzed problems and incidents, identify root cause for critical incidents and identify, resolve or provide workarounds to address issues resulting from new MySQL installations and upgrades.
• Troubleshoot any problems that may come up with the database environments.
• Set up infrastructure using custom scripts, Percona Toolkit to monitor database availability, locking issues, slave latency, and performance.
• Assisted in formalizing and updating database policies, procedures, and technical standards.
• Performed application patches, upgrades, service packs and other maintenance.
• Managed database security, disaster recovery, and capacity planning.
• Performed ongoing OS performance tuning, hardware upgrades, and resource optimization as required.