Resume

Sign in

Manager Oracle

Location:
San Jose, CA
Salary:
$55 - 60hr
Posted:
January 05, 2020

Contact this candidate

Resume:

PROFILE

I am a Green Card holder Oracle Database Administration experiences . I have worked on Installing and configuring different Oracle versions like Oracle 12c, 11g and 10g, running on different platforms including Linux, HP-UIX and Unix. I have monitored and managed databases of varied sizes ranging from 100GB to 2TB across the SDLC. I have worked for Production support on performance tuning, backup and recovery, database security, data migration, managing/monitoring databases, database/schema refreshes c lonning, data Replication. I have done Project work on Patch/Upgrade Installation, configured a Physical Standby Data guard, 2 node RAC and Golden Gate for Oracle High Availability Solutions,OPERA,PMS,MICROS and attended seminars on Data warehouse, data modeling, ETL and SQL server . Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and installing for a large-scale mainframe computer system. Maintains and develops online and batch application programs. Develops and implements a disaster recovery plan.

PROFESSIONAL SUMMARY

I have some experience in Oracle database administration in heterogeneous system environment including LINUX, Solaris, AIX and Windows.

Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.

Expertise in Oracle's Data protection, high availability, and performance technologies such as Oracle RAC, Oracle Dataguard, ASM, and Oracle goldengate.

Experience in administration and tuning of Oracle databases running on Windows and all types of UNIX platforms.

Experience in Oracle Grid Infrastructure implementation, administration, & performance tuning on ASM and implementing Third party clusterware file systems.

Experience in Dataguard for different types of Standby Databases such as Active for reporting, Physical, Logical, and Snapshot standby on implementation, administration, & performance tuning.

Experience in implementation, configuration, troubleshooting, and performance tuning of Oracle Goldengate replication between Unidirectional, bidirectional, and cascaded Oracle Databases.

Experience in Performance Tuning Oracle Databases with respect to all aspects of IT Infrastructure such as Network, OS, Storage, and Application.

Experience in using various performance tools or utilities like EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ASH, and ADDM, and analyzing reports for tuning recommendations.

Experience in implementing Oracle Enterprise Manager Grid Control (11g) and Cloud Control (12c) for database monitoring/performance/diagnostics.

Experience in implementing desired database backup solutions based on environment, affordability, and other key IT Infrastructure aspects. Experience with Oracle RMAN backup utility and in traditional hot (online/cold (offline) backups, Experience in logical backups and Database migration tools such as DATA PUMP, Export/Import, and Transportable Tablespaces.

Experience in modifying UNIX Shell Scripts for various scenarios and requirements.

Experience in upgrading Oracle Databases from 10g & 11g, to 11g & 12c.

Knowledge and experience on managing very large Data Warehouse databases.

Good in in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.

Experience in implementing Oracle Flash-Back Technology and utilizing it for various rollback purposes such as Critical Application bug fixes, Load Testing, and QA Testing.

Experience in Capacity Planning and Bench Marking.

Oracle GoldenGate experience with Installation, configuration and troubleshooting of Oracle GoldenGate 11g/12c replication setup across heterogeneous database servers and ensure data synchronization.

Experience in Performance tuning of Oracle GoldenGate Processes to achieve zero lag times.

Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.

Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.

Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPROF and OEM.

Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.

Experience in Database capacity planning, monitoring object growth and Storage Management.

Performed data migration from flat files into an Oracle database using SQL*Loader.

Experience in performing Cloning and Refresh using RMAN and Datapump.

Experience in Partitioning Tables, Rebuilding of Indexes, Secure files, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.

Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.

Experience working with database security tools TDE, DB Vault / VPD.

Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.

Experience in upgrading Oracle Binaries and databases from 10g to 11g and 11g to 12c.

Knowledgeable in EXADATA.

Expert in hospitality management and have used oracle tools such is OPERA,PMS and MICROS

Knowledge in SQL server, and performing database upgrades for SQL server databases

Knowledgeable in SQL server management studio

Good in SQL server backup and recovery techniques

Good in Microsoft SQL server 2014 and have ability to develop key performance metric.

Support IBM Db2 Data Replication for z/OS

TECHNICAL SUMMARY

OPERATING SYSTEMS:

Red Hat Linux RHEL 5.x and Windows XP

RDBMS:

Oracle 12c/11g/10g

SOFTWARE/ APPLICATIONS/ TOOLS:

DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Real Application Clusters (RAC), ASM, Data Pump (expdp, impdp), SRVCTL, SQL*Plus.

TUNING TOOLS:

SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS:

HTML, XML

AWS

EDUCATION

MBA Enterprise Development and Entrepreneurship University of Bamenda 2014

Bachelor in Computer sciences 2007 University of Yaounde

Structured Query Language (SQL) certified (SQL FUNDAMENTALS) 2018

Oracle Certified Associate (OCA) 12 c 2019

PROJECT EXPERIENCES

Abercrombie & Fitch – Columbus,OH March 2017 – November 2019

Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.

Monitoring space, wait events, locks and long operations running on the database

Implemented RAC databases and ASM, Toad, Logical and physical data modeling and demonstrated experience translating logical models into physical models, Database design in a multi-terabyte Data Warehouse environment.

Supporting day-to-day Database administration activities like creating databases, troubleshooting tablespace issue, mount point space issue, high CPU utilization, locking/blocking sessions.

Perform Primary/Standby database switch over/fail over using Flashback option.

Performance Tuning Experience - AWR, ADDM, ASH, SQL Tuning Advisors, STATSPACK, EXPLAIN PLAN, SQL Trace with TKPROF, Toad.

Monitoring the session waits for the database performance and resolving the performance issues.

Monitoring the database for growth and added space to the table spaces as per demand.

Generating AWR/statspack reports on regular basis to identify the database performance at peak load.

Tuning the SQL statement by analyzing the explain plan and ADDM reports

Implemented scripts to monitor and get information on free space, alert log errors. Provided maintenance of user accounts, privileges, profiles and roles.

Involved with OLTP relational databases system analysis, design, implementation and management.

Experienced in using 10g and 11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Control Monitoring and Recycle Bin.

Experience in SQL Loader, export/import and data pump to load data in to tables.

Upgraded Oracle 10g/ Oracle 11g R2 database version to 12c.

Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations.

Implemented the Golden Gate Replication both unidirectional and bidirectional

Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS)

Experience in Real Application Clusters (RAC), ASM, RMAN, Data Guard and maintain Standby database.

Data guard Broker configuration and Managing Physical Standby databases using Oracle Data guard Broker.

GoldenGate Unidirectional and Bidirectional replication.

Proficient knowledge in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.

Experience on working with data guard physical/logical standby databases.

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

Experienced in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Experience in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Database Refreshing / Replication from production to testing using Exp/Imp.

Created logical and physical design installed and upgraded databases.

Experience in debugging UNIX/SHELL scripts for providing the reports.

Environment: Oracle 10g/11g RAC VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Expedia – Bellevue,WA

January 2013– December 2016

Successfully installed and configured Oracle 11.2.0.3, Oracle 12.1.0.2 databases on linux platforms.

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

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

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

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on linux platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

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

Used TOAD for database management.

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

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Experienced in cloning the databases using HOT and COLD backups.

Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.

Made optimal use of Oracle Support in resolving the SRs

24 X 7 Production & Development database support and administration.

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

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.

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).

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

Documented the Standard Processes for peers to follow.

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

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

Refreshed/cloned databases using RMAN utility.

EGWE ELVIS AKEME

Email : ada7sx@r.postjobfree.com

Phone : (408) 661 - 3993

ORACLE DBA



Contact this candidate