SUMMARY

• Database Administrator with 4+ years’ of core IT experience in Database Installation, Designing, Administration and troubleshooting database servers like AWS RDS, MySQL 5.6, MySQL 5.5, MySQL 5.1, Oracle 9i/10g/11g on Windows, Linux and Unix platforms.
• Comprehensive knowledge in Database architecture and Implementation, Data Modeling, Database Designing, Tuning Databases and Queries, Procedures, Functions, Triggers and Events.
• Design and Implementation of High Availability solutions and Disaster Recovery Solutions.
• Installation and Maintaining MySQL 5.6/5.5/5.1 enterprise and community versions, Installation of Percona Xtradb/Galera cluster database instances in production environment and setup of configuration files.
• Installation and configuration of Percona Xtrabackup open source backup solution and VERITAS Netback up for effectively backing up MySQL databases on Linux and scheduling of full and incremental backups and restoration activities.
• Configuring multiple Master - Slave replications on Active - Passive on Solaris OS Cluster suite and HP Cluster suite for achieving high availability and DR solutions.
• 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.
• 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.
• Experience with ETL tools like Jasper ETL and Pentaho mainly for transformation processing, designing and developing jobs for implementing Data Mart applications.
• Maintaining database and tuning database parameters and queries for effective performance.
• Defragmentation of tables and indexes for improved performance and effective space management. Automating various database specific routine tasks through procedures and shell/Perl scripts.
• Developing and maintaining of common objects such as Tables, Views, Indexes, Cursor, Procedures, Functions, Triggers (Autonomous Transaction).
• Creation of events for scheduling jobs in MySQL.
• Effective management skills and ability to focus on intermediate as well as long term project goals; excellent organizational skills and believe in TEAM (Together Everyone Achieve More)-Work.
• Experience with other databases like Installation of Oracle 9i/10g/11g database on Linux Red Hat and Windows Server.

TECHNICAL SKILLS

Databases: AWS RDS, MySQL 5.6/5.5/5.1, Percona XtraDB/ Galera cluster, NDB clusterOracle 9i/10g/11g.

Database Tools: MySQL Workbench, MySQL Toad, Vivid Cortex, MySQL Migration Toolkit, MySQL GUI Tools- MySQL Query Browser and MySQL Administrator, Jasper ETL, Pentaho data integrator for ETL Purpose, Nagios, Cacti, Percona Xtrabackup, Percona toolkit, Zmanda Backup, VERITAS Net Backup, MySQL Enterprise Monitor, Microsoft Visual studio.NET, Tungsten Replicator, MySQL Fabric

Other Tools: Visual Source Safe (VSS) and Visual Source Safe Admin, Team Foundation Server (TFS), JIRA, Bugzilla, Nagios, Cacti, MySQL Enterprise Monitor

ETL Tools: Jasper ETL, Pentaho, Talend

Languages: Unix Shell Scripting, Perl, C, C#

Environment: Suse Linux, Red Hat Linux, Unix, Windows Server 2003/Windows

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

MySQL DBA

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 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.
• 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.
• 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: MySQL 5.6.2, Oracle10g, PHP MyAdmin, Web Services, Shell Script, Apache, LINUX.

Confidential

Engineer - JR MySQL DBA, Developer

Responsibilities:

• 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.1 to My SQL 5.5.
• Tuning database by partitioning tables.
• Implementing MySQL database replication.
• Migration of legacy Oracle database to MySQL database.
• Working with various MySQL tools like MySQL Workbench, MySQL Administrator, MySQL GUI Tools, SQLyog, MySQL Performance Monitor, MySQL Migration Toolkit, Oracle PL/SQL Developer, SQL Developer and Toad.
• Facilitated requirements collection, documenting database through Entity- Relationship diagrams.
• Migrating legacy data to PostgreSQL databases and maintaining them.

Confidential

JR MySQL DBA

Responsibilities:

• Maintained, monitored, tuned, and support existing MySQL 5.0/5.1 database environments for production, staging, QA and development
• 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.
• 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;
• Working with various MySQL tools like MySQL Workbench, SQL Yog, MySQL Performance Monitor, SQL Developer and Toad.
• Creating Procedures and Functions for Reporting and ETL Purpose.
• Estimate database capacities and develop system for monitoring;
• Supporting management with different database related decisions.
• Documented all servers and databases.