Data Manager

Santhosh

Mobile : 724-***-****

Email : **********@*****.***

Professional Summary :

Database Administrator with 6 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.

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 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 (MySQLadmin, MySQLcheck, MySQLdump, MySQLimport, MySQLshow).

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, Oracle11G, MariaDB 5.5/10.

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

Operating Systems

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

Professional Experience:

Client: Axalta Coating Systems, Glen Mills, PA Feb’17 – Till Date

Role: 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.

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.

Client: Clean Harbors, Boston, MA Mar’16 – Jan’17

Role: 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 MySQLhealth 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 thebusiness 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.

Client: Selene Finance, TX Jan’15 – Dec’15

Role: 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, MYSQLFederated, MYSQLArchive, 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.

Client: BNP Paribas India solutions, India June 2013 –Dec 2014

Role: 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.

Client: CommSure knowledge Solutions, IndiaNov 2011 toMay 2013

Role: 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 configuredMySQLon 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.

PerformedMySQLReplication 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.

Contact this candidate