Resume

Sign in

Manager Oracle

Location:
Germantown, Maryland, United States
Posted:
December 17, 2018

Contact this candidate

Resume:

Jane-Bianca

Nchanji

480-***-****

ac7zvi@r.postjobfree.com

EXPERIENCE

KEY POINTS

High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.

Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).

Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 11g, 10g) for the purpose of monitoring multiple databases and application servers.

Highly experienced in using Oracle 10g features Flash-Back Recovery and Recycle Bin.

Responsible for Datacenter Migration from old Datacenter to new datacenter and Migrated and upgraded single instance database to multiple instance databases using export/import, data pump.

Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.

Configure Data Guard on both standby and primary for 45 production databases.

Fail over and switch over between standby and primary databases.

Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.

Backup & Recovery using RMAN which includes hot backups and Cold backups.

Expert in Installation, Configuration and Maintenance of Oracle Standby/Data Guard.

Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.

Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC.

Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.

Experience in Multitenant Databases (Oracle 12c Container and pluggable databases)

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

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.

Expert in RMAN backups including full, incremental and cumulative.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.

Extensively worked on Import/Export and DataPump Import/Export tools.

Knowledge in configuring ASM (Automatic Storage Management)

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.

Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, AWR and also Cluster Interconnect Tuning (RAC)

Provided valuable inputs for various performance tuning issues.

Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK SQL*Trace, TKPROF.

SKILLS

Databases

Oracle 10g, 11g, 12c

Database Tools

Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration, Remedy

Operating Systems

MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware

Storage, Sun Enterprise EMC, Dell Servers, Compaq Servers 6000/3000/1600/

800, HP/UX-9000, Red Hat Linux 6.2

June 2016 – Present

SUN PRODUCTS CORPORATION –

SALT LAKE CITY, UT

Oracle Database Administrator

Defining the standards, to maintain the health of the server. RAC to RAC physical standby configuration of data guard for Disaster recovery requirement.

Ensuring load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.

Configure Oracle Data Guard as disaster recovery approach.

Use Active Data Guard feature to offload reporting duty from production database.

Implement Oracle Golden Gate (OGG) to replicate data from front-end OLTP databases to back-end Data Warehouse systems.

Troubleshoot typical OGG technical problems, such as unique key violation and long transaction, by using GGSCI/ Log dump /discard file analysis etc.

Create database services for distributing the applications across multiple nodes by extensively using all command line utilities, such as SRVCTL, CRSCTL, ADR, and ASMCMD.

Set up test databases for development team by using RMAN duplicate tool.

Schedule RMAN backups, purge jobs, maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER and Crontab.

Support development teams for all the database-related issues and help to manage the ASM diskgroups.

Performed Replication using materialized views with a complete refresh/Fast refresh.

Development of policy and procedures as they relate to database maintenance, security and archiving.

Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.

Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.

Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.

Creating, granting and monitoring user access rights and privileges through roles and profiles.

Providing instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.

Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)

Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.

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

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

Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

Generated and automated Statspack/AWR reports from Oracle database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.

Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.

Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.

Addressed developers/testers requests to clone production databases for the purposes of testing using RMAN.

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.

Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.

Capacity planning: Allocate system storage and plan future storage requirements.

Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer.

Performing housekeeping tasks like checking log and trace files.

Performing database refreshes, migration and performance tuning of PeopleSoft application environments.

Setup and maintenance of Physical Standby Database using Data Guard Broker and active Data Guard for faster Disaster Recovery.

Installed and Configured OEM grid control for maintenance administering the databases.

Daily Health Checkup of all the Databases using Oracle Enterprise Manager 12c.

Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.

Performed full and incremental backups using RMAN for development and production databases.

Database cloning from Production to Test and Development environments.

Extensively worked on applying patches (CPU&PSU) whenever required.

Schema Refreshing of databases using normal copy method and exp/imp utility.

Cloning database and schemas using Data pump for 10g and 11g versions.

Cloning 10g and 11g databases using RMAN duplication (with and without backup).

ASM Disk storage and user Management

Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly.

Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ADDM.

Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL,database tables, indexes, Instance, memory, operating system .

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

Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

October 2012 – May 2016

BARCLAYS - DALLAS, TX

Oracle Database Administrator

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

Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Maintained the data integrity and security using integrity constraints and database triggers.

Provided 24X7support for all the production and development databases.

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 DatapumpExport/Import (Oracle 11g, 10g)

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

Successfully upgraded the databases from 11g to non CDB 12c.

Successfully migrated 12c Non CDB databases to pluggable databases.

Created Oracle Wallets and implemented Tablespace level TDE security.

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 10.2.0.2 and 10.2.0.3, 10.2.0.4.



Contact this candidate