Database Administrator/Analyst Resume Richmond, VA - Hire IT People

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 provide IT Staff Augmentation Services!

Database Administrator/analyst Resume

Richmond, VA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship