Manager Oracle

PROFESSIONAL SUMMARY

A Dedicated Database Administrator with a total of 5 years database management expertise, looking for a position as an Oracle Database administrator in a fast growing company.

SKILLS

Oracle database architecture design and implementation

Oracle Enterprise cloud control

Database installation & configuration

Database patching & upgrading

PROFESSIONAL EXPERIENCE

June 2016 – Present

Database Administrator (remote) at IQ5 Consultancy Starkville, MI

Experience in database installation and configuration of oracle,10g,11g and 12c

Database configuration (DBCA) to create configure and drop database

Database modeling and Design through Data Definition Language (DDL)

Data management, performance management using Automatic Workload Repository (AWR), Automatic Database Diagnostics Monitoring (ADDM), Tuning Advisor.

Uses Oracle Enterprise Manager for monitoring and managing

Backup and recovery of data using recovery manager (RMAN)

Resolving Slow running SQL query using command line or Oracle Enterprise Manager

Oracle Data Guard for data protection and disaster recovery

Creating table spaces, users, create objects in schema, grant object privileges

Uses Real Application Cluster (RAC) to cluster the database, Automatic Workload Repository (AWR) and Active Session History (ASH) to generate reports

Setting up a standby database from a primary database

Generating and using SQL statements to perform task

Patching and Upgrade of the database using SQL query, manual method

Improved database Performance tuning using tracing, tuning advisors, tkproof, Awr and Ash report scripts.

Work with developers, application experts, to solve performance issues.

Create user, allocate appropriate tablespace quotas with the necessary privileges and roles.

Perform database migrations, conversions and updates.

Installation of oracle software and configuration of databases using both the DBCA and database scripts.

Ample use of oracle Rman for backup and recovery (point in time recovery on different host).

Execute import and export tasks using the new Data pump technology (impdp and expdp).

Enhanced remote database upkeep and maintenance.

Created users, passwords and granted privileges to users in a multi user environment to ensure access to right users in order to boast the security of the company's data.

October 2012– January 2016

Database Administrator :Pharmacy Mondial

Work with developers, application experts, to solve performance issues

Create users; allocate appropriate tablespace quotas with the necessary privileges and roles

Perform database migrations, conversions and updates

Installation of oracle software and configuration of databases using both the DBCA and database scripts

In-depth use of oracle Rman for backup and recovery (point in time recovery on different host)

Execute import and export jobs using the new Data pump technology (impdp and expdp)

Performed and evaluated patching and upgrades to meet required business needs

Enhanced remote database upkeep and maintenance

Created users, passwords and granted privileges to users in a multi user environment to ensure access to right users in order to boast the security of the company's data

Constantly checking the log files for any critical errors that may have been detected and using proactive measures in resolving them

Resolved database alerts: space addition, listener issues, connection and passwords

Constantly checking the log files for any critical errors that may have been detected and using proactive measures in resolving them.

TECHNICAL SKILLS:

Operating Systems: LINUX, UNIX, Windows

Databases: OLTP, DSS, and WAREHOUSE databases

Tools: Oracle Enterprise Manager (OEM)/Grid Control, Oracle Expert RMAN), SQL Loader, SQL*Plus

3rd Party Tools: SQL Developer, Toad

EDUCATION

Certified Oracle Database Administrator (January 2017 - December 2017)

Oracle Database SkyTech, Los Angeles, USA

Bachelors of Science, Journalism & Mass Communications(October 2011 – December 2014)

University of Buea, Southwest, Cameroon

REFERENCES

Available upon request

Contact this candidate