Sign in

Manager Oracle

United States
November 30, 2018

Contact this candidate



Oracle Database Administrator

Phone: 240-***-****


Willing to relocate: Anywhere

Authorized to work in the US for any employer (Green Card Holder)

Professional Skills

5+ years of hands-on experience in different Database technologies with a bias in Oracle Database Administration. Managed and supported databases in across full system development life cycle.

Hands on experience in Oracle 10g/11g/12c. Support both single instance and RAC implementations. Administration duties include Oracle Clusterware setup, RAC installation using ASM and Grid Installation.

Good experience RAC Clusterware administration, Configuration and Patching Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.

Migrated databases from Non-ASM file system to ASM file system using RMAN.

Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation

Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.

Implemented various backup strategies for Large / Medium sized databases sing RMAN

Worked extensively on Cloning /Duplicate of databases using RMAN.

Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.

Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.

Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

Experience with SQL coding including DDL, DML and fine tuning those sql's for better performance.

Good knowledge v$ performance views and command line skills to identify information about sessions, wait events, system performance etc

Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and also identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.

Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.

Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 6.x for Clustered Environments.

Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.

Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.

Extensive experience in designing Logical and Physical data models for new developments using ERwin modeler.

Experience in using 11g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 11g&12c Grid Monitoring.

Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.

Excellent Experience in installing and maintaining Oracle Dataguard to implement physical Standby Databases for Disaster Recovery.

Experienced in Installation of high availability RAC environment (2, 3, 4 and 5 node clusters) and upgraded standalone databases to 11g RAC environment.

Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump & Transportable Tablespace (TTS).

Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for Oracle database.

Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, SQL-Backtrack, VERITAS Net Backup.

Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.

Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.

Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.

Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).

Used TKPROF utility and Explain Plan for tuning SQL queries.

Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.

Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database.

Installing Oracle patches, Migration of database across releases.

Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

Expertise in loading data from flat files using external tables, SQL* Loader.

Experience with SQL, PL/SQL, UNIX Scripting.

Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.

Excellent analytical, problem solving, communication and interpersonal skills


University of Buea – B.Sc. Management: MBA (Hons) Management

Mountain Computer Training Institute, Buea. Diplomat in Computerized Accounting

Technical Proficiencies

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.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000


Oracle 10g, 11g, 12c


SQL, PL/SQL, Shell Scripting


TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

Professional Experience

Universal Cargo Services - Los Angeles, CA Feb 2015– Present

Oracle Database Administrator

Day-to-day usage of Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EMGrid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others

Usage of enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging, Redo Log reduction on GTTs using temp_undo_enabled.

PeformLOB Compression, SecureFile and Deduplication in a cost-saving effort

Implementing Best Practices for migration regular databases to Oracle Exadata

Resolved/Diagnose Node Eviction issues.

EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.

Experienced in configuration of ASM for RAC and NON- RAC environments.

Configured Repository and clients for GRID Control and also implemented DB Control for some databases.

Utilized Oracle streams to Capture, Propagate and apply the transfer of data, transactions and events within managed Databases.

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.

Test backups periodically to ensure minimal recoverability time to meet business objectives.

Used cross platform transportable table space (TTS) to transport table spaces across platforms.

Data Refresh in Test and Integration Databases using Transportable Table spaces.

Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.

Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.

Performed patching on Oracle Database Server 10g and 11g using O patch utility.

Implemented Data Guard, Physical Standby database in 10g and 11g RAC environment for the Production databases for Active and Passive cluster.

Implemented Oracle database 12C RAC databases using Oracle Clusterware for achieving high Availability.

Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc

Redefinition of tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace

Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.

Implemented 11g Interval Partitioning for monthly partitioning of large tables.

Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.

Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.

Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.

Designed and implemented different backup strategies like Cold, Hot, RMAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.

Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.

Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.

Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup and Comm vault.

Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC& 12C environment for the Production databases.

Configured and managed Data Guard extensively for Production databases of sizes ranging from 50GB to 2TB.

Experiencing in Installing OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.

Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.

Migration of databases to 12C from Oracle 10g&11g.

Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes. Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

Also worked on Network data encryption to improve the security and also implemented SSL wallet to secure the connections.

Database Services creation for distributing the applications across multiple nodes, Extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,

Experienced with ASM, adding, deleting disks to the disk group.

Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.

Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.

Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries

Tools Used: Oracle RMAN, Oracle 11g (, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Caresource - Dayton, OH June 2012 – Feb 2015

Oracle Database Administrator

Cloned/Migrated databases using RMAN and traditional Datapump export/ import utilities in Oracle 10gR2.

Worked on disaster recovery of exadata dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.

Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.

Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.

Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.

Performed troubleshooting of database using AWR and ADDM reports.

Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.

Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually

Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.

Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

Installed Oracle and grid software on standalone servers on ASM and file system.

Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.

Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.

Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.

Applied patches and,

Tools Used: Oracle, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Contact this candidate