PROFESSIONAL SUMMARY:

• IT professional with total of 8+ years’ experience in Database design, Administration and development in Mongo DB, and MySQL., Data modeling, Installation, Configuration, upgrading and troubleshooting MySQL databases.
• Full life cycle experience in highly secure, extremely large - scale deployments of very high volumes of critical data with extensive security.
• Implemented MySQL Percona Cluster and Replication for High Availability and Scalability
• 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.
• Expertise in designing, modeling, developing, and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.
• Expertise in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Expertise in snapshot, import/export, DB optimization with the help of explain plan.
• 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 Waterfall, Agile, and SCRUM.
• Expertise in setup of Tungsten Replicator for Master-Master Replication Setup
• MySQL Error handling, Log maintenance and troubleshooting.
• Expertise in handling MySQL Security, e stablishing MySQL Replication and MySQL Clustering between two or more MySQL Database servers.
• Expertise in setting up and handling NDB cluster in a high volume OLTP environments
• Expertise in Capacity planning, Backup Restore and Recovery.
• 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.
• Performed CRUD operations like Update, Insert and Delete data in MongoDB
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Installation of MongoDB on physical machines, Virtual machines as well as AWS. Backup & Recovery, Database optimization and Security maintenance.
• Extensive experience in designing MongoDB multi-sharded cluster and monitoring with MMS.
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Good Team Player, Good analytical, verbal and written communication skills.
• Highly motivated with strong commitment to quality and customer service.
• Strong in solving problems of diverse scope where technical analysis and evaluation is required.

TECHNICAL SKILLS:

RDBMS: MySQL 5.0/5.1/5.5/5.6/5.7, MongoDB 2.4/2.6/3.0/3.2.

Database Tools: MySQL Workbench, MySQL Migration Toolkit, MySQL GUI Tools- MySQL Query Browser and MySQL Administrator, JasperETL, Nagios, Cacti, Percona Xtrabackup, Percona toolkit, Zmanda Backup, VERITAS Net Backup, MySQL Enterprise Monitor, SQL*Plus & Oracle SQL Developer, Oracle Enterprise Manager, PL/SQL Developer, Jasper ETL, Tungsten Replicator, MySQL Fabric, Mongo-Client, Mongo-Express, Edda, Fluentd.

Programming Languages: SQL, TSQL, XML, PL/SQL, C, HTML, Shell Scripting, Perl, Python

Web Tools: MS-Front Page, Internet Information Server (IIS), FTP, TCP/IP, LAN, MS-Outlook Express

Operating Systems: Windows 95/98/2000/2003/2008/ XP/NT 4.0, Red Hat Enterprise Linux, Ubuntu Server, CentOS, SUSE Enterprise Linux, Novell Netware, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. MySQL & MongoDB 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 methodology.
• Created MySQL Database Objects like Schemas, Tables, Views, Stored Procedures, Indexes (cluster/Non-cluster), Views, Constraints, Triggers, Buffer Pools, User Roles and functions.
• Responsible for administration, maintenance, Performance analysis, and Capacity planning for MongoDB 2.x,3,0.x and 3.2 versions.
• Proficient in designing MongoDB dynamic schemas and Data modelling concepts.
• Maintaining and troubleshooting health parameters of the database such as Deadlocks, Lock timeouts/ external locking, Buffer Pool, Query Cache, Utility and Table Heaps.
• Implemented MySQL Enterprise Monitor, MySQL Replication Monitor and MySQL Query Analyzer for improving query performance and capacity planning in MySQL OLAP databases.
• Manage run-time configuration, processes, scaling, backup and recovery, monitoring, and performance tuning for production MongoDB instances.
• Created replication and MongoDB Sharding clustering.
• Configuring multiple Master-Slave replications on Active - Passive on Solaris OS Cluster suite and HP Cluster suite for achieving high availability and DR solutions.
• Worked on MMS monitoring tool to support multiple versions of MongoDB.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Experience with RPM installs as well as binary installs
• Recovered multiple MyISAM tables after corruption using Check and Repair.
• Experience with MySQL GUI tools MySQL Workbench, MySQL Administrator, MySQL Query Browser and MySQL Migration Toolkit.
• Wrote shell scripts, Perl scripts and setting up CRON jobs to take backup, disk space monitoring, I/O contention, log growth and rate of database growth.
• Analyze MongoDB log, OpLog file, MongoStat, Server Status, and MMS/OPS manager, to determine and validate root cause analysis of outages and performance bottlenecks.
• Experience with MySQL cluster Partitioning and sharing feature for large Data warehouse project which includes log-shipping and database mirroring.
• Configured third party storage engines in MySQL installations like TokuDB and Deep DB for achieving high performance, scalability and operational efficiency depending on the applications demand.
• Worked as MySQL Database administrator with expertise in online transaction processing (OLTP) and online analytical processing (OLAP) on multi-user systems involving large databases for Financial, Media, Retail and Insurance clients.
• Involved extensively in Data modeling, Installation, Configuration, upgrading and troubleshooting MySQL databases.
• 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.
• Performed CRUD operations like Update, Insert and Delete data in MongoDB
• Turned the Flash Recovery Area on to backup oracle databases from any logical corruptions (table, index) that making the backup faster.
• Continuous 24*7 monitoring of MySQL servers having about 2 TB data using MySQL & MongoDB Performance monitor and various OS specific commands and scripts.
• Handling Release management and user acceptance and supported 24X7 on call.

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, MongoDB, MMS, Python, Perl, Shell Scripting.

