HENRY ASHU

ac6vxm@r.postjobfree.com 202-***-****

ORACLE CERTIFIED ASSOCIATE 11gR2 (OCA)

ORACLE DATABASE ADMINISTRATOR

Key skills:

Oracle 11g Oracle SQL Developer

Red Hat Enterprise Linux Oracle RAC Production Support Database Design Solaris

Oracle Data Guard Oracle SQL*PLUS Oracle 12c Oracle 10g Software Installation

Oracle Golden Gate Data Migration Recovery Manager Performance Analysis

Database Administration Backup and Recovery Disaster Recovery AIX Toad Data Modeling

WORK EXPERIENCE & ACHIEVEMENTS

Over 6 years of hands-on experience as an Oracle Database Administrator. I have worked in a complete Software Development Life Cycle environment. I have managed Oracle database 12c, 11g, and 10g software versions involving database administration on production support, project support, Database Software Installation, Configuration, Upgrades, Patches, Oracle PL/SQL, Data Migration, Database Architectural Design, Data Modeling, Backup and Recovery, Database Networking, Performance Tuning, Shell Scripting, Moving Data and Database Security and some SQL Server experience. Also comfortable in supporting Real Application Cluster (RAC), Data guard and Golden Gate on operating systems like Linux, Unix/Linux and Windows.

DSW Inc, Columbus, OH US 2014 to 2018

Oracle Database Administrator

Responsibilities

•Rendered effective support in the execution of database configuration, upgrade, patch migrations, backup and recovery, performance tuning, and cloning of relational databases.

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

•Performed database point-in-time recovery.

•Installed Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various vendor applications like SAP Business solution.

•Refreshing Development and Test instances with data from Production on a regular basis.

•Establish new user accounts for company employees, adhering to company's export compliance process.

•Configured GoldenGate for Active-Passive and Active-Active replication.

•Convert a non-plugable database to pluggable database in 12c.

•Documented Disaster recovery plans and participated in disaster recovery drills; monitor SQL SERVER service status, Application log, Jobs, SQL SERVER Logs, Dead locks/ Blocking.

•Involve in 24x7 on-call support for databases of 2.0 TB 3 Node production RAC databases.

•Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

•Reorganize databases and refresh schemas using Data Pump.

•Recovered database from the loss of one controlfile and all controlfiles.

•Design different databases with tablespaces, tables, indexes, setting privileges, and user logins, as well as physical databases with multiple tablespaces from logical and physical data model.

•Used Oracle 12c Cloud Control for Alert Monitoring and Notification of 10g and 11g databases.

•Created logins, users and managed security based on the minimum required access.

•Implemented TDE encryption on many databases.

•Upgrade Databases from 11.2.0.4 to 12.1.

•Performed database refresh in Test and Development environments.

•Created partitioning strategies for very large tables, while deploying range, list, hash and various sub partitions as well as structure of logical and physical database through logical and physical data modeling.

•Migrated schemas and tables using Data Pump and databases using Transportable Tablespaces and Rman Cloning.

•Restored from lost SPFILE and corrupted data block.

•Performed migration to Multitenant Architecture environment.

•Perform database resizing, tablespace management, rollback tablespace management, transaction management, and security administration.

•Monitor physical standby databases and high-volume production databases ranging to 2 TB in size.

•Resolve lock latch and resource contention issues in production databases.

•Convert classic capture Golden Gate configuration to Integrated capture.

•Design databases base on business requirements.

•Configure Dataguard and Broker for administration of seamless switchovers.

•Rebuild databases for better performance.

•Serve as an effective member of the team providing 24/7 technical support, with on-call rotation, for all production, quality assurance (QA), development and training environments, while managing multitenant databases, such as Oracle 12c Container and pluggable databases.

•Working with Application Development team to address any issues they encounter and provide support and resolution action plan.

•Act as point of contact on 12c new features, such as redaction policy, adaptive query optimization, multiple indexes on single column.

•Encrypt tablespaces using Transparent Data Encryption in production environment.

•Recovered database from the loss of one multiplex redo log member and all redo log member of inactive, active and current group.

•Used oracle GoldenGate LogDump utility to view and scan for transactions and records, obtain transaction statistics, and save data contained within OGG Trails.

•Analyze AWR, ASH and ADDM reports and draw conclusions that aid in troubleshooting performance issues.

•Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.

•Consulting to developers in improving SQL, PL/SQL codes, while generating new user accounts and executing schema and related user administrative tasks.

•Monitoring and Troubleshooting GoldenGate Replication issues.

•Served as integral part of the team that led the planning and configuration of GoldenGate for real-time replication and data guard for disaster recovery and RAC for high availability.

•Recovered database from loss of READ-ONLY and TEMPORARY tablespaces.

•Strategically utilize Oracle Enterprise Manager (OEM) for database monitoring, maintenance, replication, and performance tuning as well as Oracle Data Pump (expdp and impdp) for high-speed, parallel, bulk data, and metadata movement for all Oracle database contents.

•Usage of enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging.

•Generate and analyze EXPLAIN PLAN, SQL*TRACE, TKPROF trace files to identify root cause of SQL performance issues.

•Installed and configured 11g databases on both IBM-AIX and Linux environments using OLTP, decision support system and data warehousing environment.

•Upgrade databases from 10g to 11g, 11g to 12c using DBUA and scripts, along with 10g and 11g standalone databases to 11g and 12c 2-node RAC respectively.

•Configured Oracle 12c Enterprise Manager to keep track and generate accurate condition report for more than 246 databases.

•Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

•Implemented Oracle Data Guard physical standby database for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.

