Manager Oracle
Resume:
Buchi Ishicheli
**********@*****.***
Position:
Oracle Database Administrator
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 Experience
Planning, installation, configuration, management and troubleshooting of Oracle 10g,11g and 12c databases on Linux and Windows OS
Expertise in the creation of databases, table spaces, tables, indexes and other database objects.
Installed and manage Oracle Enterprise Manager.
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 reference
Administer database user accounts. Create, modify and deactivate user accounts; assign and monitor user access rights
Created Testing and Development databases following OFA compliance rules.
Provide database administration on production, testing and development database servers.
Managing Schema Objects.
Regular Monitoring Alert log Files and trace files on Day to Day Basis.
Identifying and removing Fragmentation, row migration/chaining of database objects.
Analyzing the Tables and Indexes on performance base regularly
Monitoring Tablespaces and Datafiles utilization.
Managing Undo Tablespaces, Redo Logs, Control files and Archive logs.
Implemented multiplexing control files and redo log files
Configuring various RMAN parameters as per the requirement.
Performing physical backups using RMAN utility.
Identify and recover the corrupted db blocks using Block recover option in RMAN utility
Performing Complete Media Recovery of Database depends on the nature of failure.
Configure and implement the use of Oracle Recovery Manager (RMAN) for cold and hot backup to the databases
Extensively using DATAPUMP and Export /Import utilities for logical backups.
Performing database cloning using RMAN.
Monitoring the user sessions and take appropriate action to kill the inactive sessions
Creating and rebuilding indexes as necessary.
Performed various performance goal oriented database tuning.
Use explain plan, AWR, ADDM and various Oracle Advisors to tune the database.
Created and tuned various materialized views.
Tuned various slow running query
Performed instance tuning, memory tuning query tuning and complete database tuning.
Creates and implemented various table partitions for large tables
Resolved various complex issues with the database.
Apply quarterly CPU patches to different version of databases.
Upgrade Oracle 10g database to 11g.
Upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set
Installed, configured and managed 11gR2 (RAC) on ASM storage
Manage RAC databases using CRSCTL, SRVCTL and grid control
Configure and setup Oracle 11gR2 Data Guard.
Managed Data Guard using Data Guard broker.
Troubleshoot and resolved log gap in Data Guard Configuration.
Other job positions
Work EXPERIENCE:
Company: Boltos Solution
Job title: Oracle database administrator
Location: laurel, Maryland
From 08/2013 - 12/2015
I have hand on experience and knowledge on sqlplus and unix
My Education:
Prince George’s Community College
Sophomore in Prince George’s Community College
Major: Computer Science
Reference upon request.
Contact this candidate