MySQL DBA Consultant Resume

OBJECTIVE:

MySQL DBA position.

SUMMARY:

MySQL database design, administration and programming: Performed analysis, design, and creation of databases and applications. Provided production support, performance tuning, and maintenance of databases. Created business models, data structure diagrams, modified or restructured existing database systems.

SKILL:

MySQL / Percona Server v. 5.0.x - 5.6.x. DBA: Administration, Backup and Recovery, Replication, Tuning and Partitioning, High Availability. Icinga/Nagios, MONyog, bash scripting, sysbench, SQLYog, phpMyAdmin, PHP, XHTML, CSS, JavaScript. Linux: Redhat, CentOS, Ubuntu.

EXPERIENCE:

Confidential

MySQL DBA Consultant

Responsibilities:

Performance tuned MySQL hosts, created configuration files, resized MySQL tablespaces, created backup scripts, and recommended and installed monitoring solutions, including Nagios plugins, and configuring MONyog monitors.
Installed replication on MySQL instances. Recommended future scaling options, best practices, and performed trouble-shooting of MySQL instances.
Evaluated slow queries and installed or removed indexing as appropriate to usage.

Confidential

Senior MySQL Database Administrator

Responsibilities:

Installation, configuration, performance tuning, upgrading, backing up, benchmarking, and monitoring of Percona / MySQL 5.0, 5.1, 5.5, and 5.6 database instances in a variety of configurations.
Installed database monitoring tools and services using Nagios, MONyog, and other monitoring and maintenance scripts.
Created scripts for database backups and maintenance.
Provided technical resource support and data analysis to business units and staff, and problem resolution for database issues.
Worked with business units to define needs for databases, table definitions, sizing, backup strategies, and provided advice for best practices.
Migrated and upgraded Percona / MySQL instances between physical hardware locations.
Set database related policies and procedures.
Installed Cassandra and created backup scripts.
Supported 500+ MySQL / Percona database instances. .

Confidential

Staff MySQL Database Administrator

Responsibilities:

As the primary MySQL database administrator, designed structural enhancements, installed, monitored, and maintained databases and servers.
Set up and maintained replication on servers using InnoDB, MYISAM, Memory, and Federated storage engines.
Tuned MySQL databases, created table partitioning schemes, identified I/O bottlenecks, and sharded databases. Set up monitoring and backups.
Created database related policies and procedures, with related documentation.
Converted databases to use multiple languages.
Acted as a resource for MySQL issues, and aided development engineers with database design, structural, and processing concerns.
Trained additional DBA staff. Provided production support for database issues.
Evaluated queries and indexing for performance concerns. Developed MySQL stored procedures and triggers. .

Confidential

Database Administrator

Responsibilities:

Designed, developed, and supported MySQL instances for a high availability system.
Created and supported replication schemes, monitored and maintained MySQL databases, with performance tuning, query optimization, and working with engineers to develop data models and schema changes.
Created MySQL stored procedures, triggers, and functions for both transactional and analytical systems.
Performed system maintenance, production support and maintenance scripts.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship