MySQL DBA Resume Boston, MA - Hire IT People

SUMMARY

A dedicated, detail - oriented MySQL DBA with valuable and extensive experience managing multiple production-facing databases in Linux and Windows platforms

TECHNICAL SKILLS

Databases: MySQL 5.5,5.6, 5.7; Oracle 11g, Oracle 10gExpress; SQL Server 2012

MySQL Tools: Navicat for MySQL, MySQL Workbench, MySQL Enterprise Manager, T-SQL, TOAD, DBvisualizer, Sourceforge, Commandline, Oracle SQL Developer, J-Developer, SShD tools, Putty, WinSCP

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

Other areas of interest: ETL, DataWarehousing, Software development and project monitoring, Linux administration

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

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
System test planning and execution
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, Boston, MA

MySQL DBA

Responsibilities:

Installation, Upgrade and Patching of MySQL and Oracle databases
Built and configured MySQL databases for development and testing purposes
Maintained databases for each environment
Allocated storage - creating table spaces, adding and resizing data files to existing table spaces, creating and multiplexing redo log files, etc. for redundancy network and system engineers to configure robust and scalable systems for our clients
MySQL administration on production environment - installation, tuning, backups, resources optimization and distribution, Innodb and MyIsam storage engines, replication in large-scale environments
MySQL query optimization and performance problem solving
Managed memory and I/O utilization on MySQL Database server
Configured backup and restore scripts
Troubleshooting network issues
Creating user accounts and appropriate privileges as well as maintaining database security
Perform backup and recovery for MySQL.
Performance tuning, maintaining and troubleshooting database problems
Developed dynamic matrix report using MySQL

Confidential, Boston, MA

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 querries
Performed data migration using MySQLDUMP and MySQLHOTCOPY
Automated backup jobs
Upgraded database from MySQL 5.0 to 5.5

We provide IT Staff Augmentation Services!

Mysql Dba Resume

Boston, MA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship