Oracle Database Administrator

HENRY ASHU

***** ****** **** ****** *******, CA *5742

CELL: 202-***-**** E-MAIL: **********@*****.***

WORK SUMMARY

Oracle-certified DBA with seven years of experience and extensive knowledge in Oracle database installation, configuration, administration, architecture, backup, recovery, migration, security, patching, and performance tuning. Practical knowledge in the implementation and administration of disaster recovery solution, high availability, data replication, and ASM.

EDUCATION AND CERTIFICATION

BS in Computer Science: University of Buea, Cameroon

Oracle Certified Associate (OCA): Oracle, USA

TECHNICAL SKILLS

Oracle 10g, 11g, and 12c, Performance Tuning, Golden Gate, Data Guard, Real Application Cluster (RAC), Disaster Recovery Solution, Shell Scripting, Transparent Data Encryption (TDE), SQL Loader, External Tables, Oracle Net Services, HA (high availability), Unix, Red Hat Linux, Data Pump, Transportable Tablespace (TTS), Recovery Manager (RMAN), Explain Plan, Windows, Statspack, NetVault Backup, Upgrade, Cloning, Migration, Partitioning, NID, Patching, Automatic Storage Management (ASM), SQL, PL/SQL, OEM (Cloud Control), Oracle Enterprise Manager (Grid Control), Security Management, Export/Import, SQL Developer, TOAD, AWR, ASH, ADDM, AIX, Deployment, Interpersonal Skills, Ability to Work under Pressure, Decision Making, Time Management, Self-motivation, Conflict Resolution, Leadership, Adaptability, Team player.

PROFESSIONAL EXPERIENCE

NEC, Rancho Cordova, CA US 2018-2018

Oracle Database Administrator

Play a vital role in enterprise-wide database optimization, instance, and resource monitoring. Perform root cause analysis on failures. Resolve performance tuning related issues. Implement disaster recovery solution (Data Guard) and Oracle advanced security (TDE) for data security. Work actively with features such as AWR, ADDM, and ASH, perform statistics collection, find and tune database waits for events. Provide on-call support for enterprise databases.

Install red hat enterprise Linux 7.4 in both primary and DR servers.

Performing daily DBA routines.

Tested RMAN scripts for several backup and recovery scenarios.

Installed and configured Oracle 12.x on RHEL 7.4 and 7.5.

Configuring Data guard and RMAN backup policies.

Worked on creating, upgrading, and administrating Oracle database servers.

Implementing and maintaining Oracle databases in a multi-tenant environment (container database).

Respond quickly and effectively to production issues within a giving time period.

Apply Oracle Patches and software upgrades to ensure database availability, reliability, accessibility, scalability, and security.

Administer, maintain, and implement policies and procedures for ensuring the security and integrity of the databases.

Creating and installing databases for various application implementation while tuning and designing reliability standards in stand-alone and distributed environments.

Ensure that the standby database is always in Sync with the production database by checking archive logs and copying missing ones over to the standby database when required.

Implement Oracle advance security (TDE) for data encryption.

Performed analysis and tuning, index and table partitioning maintenance.

Automated and implemented backup and recovery procedures.

Documented routine procedures, such as backups, monitoring, and architecture layouts.

Performed testing of backup and recovery procedures for newly installed databases.

Created and supported critical database systems for multiple sites using both Oracle RAC 12c and stand-alone databases.

Performed various data extractions, and ensured data integrity, wrote and maintained SQL scripts to generate database reports, to monitor database usage and security.

Performed database restoration from backups and archive logs.

DSW Inc. Columbus, OH US 2014-2018

Oracle Database Administrator

Responsibilities

Upgraded and maintained the production, training, test, and development application OLTP databases.

Installed and configured Oracle 12c and 11g on various platforms such as RHEL, Solaris and windows.

Monitored and troubleshoot all database for performance tuning purposes.

Upgraded Oracle 11g databases to Oracle 12c databases.

Responsible for seeing issues through to resolution.

Execute change request by executing SQL scripts.

Design and lead in the implementation of physical data guard for disaster recovery

Working extensively with teammates to maintain and troubleshoot any situation that may occur with the databases.

Responsible for minimizing downtimes on applications by ensuring the daily backups/exports of the database, archive logs to disk/tape systems.

Collaborate with the Linux Systems Admin in operating system (OS) Configuration, patch application, users/disk space management, tape back-ups, documentation and day-to-day operations.

Worked with team to configure and managed bidirectional golden gate replication.

Evaluate requirements and recommend available RDBMS products.

Perform disaster recovery, performance analysis and tuning, index, table partition maintenance, and monitoring of database.

Implement and maintain Oracle Data Guard Physical and Logical standby databases for disaster recovery.

Installed and configured Oracle 11g RAC databases for development, test and production environments on multiple environments.

Using Oracle Advanced Security option such Lightweight Directory Access Protocol (LDAP) -based directory service, such as Oracle Internet Directory (OID) to perform authentication.

Utilize Automatic Database Diagnostic Monitor (ADDM) to reduce DB time by diagnosing key problems such as Expensive SQL statements, I/O performance issues, locking and concurrency issues, Excessive parsing, Resource bottlenecks (including memory and CPU bottlenecks) and recommending a solution.

Performed data migration from various databases to new systems, as well as managed user accounts and privileges.

Provided technical support to the development team, and performed application performance tuning.

Provided support interface to the company's internal business unit's community,

Implemented backup and recovery procedures for on and off-site disaster recovery strategy.

Facilitated database and application tuning, interface for application testing and code walkthrough respective to integrating new or changed applications into the production environment.

Migrated the given Business unit's data (manufacturing, order management, accounts payable, and general ledger) to a relational architecture structure to provide client-server application interface.

Upgraded Oracle Grid Control server to Oracle Cloud Control in support of all Oracle installations.

OSCA, Jefferson City, MO US 2011-2014

Oracle Database Administrator

Responsibilities

Planned and implemented the system-wide upgrade of all Oracle databases from 10g to 11g

Maintaining users’ accounts which include dropping and unlocking account per requests to maintain user access compliances.

Set up and maintained backup procedures for the database using RMAN.

Set up database users, manage database permissions and setup database roles, and enable database auditing for database security.

Installed and configured Oracle 11g software on Sun Solaris version 5.10 and Oracle Linux version 5.4 operating system.

Provided troubleshooting support.

Supported development staff.

Managed and monitored Golden Gate environment for replication issues.

Provided primary Oracle documentation and support for successful Enterprise-wide Disaster Recovery exercise.

Performed user administration and database maintenance.

Configured Listener and TNSNAMES, import database, created users, granted/revoked quota, privileges, and roles to users.

Installing and configuring new Oracle 10g and 11g databases.

Contact this candidate