SUMMARY:

• Results - driven MySQL Certified DBA and Linux Administrator with 4+ years of experience in Database administration tasks and Linux System Administration
• Strong passion for MySQL DBA tasks and troubleshooting and resolving issues
• Strong working experience in designing, capacity planning, and security and accessibility functions of databases.
• Hands-on experience supporting SQL queries and databases by updating performance tuning
• Strong experience in installing and configuring MySQL and Amazon RDS on Linux and Windows environments
• Strong working knowledge and training in AWS instances EC2 and Cloud technologies
• Working knowledge of Install and maintain MongoDB
• Hands-on experience with automation of tasks using a combination of Cron/At, Shell scripting
• A fast-learner and self-sufficient with the ability to learn and pick up new technologies very fast
• Adaptable to surroundings and customer and company needs
• Excellent communication skills verbal and written

SKILL:

MySQL: Enterprise Monitor(MEM), Nagios, Zabbix, Command-Line tools such as MySQLadmin), MySQL Dump, MySQL Enterprise Backup, PerconaXtraBackup, Cluster Control

Technologies: RHEL 6 & 7, Ubuntu, Amazon EC2 instances, Amazon RDS, Mongo DB, Maria DB, Virtualization with Oracle VirtualBox, KVM, VMWare Windows Vista, XP, 2000, 98, Mac OS

Security: IAM, SElinux, Firewall, TCP Wrapper, PAM, SEBoolean

PROFESSIONAL EXPERIENCE:

Confidential, Saginaw, MI

MySQL DBA

Responsibilities:

• Administer and manage the entire MySQL server development and production environment
• Install and configure MySQL and MariaDB on Red Hat Linux
• Manage MySQL 5.5, 5.6, and 5.7 in production and developer environments on both Linux(6.6) and Mac OS X.
• Install, upgrade, optimize, troubleshoot, perform root cause analysis on, and maintain MySQL Servers
• Perform installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, and tuning and data integrity
• Tasked with doing monitoring database server, table maintenance and optimization of InnoDB and MyIsam tables using MySQLadmin and MyIsamchk
• Increase database performance by utilizing MySQL config changes, and multiple instances by upgrading hardware
• Assist with sizing, query optimization, buffer tuning, backup and recovery, installation, upgrades and security including other administration functions as part of profiling plan
• Ensure production data being replicated into data warehouse without any data anomalies from the processing databases
• Effectively configured MySQL Replication
• 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 and clients
• Carried 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
• Create and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc

Confidential, Freehold, New Jersey

MySQL DBA Consultant

Responsibilities:

• Managing all MySQL Servers from Dev to production servers
• Assist with doing backups, monitoring all App job actives and troubleshoot with any issues arise
• Administration and management of the entire development, QA and production environment.
• Installed and configured MySQL on Linux
• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and Mac OS X.
• 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
• Monitoring TCP/IP network environment
• Scheduling backup of files
• Monitor and check for the health of the operating system
• Install and maintain security patches in the production and development system which includes but not limited to Red Hat Linux
• Monitored CPU, memory and disk performance

Confidential

Redhat Linux and MySQL DBA

Responsibilities:

• Monitoring TCP/IP network environment
• Hardware and software inventory
• Scheduling backup of files
• Setup, configure and manage network for Linux systems
• Created and maintained user accounts, removed users, lock/unlock users in Linux systems.
• Perform daily backup operation, ensuring all required system data are successfully backed up
• MySql and Maria Database Administrator/Architect
• Perform all tasks associated with daily operations such as database availability
• Monitoring activity, installations, upgrades, and back - up strategy
• Retrieve all statements from Slowquery log to analyze for performance tuning
• Performing stored procedures and functions in both MySql
• Replication and High Availability and MySql Cluster installation
• Daily support of Apache web server
• Monitored CPU, memory and disk performance
• Created and maintained Linux file system
• Completed work on LVM. Created volume groups, extended volume groups, reduce volume groups
• Worked with virtualization using KVM and Oracle VirtualBox in Linux environment.
• Managing systems routine backup, scheduling jobs, enabling Cron jobs, enabling system logging and network logging of servers for maintenance