We provide IT Staff Augmentation Services!

Mysql Database Administrator Resume

0/5 (Submit Your Rating)

Glen Burnie, MD

SUMMARY

  • 7 + Years as a DBA with 5 years’ experience as a MYSQL DBA in highly competitive environments.
  • Have performed 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) DBA Experience protecting database integrity.
  • Managing access controls and adequate segregation of duty, user access management i.e. creating and granting user access and roles including System management activities; troubleshooting, reviewing and monitoring database performance.

TECHNICAL SKILLS

OS/Platform: MS Windows (8, 7, Vista, 2000, 98, 95), Linux (Ubuntu & Red Hat), UNIX, Mac OS X, SQL*Plus Oracle, Solaris, Mainframe, Centos Linux

Programming Languages: , PHP, Bash Shell, Python, SQL,C++,Visual Basic, VBA

Databases: MySQL, Postgre SQL, Oracle (10g, 11g),, MongoDB, MS AccessAssistant, Oracle Net Manager, SQL*Plus and iSQL*Plus, Recovery Manager (RMAN), Data Pump and Command - line tools

Oracle Tools: MySQL Workbench 6.0, Oracle Enterprise Manager(OEM) with Diagnostics, Oracle Universal Installer, Database Configuration Assistant, Database Upgrade

PROFESSIONAL EXPERIENCE

MySQL Database Administrator

Confidential, Glen Burnie, MD

Responsibilities:

  • MySQL administration on production environment; installation, tuning, backups, resources optimization and distribution, InnoDB and MyISAM storage engines, replication in large - scale 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
  • Installation of MySQL server and client software applications in a large environment
  • Perform backup and recovery for MySQL, 10G and 11G databases
  • Responsible for database management and monitoring (alert log, memory, disk I/O, CPU, database network connectivity)
  • MySQL query optimization and performance problem solving
  • Creating user accounts and appropriate privileges as well as maintaining database security
  • Ensure daily export backups are completed and valid for restore and recovery
  • Monitoring and analyzing RDBMS for performance, and administering performance tuning
  • Experience using the MySQL 5x suite in the LAMP environment
  • Knowledge and hands on experience of MySQL replication management
  • Proficient in working with Linux CentOS/RHEL

Database Administrator/Analyst

Confidential, Richmond, VA

Responsibilities:

  • Installed and maintained Oracle Database suite on multiple platforms; and acted as liaison with other departments and teams with accessibility of database. (Ubuntu and Windows )
  • Hands - on knowledge of Oracle Database 11g technologies including RAC and ASM,RMAN, and Data Guard
  • Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g
  • Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
  • Extensively implemented Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "runInstaller" and perl based utility "opatch".
  • Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROFEXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O
  • Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
  • Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level
  • Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).

We'd love your feedback!