Manager Oracle

FIDELIS G AKOH

Oracle Database Administrator

972-***-****/***********@*****.**.**

EXPERIENCE SUMMARY

Oracle Database professional with over 6 years of experience. Offering a record of accomplishment of stable employment, loyal service and always ready to learn new skills, available to relocate and work additional hours to support business objectives. Highly motivated individual with strong leadership and interpersonal skills, who can be trusted with highly sensitive /confidential documentation and projects. Self-starter and adaptive learner exceeding business standards and expectations. Possesses excellent written and verbal communication in English.

SKILLS

Database security (4years) . Oracle database performance Tuning (6years)

Transparent Data Encryption (5years) . AWR report analysis (5years)

Patch set update & management (4years) . ADDM, ASH, ADCI, (6years)

RNAM-Backup & Recovery (6years) . SQL TRACE(4years)

Data Pump and expdp/impdp(6years) . TKPROF, EXPLAIN PLAN(6years)

SQL /SQL * Plus (5years) . Oracle Database User Management (6years)

Automatic Storage Management (ASM)(5years) . Oracle Enterprise manager (5years)

Oracle Data Guard (4 years) . Oracle Database Refresh(5years)

Linux/UNIX (5years) . Oracle VM Virtual Box (4years)

Oracle Architecture (6years) . EXPLAIN PLAN

ACCESS &EXCEL (6years)

RAC (6years)

PROFESSIONAL EXPERIENCE

Environment: Linux Red Hat Enterprise 6. Windows. Oracle 11 g and 12c. Oracle RAC(11g). Data Guard.

Oracle Grid Control. RMAN. ASM. SQL Developer. SQL * Plus.

Responsibilities- Provide all levels of database administration support on oracle 11g and 12 C Linux environment by;

Performing daily review of database instances through Grid to ensure all database instances are running, Listener are up, backups are successful, redo logs are in sync and scheduled jobs are completed.

Implemented Security policy enhancement through roles, profiles and privileges and pass policies as per business requirements.

Performed other Security related tasks including Transparent Data Encryption(TDE)

Generate a weekly report comprised of specific task accomplished during the week, work in progress and any specific risk, concern and or obstacle encounter.

Monitoring service account to identify account which required a password change within 120days for that week and notify the account holders and the entire DBA team.

Performing weekly job batch processes every Monday before noon

Check backup status every Monday and Saturdays. Cleaned up failed and obsolete backup and manually retake backups in case of backup failure.

Designing, implement and administering database standard security procedures

Performed installation and configuration of ASM, Database software, Listener, Patching and database creation in development, staging and production environment.

Applying quarterly CPU patches to fix vulnerabilities in different version of oracle databases as well as manually upgrading these databases from 10g and 11g 12c.

Performed migration using parameter file and generated script.

Performed database security check list/lock down to ensure security compliance with database configuration and server.

Monitoring Alert log files and trace files daily,

Upgrading Oracle 12c database from 11.2.0.3 to 12.1.0.2 using DBUA and patch set.

Analyzing tables and indexes to tune database for faster performance.

Perform Roll Forward of standby database to sync with primary database.

(A WR/ADDM) to identify and resolve bottlenecks in database.

Experience in setting up Oracle Data Guard and administering Oracle data Guard, as well as troubleshooting and resolving log gap in data guard configuration.

Strong RMAN backup and recovery skills. Ability to restore and recover databases, tablespace quickly up to a point in time.

Configuration of FGA policy. perform standard and fine-grain auditing on the database usage by auditing changes made to data and databases event such as unsuccessful failed attempts to log into the database for security purposes

User account management, including creating database users, assigning quota, roles, privileges, deactivating users account, password management.

Oracle 11g and 12c RAC Database monitoring, backup and recovery, and maintenance.

Oracle Database Administrator NFC BANK

2010-2014

Oracle DBA

Responsibilities:

Performed monthly and annual performance reports trend analysis and planning.

Successfully installed and configuration Oracle 11.1.0.7

Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11gR2 database on Linux and windows OS.

Expertise in the creation of databases, table spaces, indexes and other database objects.

Install and manage Oracle Enterprise Manager(OEM).

Install and configure relevant network component 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 user account. Create, modify and deactivate user accounts; assign and monitor user access rights.

Created testing and development databases following OFA compliance rules.

Provided database administration on production, testing and development database servers.

Managing schema Objects.

Daily monitoring of Alert log Files and trace files.

Identify and removing fragmentation, row migration/chaining of database objects.

Analyzing the Table and Indexes on performance base regularly.

Monitoring tablespace and Datafiles utilization.

Managing Undo tables spaces, redo logs, control files and Archive logs.

Implemented Multiplexing control files and redo logs files.

Configuring various RMAN parameters as per the requirement.

Performing physical backups using RMAN utility.

Performed incremental backups using RMAN.

Identify and recover the corrupted dB Block recover option in RMAN utility

Performing complete Media Recover of Database depends on the nature of failure

Configure and implement the use of Oracle Recovery Manager (RMAN) for cold and hot backups to the databases

Extensively using DATAPUMP and export/Import utilities for logical backups.

Performing database cloning and duplication using RAMN.

Monitoring the user sessions and take appropriate action to kill the inactive session involved in converting a single instance database to Oracle 11g, 10g databases.

Utilized TOAD for database management.

Implemented security policy enhancement through roles, profiles, privileges and password as per business requirements.

Performing other Security related tasks including Transparent Data Encryption (TDE)

OPERATING SYSTEM: Red Hat Linux RHEL 6/7 and window XP

RDMS

Oracle 10g/11g and 12c

LANGUAGES

SQL, PL/SQL

SOFT WARE/ APPLICATION/TOOLS

DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid control, Oracle Data Guard, Oracle Management Service (OMS), Agents, Real Application Clusters(RAC), ASM, sql Developer, TOAD, EXP/IMP, Data Pump (Expdp/impdp), SRVCTL, SQL, Plus, Recovery catalog, Autosys, Crontab, HP Manager, MY Service, OTG etc.

Tuning Tools:

SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, AND ADDM etc.

WEB TOOLS:

HTML, XML

EDUCATION /CERTIFICATION

. University of Buea Bachelor’s Degree

Business Management 2005-2008

. Collin collage McKinney TX CompTIA A+

. North central Texas college Gainesville Associate Of applied science( major in petroleum technology)

Contact this candidate