•Utilize SQL Baselines, SQL Profiles and SQL Tuning Advisor for troubleshooting and providing tuning recommendations to application teams.

•Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity and replication and indexing.

•Followed change management to performed database and SQL tuning using Tuning Pack, Diagnostics Pack, STATSPACK, SQL Trace, TKPROF, and EXPLAIN PLAN.

•Rolled out a variety of advanced security measures as per service level agreement (SLA), such as Transparent Data Encryption (TDE), data masking, and data redaction.

•Used OEM database control for single databases and OEM Grid control for multiple databases.

•Import/Export data from/to like Oracle.

•Recovered database from NON CRITICAL and CRITICAL datafile lost.

•Upgrade databases from 11g to 12c with physical standby databases in place.

•Created and scheduled maintenance plans for Backup, Index Reorganize/Rebuild, Update Statistics, Database Integrity Checks Used tools like SQL SERVER profiler to identify bottlenecks.

•Day-to-day usage of Oracle 11gR2 features, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid 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.

Above all, I have personal skills including Adaptability, communication skills, documentation skills, organizational, Leadership, Team player, Problem solving, Creative thinking and Detail oriented which have enhance my productivity in the Information Technology filed.

OSCA, Jefferson City, MO US 2011 to 2014

Oracle Database Administrator

Responsibilities

•Installed 10g, 11g, 12c, along with 12c container databases (CDB) on standalone servers and cluster on UNIX, LINUX, and Windows platforms.

•Used import export utilities for cloning migrating of small sized databases and Datapump import export to move data between10g and 11g environments.

•Launched physical standby databases on 2-node 11gR2 Real Application Cluster, while automating scripts to clear already applied archive logs on standby databases.

•Successful in applying patch set update (PSU) patches, security patches (CPU) for improving the security and functionality of the databases.

•Implemented Oracle Wallets and Tablespace level TDE security.

•Successfully installed and configured Oracle 10.2.0.5, Oracle 11.1.0.7 databases on Unix/Linux platforms.

•Optimized performance for the databases by rebuilding indexes, on tables and indexes.

•Proactively monitored databases using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

•Created different backup strategies, such as Full backup, Incremental backup both cumulative and differential backup using RMAN with flash recovery area and logical backups (expdp and impdp) and implemented backup scheduling using Crontab, Shell Scripting.

•Implement PSU patches on standalone test environment and production cluster through OPatch Auto.

•Used OEM (Oracle Enterprise Manager) for monitoring maintaining and performance tuning of database.

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

•Clone databases using HOT and COLD backups.

•Refreshed/cloned databases using RMAN utility.

•Performed Database upgrade from Oracle 10g (10.2.0.5) and to Oracle 11g (11.2.0.4) RAC database.

•Experience in implementation of databases on enterprise Storage Solutions like Storage area Networks (SAN) and Network attached storage (NAS).

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

•Upgrade multiple standalone databases and grid infrastructure from 11gR2 to 12cR1.

•Made use of DBMS_REDEFINITION in redefining and partitioning tables and columns data types, as well as placing LOBS to different table space.

•Performed hot and cold backup, recovery, and cloning of databases using RMAN with VERITAS Net Backup.

•Load data from flat files to database utilizing SQL*Loader and External Tables.

•Initiated detailed recommendations and implementation of SQL access and tuning advisors, while handling chained rows and row migration.

•Made use of SAN level storage mirroring in improving environments for the data refreshing of large production data warehouse environment.

•Migrated database from 11.1.0.7 to 11.2.0.3 using RMAN Duplicate and HOT/COLD backups.

•Automated processes like moving files, managing alert log and backup by developing UNIX scripts.

•Documented the Standard Processes for peers to follow.

•Closely worked with the Application Team in enhancing application performance.

•Refreshes database using expdp, impdp, RMAN Duplicate and cloning.

•Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

•Contributed in the migration of large size database in multiple platforms, along with the SQL Query tuning to issue tuning recommendations for application jobs, time, and CPU consuming queries.

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

•Assisted the development teams in addressing and solving all database related issues, including network failures, ASM DISK group errors, and node failures in the RAC cluster.

•Used of Oracle Support in resolving the SRs.

•Convert a single instance database to Oracle 11g RAC databases.

•Participated in the installation, configuration and managing of Oracle 11g and 10g 2 Node RAC (Real Application Cluster) with ASM file system on AIX platform.

•Assisted in configuring and installing GoldenGate, while administering pumps and trail files through removal of old extract and log files.

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

•Guaranteed proper production, security, and performance of all application design in accordance with standards.

•Managed databases using Toad.

•Tuned PL/SQL and SQL code, contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

•Provide 24 X 7 supports in administering Production & Development database.

•Analyzed the release of Oracle, tools and third-party products to secure accurate operation of products and site in alignment with client’s requirements.

•Assisted developers in writing Packages, Triggers and Indexes on the tables to improve Applications performance.

•Led the successful upgrade of databases from 11g to non CDB 12c, along with the migration of 12c Non CDB databases to pluggable databases.

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

•Administered the implementation and maintenance of Oracle 11g Data Guard and standby databases for fail-over purposes, along with Oracle TDE to deliver transparent encryption of stored data to support release of Oracle 11g R2.

•Brought significant security improvements Transparent Data Encryption

•Dispatched applications across multiple nodes by creating database services using all command line utilities server control utility (SRVCTL), cluster ware control (CRSCTL) utility, and ASM command-line utility (ASMCMD).

EDUCATION & TRAINING

BS in Computer Science: University Of Buea, Cameroon

CERTIFICATION

CERTIFICATE –

Oracle Certified Associate (OCA): Oracle, USA

Contact this candidate