Oracle Database Administrator

Objective

A database administrator with more than 4 years of experience in information technology of extensive experience in testing, designing, coding and supporting database solutions in oracle enterprise and server environment. A team player that posses strong technical and problem solving skills

Professional Summary

Proficient in Oracle 10g, 11g and 12c Database Administration

Proficient in Enterprise Manager

Proficient in RMAN, Backup and Recovery

Proficient in Database Migration, Upgrade and Patch Application

Performance Tuning

Real Application Clusters

Data Guard Administration

A self-motivated, responsible and reliable team player with a set of strong technical skills

Strong in solving problems of diverse scope where technical analysis and evaluation is required

Results-driven IT personnel with skills in team building and problem-solving with an established reputation for effectively working with diverse groups of people and adaptability to changing environments

Professional Certification

OCA Oracle 11g Database Administrator Certified Associate

Education

Bachelor of Arts: Health Administration & Policy Program (HAPP) May 22, 2012

University of Maryland, Baltimore County (UMBC)

Boltos Solution, Laurel MD

Certification Information Technology August 14-December 2014

Work Experience

America Cash Express

Database Administrator May 2014 – July 2016

Performed hot and cold backup and recovery using RMAN and Linux Scripts

Worked on application and database security (data access, passwords, network, etc.)

Set up database auditing

Administer database user account

Export and Import of database objects to copy from one database to another database.

Performed bulk load to database using sql loader

Perform database refresh and schema changes on test and production

RAC administration involving SCAN issues, DISK issues, Master node monitoring, Cron job monitoring including metadata and whole database export

Implemented disaster recovery system, using RMAN and custom written shell scripts. Create and maintain Oracle Data Guard configuration

Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.

Used to run the scripts to check the status of databases

CYSTIC FIBROSIS FOUNDATION

Database Management Specialist April 2012 – March 2014

Manage Oracle and Progress test, production databases running on Linux.

Install and configure relevant network components to ensure database access as well as database consistency and integrity

Troubleshoot and resolve various Oracle connectivity problems.

Provide network troubleshooting and administrative support for the development staff

Installation and management of Oracle database using database control

Create and manage documentation on the configuration and support of the Oracle databases

Perform bulk load into the database using SQL Loader

Perform standard and fine grain database auditing.

Documented database structure, changes, problems, issues for future references

Take a cold backup of test database files on file system level.

Managing Schema Objects

Regular Monitoring Alert log files and trace files on Day-to-Day Basis.

Identifying and removing fragmentation, row migration

Additional Skill And Abilities

Microsoft Word, Excel, Access, PowerPoint; People Soft, Database, Sql Loader, Enterprise Manager, Disaster Recovery, Sql Loader, Data Guard, Troubleshooting, Rman, PL/SQL, Online Backups, Data Pump

Contact this candidate