Oracle Maintenance

Elvis C. Mbaku

Oracle Database Administrator

**********@*****.*** 763-***-****

Professional Summary:

Over 6 years of hands-on experience working on DBA/Architecture, Production 24*7 support, Implementation, Configuration, Upgrades, Replication, Performance Tuning/ Optimization/ AWR, ADDM, User/Security Administration, Backup/Recovery, Data/Network Administration and Maintenance, Database Migration, ASM.

Experience in Upgrading databases and applied patch sets to multiple databases.

Expertise in Database Space Management, Expertise in troubleshooting and performance tuning.

Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection.

Database monitoring and performance tuning using OEM GC, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM,

Worked on Automatic Storage Management (ASM) for managing data in SAN.

Monitoring and resolving tickets in different environments.

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

Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups. Highly experienced in all the phases of Software Development Life Cycle (SDLC)

Hands on experience in Migrating/Upgrading Oracle Database using GoldenGate

Experienced in implementing scripts using bash, k-shell, and writing scripts for backup purposes

Experienced in handling multiple tasks simultaneously and extended 24 X 7 database support to developers and end users.

Actively involved in Advance Configuration of Dataguard for Disaster Recovery and RAC for High Availability

Hands-on experience performing consulting connectivity via database API’S

Excellent work experience in developing applications using Oracle SQL Scripts, PL/SQL, Shell Programming.

Installation, configuration, maintenance and tuning of Oracle RDBMS 10g -12c in Production, QA, and Test environments as well as 10g Forms and Reports and 10g-11g Application Suite.

Oracle Database Upgrades 10g to 11g, 11g and 11gr2 to 12c.

Migrating and consolidation of 11g databases into 12c in both QA and Production environments.

Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning.

Upgrade/Migration of Databases from Oracle 9i to 10g and 10g to 11g as well migrating experience over cross platforms from Linux to Solaris, AIX to Solaris and from windows to Linux.

Strong analytical and problem solving skills with ability to work within a team environment and independently when needed.

Result oriented, self-motivated, Team player, ability to work independently and within a team.

Technical Skills

Operating Systems

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10.AIX 5.1, 5.2, 5.3, 6.1RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10.Windows 95/98/NT/2000.

RDBMS

Oracle 9i/10g&11g

Tools & Utilities

RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages

SQL, PL/SQL, C, C++, UNIX Shell Scripting, PERL.

Others

Remedy, ConnectWise.

Education Experience:

University of Yaoundé II (Soa) Cameroon:

Masters in International Relations and Public Administration

University of Buea Cameroon:

Bsc in Political Science and Public Administration

Professional Experience:

Dexone Corp - Cary, NC Jul’14 – Nov ‘15

Oracle Database Administrator

Responsibilities:

Production support database on 9i, 10g and 11g versions with standalone and RAC environment.

Supported database platform are Solaris 10 and AIX 5.3.

Migrated databases from oracle 10g on Solaris 10 to oracle 11g on Linux on development, integration and production environment

Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.

Installation, configuration, maintenance and tuning of Oracle RDBMS 10g -12c in Production, QA, and Test environments as well as 10g Forms and Reports and 10g-11g Application Suite.

Oracle Database Upgrades 10g to 11g, 11g and 11gr2 to 12c.

Migrating and consolidation of 11g databases into 12c in both QA and Production environments.

Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning.

Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.

Creation and configuration of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments.

Upgraded databases from 9i to 10g, 10g to different 11g versions.

Worked on Auditing and security with Oracle databases.

Monitor and Configured Oracle 10g databases using OEM.

Worked with Flash Recovery Area.

Created and Managed user, table spaces, data files and archive log

Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.

Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.

Communicate and coordinate with Oracle using My Oracle for major database issues/ problems

Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.

Worked on oracle Public and Private Database Link.

Applied client patches and other patches as required.

Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, ASM, Datagaurd, Oracle Streams, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM,

Interstate Batteries - Dallas, TX May’12 – June’14

Oracle Database Administrator

Responsibilities:

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and Oracle 11g (11.2.0.3)

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Achieved optimized performance for the databases by rebuilding indexes, implementing portioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes.

Loading data from flat files to database using SQL*Loader, External Tables.

Used TOAD for database management.

Made optimal use of Oracle Support in resolving the SRs.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, Datagaurd, Oracle Streams, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Chase Paymentech Dallas, TX Jan’11 – April’12

Oracle Database Administrator

Responsibilities:

Install oracle database software 10.2.0.1 and 11.1.0.6.0 using oracle universal installer on development, test and production server for their claim, policy and online applications in IBM AIX 5.3 environment.

Install OEM grid control that includes oracle agent, management repository and management service on VMware Red Hat Linux virtual machine. Install agents on various AIX database servers.

Upgrade software and databases from 10.2.0.1 to 10.2.0.3, and 10.2.0.3 to 11.1.0.6.0 on development; test and production databases on AIX database servers. Apply patch set to upgrade software and use database upgrade assistant, export/ import and manual scripts to upgrade databases.

Migration of full 10.2.0.3 databases, schemas those are on Linux environment into AIX, 10.2.0.3 database environment using export/import and data pump utility.

Create development, test and production databases using database configuration assistant- DBCA, manual scripts and sqlplus using Automatic storage management- ASM.

Database performance tuning using AWR, ADDM, ASH, sql tuning advisor, explain plan, statistics, blocking sessions, STATSPACK, TKPROF, sql query restructure and sql trace.

Schedule cronjob for daily night hot/online backup of production databases on tape using RMAN scripts.

Refresh or restore development, test and reporting databases from production database backup using RMAN scripts or export/ Import and data pump utility.

Schedule a cronjob and create lots of shell script in Unix environment like backup and restore of databases, update statistics, export and import of tables, log file maintenance, cleanup archive logs, startup and shutdown databases, email logs and alert to users, mount point space check, tablespace size check and business related activity like automatic bill payment, check generation, bill generation and many more.

Created physical standby database on remote server to provide high availability.

Environment: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, Oracle 10g/11g, AIX 5.1, 5.2, 5.3

SWIFT&COMPANY Greeley,CO May’09 – Dec’10

Jr. Oracle Database Administrator

Responsibilities:

Estimating table sizes, table spaces.

Created database objects like tables, tablespaces, buffer pools, indexes and views.

Performance monitoring and tuning.

Analyzing tables and indexes for performance tuning.

Creation, maintenance, backups and restoration of databases.

Creation of logins and user ids and setting up privileges and procedures for protection of data

Monitored and tuned rollback segment, temporary table space, redo log buffer, sort area size.

User creation with proper roles and privileges.

Responsible for integrity and concurrency of data.

Developed extremely complex SQL queries.

Analysis and Designing Database.

Create a PL/SQL function, stored procedure, package to support reports.

Refreshing and manipulating data in tables using PL/ SQL procedures.

Written stored procedures, functions and triggers.

Testing, Debugging and Documentation.

Environment: PeopleSoft HRMS/HCM 8.8, EXP, IMP, Data pump, Oracle 9i/10g, Sun Solaris 2.5

Contact this candidate