Confidential, San Diego, CA

MySQL & MongoDB DBA

Responsibilities:

• Designing of database and data flow in the system, creation of various objects like procedures, functions, views and sequences.
• Installation and setup of MySQL 5.6 Enterprise and Community servers on Windows/Linux and SUN Solaris Servers.
• Extensive experience in deploying, managing and developing with MongoDB clusters.
• Implemented MySQL Enterprise Monitor, MySQL Replication Monitor and MySQL Query Analyzer for improving query performance and capacity planning in Data Warehouse databases.
• Performed SQL Tuning using EXPLAIN, tuning Database Configuration parameters for optimal database performance.
• Familiar with MongoDB clusters, performance tuning, backup and recovery.
• Built and maintained High transactional (OLTP) and multi-dimensional Data Warehouses (OLAP)
• 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.
• Implemented database backups - Logical/Physical, Online/Offline, Full/Incremental and Snapshot backups ( MySQL dump backup).
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Implementation of MongoDB security mechanism with various Authentications.
• Recovered database using crash, version and roll-forward recovery methods.
• Experience in setting-up of MySQL Replication (master-slave and master-master) .
• Experience in setting up and maintaining disaster recovery of MySQL databases with High Availability Clustering with Distributed Replicated Block Device (DRBD) with Linux Heartbeat.
• Used mysqld multi to manage multiple instances in production environment.
• Responsible for managing MongoDB environment with high availability, performance and scalability perspectives.
• Installing Percona XtraDB clusters in dev, test and QA environments.
• Configuration and Setup of various MySQL performance monitoring tools like Nagios and MySQL enterprise Monitor for monitoring MySQL Servers. Configuring Perl scripts for monitoring databases and internal health.
• Administered multiple environments, automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB.
• Evaluated the peak and no peak usage pattern of the application; effectively distributed database administration activities, such as full database backup and database defragmentation during no peak hours.
• Spreading huge tables to different file groups to achieve maximum performance.
• Researched new database technologies and methodologies. Enabled required data extract, transform, and load procedures and packages. Involved in creating customer invoice reports.
• Improving the operational management within the department to ensure top Quality service is provided in order to maintain a positive customer/client relationship.

Environment: MySQL Enterprise 5.6, SQL Server, Sybase NDB Cluster.

Confidential, Boston, MA

MySQL DBA

Responsibilities:

• Migration of legacy data from MySQL 5.1 Windows Servers to MySQL 5.6 Linux Servers.
• Responsible for MySQL (MS SQL) 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.
• Installation of PERCONA XTRABACKUP Open source backup solution for effectively backing up MySQL databases on Linux.
• Accomplished Installation and Setup of database with 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).
• Sharding & Partitioning large tables to improve performance, manageability, simplification of maintenance and reducing the cost of storing large data.
• 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. Data modeling for data from RDBMS to and MongoDB for optimal reads and writes.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• 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.
• 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.
• Developed solution for complex joins, creating dynamic SQL scripts to support system analysis, and troubleshooting of legacy bugs / issues.
• Technical resource to the Application development team on data configuration and referential integrity data storage.
• Technical knowledge transfers and cross-teams training.

Confidential

MySQL DBA

Responsibilities:

• Designing of database and data flow in the system, creation of various objects like procedures, functions, views and sequences.
• Continuous 24*7 monitoring of MySQL servers having about 2 TB data using MySQL Performance monitor and various OS specific commands and scripts.
• Working with various MySQL tools like MySQL Workbench, MySQL Administrator, MySQL GUI Tools, SQL Yog, MySQL Performance Monitor, MySQL Migration Toolkit, Oracle PL/SQL Developer, SQL Developer and Toad.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Replication monitoring on MySQL and Postgres. Check lag and monitor of errors or warnings.
• Documented the security standards and roles depending on Development, UAT and Production environments.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• 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.
• Developed solution for complex joins, creating dynamic SQL scripts to support system analysis, and troubleshooting of legacy bugs / issues.
• Migrating databases or schema movement as per the requirements.
• OLTP / OLAP, Data Warehouse programming code development.

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