SUMMARY

• A dedicated, detail - oriented MySQL DBA with valuable and extensive experience managing multiple production-facing databases in Linux and Windows platforms.
• In-depth knowledge of MySQL, tuning and troubleshooting.
• Extensive MySQL query optimization and performance problem solving

TECHNICAL SKILLS:

Databases: MySQL 5.0, 5.5, 5.6; Oracle 11g, Oracle 10gExpress

MySQL Tools: Navicat for MySQL, MySQL Workbench, MySQL Enterprise Manager, TOAD, DBvisualizer, S

OS Platforms: Ubuntu, Redhat Linux, CentOS, Debian, Windows Vista, XP, 2000, 98, 95

Other areas of interest: ELK Stack, Forgerock, and Linux administration

PROFESSIONAL EXPERIENCE

Confidential, Greenville,SC

MySQL DBA

Responsibilities:

• Built and configured MySQL databases for development and testing purposes
• MySQL administration on production environment - installation, tuning, backups,resources optimization and distribution of replication in large-scale environment.
• Experience designing systems that can load and understanding the real limitations to said design.
• Worked as part of AWS build team
• Managing AWS Backups and implementing sharing a DB Cluster Snapshot
• Configuring AWS CloudWatch for monitoring RDS,Aurora Instances.
• Creating user accounts and appropriate privileges as well as maintaining database security
• Experience building high availability continuent tungsten database clustering and replication scalable systems for our clients.
• Configuration and execution of installations,upgrades and migrations, and implementing security controls.
• MySQL query optimization and performance problem solving
• Configured backup and restore management.
• Performance monitoring and tuning,analyzing database metrics and assisting with capacity planning.
• Experience in LAMP stacks and supporting technologies
• Managed memory and I/O utilization on MySQL Database server.
• Maintaining and troubleshoot database problems.
• Excellent communication skills.

Confidential, Charlotte, NC

MySQL DBA

Responsibilities:

• Performs general DBA duties ( design, install, monitor, maintain, and performance tuning,production databases while ensuring high levels of data availability.
• Responsible for developing, implementing, and overseeing policies and procedures to ensure the integrity and availability of databases and their accompanying software.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Monitor, optimize, and allocate physical data storage for database systems
• Perform database transaction and security audits.
• Review and execute new queries as needed to support business requirements.
• Perform table maintenance as needed for business requirements.
• Experience in replication configuration and resolving replica database performance anomalies.
• Experience building and administering production databases
• Knowledge of and experience in de-facto standards and best practices in MySQL.
• Performance monitoring and tuning; analyzing database metrics and assisting with capacity planning.
• Configured backup and restore scripts.
• Creating and enforcing database best practices and working closely with subject matter experts, architects, developers.
• Monitoring and analyzing RDBMS for performance, and administering performance tuning
• Familiarity with BaaS cloud computing .
• Experience working on multiple Galera cluster servers and NDB cluster.
• Excellent communication skills.

Confidential, RI

MySQL DBA

Responsibilities:

• Managing over 50 Production facing databases on Linux 5.6 servers in 4 environments - Production, Test/QA, Dev and Lab.
• Installing and configuring MySQL database software on Linux and Windows servers. Experience with 5.0, 5.5 & 5.6
• Used MySQLhotcopy for data migration across environments
• Creating user accounts and appropriate privileges as well as maintaining database security.
• Maintaining and troubleshoot database problems.
• Create different table spaces, tables, schemas and users accounts.
• Perform daily database Managing MySQL databases, backup and recovery, troubleshooting, etc Knowledge and hands on experience of MYSQL Replication technology (Async - Master-Master& Master-Slave replication)
• Performing moderately complex server-class database activities across various platforms and 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
• Backup and recovery of MySQL databases
• Managing logs and errors messages
• Creation of Database objects
• Auditing and encryption on all production databases

Confidential, NJ

MySQL DBA

Responsibilities:

• Experience working on multiple projects, some of which are inter - related, with multiple multinational development teams building out MySQL schemas for use with OLTP applications.
• Experience working with the Business Analysts and the Development Teams to create an in-store database schemas and table layouts.
• Knowledge and hands on experience of MYSQL Replication
• Reverse engineer the existing databases into a comprehensive physical data model, document all interdependences, and inconsistencies.
• 0 Perform backup and recovery for MySQL
• Creating and enforcing database best practices and working closely with subject matter experts, architects, developers.
• Writing SQL scripts, Linux shell scripts, SQL tuning, and MySQL/MariaDB troubleshooting.
• Creating user accounts and appropriate privileges as well as maintaining database security
• Configuration and execution of installations, upgrades and migrations, and implementing security controls
• Performance monitoring and tuning; analyzing database metrics and assisting with capacity planning
• Working knowledge of Linux Operating systems
• MySQL query optimization and performance problem solving

Continental, NJ

MySQL DBA

Responsibilities:

• Performs general DBA duties (install software, create databases, table spaces, add redo log files, managing storage & work closely with Sr. DBA on capacity planning and performance tuning
• Performs daily database backup of development and test environments, use production data to refresh development and test schemas for testing
• Excellent troubleshooting skills
• Identify and make recommendations per database performance issues
• Implements/maintains database security with roles and system privileges
• Experience working in a help desk and call center environment.
• Demonstrate ability to quickly diffuse heated customer situations.
• Excellent troubleshooting and logical problem solving skills.
• Demonstrate ability to meet deadlines and set priorities.
• Strong communication and interpersonal skills.
• Ability and desire to learn new technologies quickly
• Monitoring and analyzing RDBMS for performance, and administering performance tuning
• Working knowledge of Solaris and Linux Operating systems
• Experience using the MySQL 5x suite in the LAMP environment
• Excellent organizational skills and ability to adhere to given deadlines.
• Knowledge and hands on experience of MYSQL Replication
• Tuned slow running queries
• Performed data migration using MySQLDUMP and MySQLHOTCOPY
• Automated backup jobs
• Upgraded database from MySQL 5.0 to 5.5