STANLEY ENOH

ORACLE EXADATA DBA / LINUX ADMIN

add5iq@r.postjobfree.com

850-***-****

Professional Summary

* ***** ** ********** ** an Oracle DBA, Golden Gate DBA and Database Security Specialist having hands on experience in Database administration, lINUX, Production support, Oracle Exadata, Installation, Configuration, Upgrades, patches, performance tuning, backup and recovery, database security, oracle advanced security, cloning with TDE, migration, shell scripting and documentation in high-availability environments such as Human services, Retail, Healthcare, Strong experience in RAC installation, configuration and administration Excellent experience in Installation and configuration and upgrade of Oracle 19c,18c,13c,12c,11g and 10g, in UNIX/LINUX and Windows environment

Experience in performing all forms of recovery at times of necessity Design and implement backup and recovery including disaster recovery structures. Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN. Experience in installing and configuring ORACLE ENTERPRISE MANAGER of all versions PROFESSIONAL EXPIRIENCE

Oracle America Jan 2017 to present COLORADO SPRINGS CO SR software engineer

• upgrading exadata systems by applying yum update on both exadata db and cell nodes for exadata customer all over the world

• extensive expirience in appplying bundle patch to rdbms homes and upgrading grid infrasturue from 11g all the way to 19c

• massive expirience in upgrading ibswitches from 2.1.3-4 al the way 2.2.12-2 by loading the firmway and using patchmgr tool

• Hands on experience in taking Export and Import dumps for Pluggable databases in Oracle Exadata Servers.

• Instance addition and removal of 8 node clusters using DBCA silent method in Oracle 12c RAC.

• Installed and configure OEM for exadata customers all over the world

• Experience in supporting Production Oracle Exadata clusters while On-call rotation.

• Configured TDE wallets in more than 500+ multitenant container databases and worked on various TDE troubleshooting scenarios.

• Configured TDE wallets like Password based and Autologin wallets and have done the conversion as well.

• Hands on experience with encrypting the tablespace data using AES 256-bit encryption.

• Involved in analysis and tuning of SQL queries by using EXPLAIN PLAN for faster and better performance of the SQL queries.

• Worked on solving issues issues/gaps between primary and standby databases in data guard environment with Transparent Data Encryption.

• Worked extensively on Golden Gate features like heartbeat, trail file encryption and credential store.

• Performed tasks related to TDE in Primary and Standby Production Databases and making sure they are in sync.

• Identifying and fixing various ORA errors and raising SR to the Oracle support team when required.

• Worked on Backup Strategies for the databases ranging from Gigabyte to Terabyte.

• Defined user security by creating views, granting roles and privileges.

• Experienced in automating DBA tasks for prechecks using shell scripting. Good experience with cloning EBS application / database tier Applied quarterly patch to EBS homes home running on exadata environment Perform EBS database upgrades

• Performance tuning and testing stored procedures, indexes and triggers using SQL execution plan.

• Database performance monitoring through OEM and by generating AWR report.

• Managed and configured Oracle Data guard 12c Physical Standby database on Oracle Exadata servers.

• Experienced in configuring Golden Gate for replication between Oracle Databases.

• Monitoring Health checks of OCR, VOTING DISKS for better performance and troubleshooting issues in Oracle RAC 12c environment.

• Generated health reports and monitored statistics for performance tuning of the database using AWR.

• Providing 24X7 on-call support for all the production and development databases.

• Generating of AWR report for database tuning.

• Have automated Advanced DB security task using shell scripting to know whether a database has been encrypted or not.

• Handling all day to day Problem tickets, Work orders, Change requests with in SLA.

• Extensive use of AWR and various other tools in analyzing slow SQLs.

• Hands on experience with Tuning of SQL and improving the SQL query performance for few applications where we had performance issues.

• Configured multiple Golden gate unidirectional setup using farm servers. It includes options for Encryption, heartbeat tables and obey files.

• Monitoring health of the databases which have been included in the availability group and fixing issues if any. IBM SEP 2011 TO DEC 2016 COLUMBIA,MO

ORACLE DBA

• Administered and supported 1000+ production databases for various IBM customers all over the states

• Worked on 11g/12 Real Application Cluster (RAC), Configured and Troubleshooting Real Application Clusters

• Involved in Patching & Upgrading databases from 10g version to 12c versions

• Experience in creating local/global users and roles in 12.2 multi-tenant architecture

• Knowledge of the features of the multi-tenant 12.2 architecture

• Have good experience in configuring OEM 12C cloud control and have hands on experience in monitoring databases using OEM 10g/11g

• Cash Management UMX transition. Implementation of Oracle GRC modules AACG & PCG for access and provisioning

• Oracle GRC suite to help avoid and manage future compliance issues. Setup encryption and secured credit card processing in the EBS. Encrypted credit card information. Secured access to credit card numbers and information. Implemented audit tracking to fill gaps in human capital and satisfy SOX compliance

• Configuring TDE wallets for container databases on Oracle Exadata servers.

• Provided DBA Administration and support for SAP databases (Dev, QA, Pre-Prod, Production) in SAP Basis environment for Oracle databases.

• Hands on experience in converting the character set of a database by using CSSCAN and CSALTER

• Installed Oracle Linux 6.4 and Oracle Virtual Machine (OVM) 3.2.6 Server and Manager along with Oracle RAC Database templates.

• Experience in migrating databases from Non-ASM to Automatic Storage Management (ASM)

• Implemented disaster recovery by using Data Guard for Single instance and in RAC environment and troubleshooted issues in DATAGUARD environment.

• Expertise in solving the issues with Database links.

• Worked on various troubleshooting scenarios related to TDE.

• Implemented RMAN restore and refreshes from Production to UAT environments

• Expertise in refreshing the UAT environment from Production backup using Export and Import backups

• Expertise in EXPDP/IMPDP in restoring tables/schemas/entire database.

• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports

• Performed Block Recovery and Data file recovery using RMAN.

• Performance tuning and testing stored procedures, indexes and triggers using SQL server profiler, execution plans and Data Tuning advisor.

• Day to day activity of Monitoring maintenance plans, scheduled jobs and Database health check in SQL Server

• Support and build virtual environments ranging from source code restricted environments, DevOps virtualization pools using Oracle Virtual Machine.

• Experience in troubleshooting and fixing the Oracle database backups on ZFS

• Scheduled Oracle Backup and maintenance Jobs using AUTOSYS

• Hands on experience in performing replication on 11g Oracle databases to 12c databases using Golden Gate.

• Configured Golden Gate for replication between Oracle Databases. Used for Reporting, Setup Architecture, installed servers, setup replication tasks.

• Setup Golden gate in RAC environment for near zero down time strategy and for replication purpose

• Hands on experience on Oracle Golden Gate tool including creating multiple extracts and replicat's, troubleshooting performance for high availability of replicated data

• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE Data guard.

• Configured Data Guard Broker and registered, maintained primary and physical standby databases.

• Involved in Creating user accounts, Roles and Granting required access permissions and privileges to the database based on the applications they are accessing

• Hands on experience in solving the issues with locks, blocking sessions by finding the long running or blocking SQL by killing the session or rolling back the SQL

• Worked on issues related to System Change Number (SCN) caused by database links between the productions and non-production databases EDUCATION

Advance level certificate

SQL certificate

Oracle certified Associate

CDT exadata database machine

Personal Skills:

Very good Communication Skills.

Good in doccumentation

Ability to work under pressure.

Time Management.

Self-learning

Contact this candidate