Resume

Sign in

Manager Oracle

Location:
Lanham, Maryland, 20706, United States
Salary:
85K
Posted:
March 09, 2019

Contact this candidate

Resume:

Queendoline Meme Nfor

Email: ac8qbs@r.postjobfree.com

Phone: 202-***-****

PROFILE

Oracle Certified Associate with 6 years of focus on Oracle Database Administrator, had experience on database administration, project and production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting, documentation and maintain database solution for complex business needs using wide selection of technologies like oracle RAC,ASM, Dataguard, goldengate and enterprise manager grid control.

Professional Skills

Extensive hands on experience in Oracle database 10g, 11g and 12c, proficient in maintaining and managing large scale database environment and mission critical large OLTP and OLAP systems.

Eliminated months of production server issues by systematically troubleshooting and resolving the problem with no further downtime.

Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning using tools like AWR, ADDM, EXPLAIN PLAN, ASH, SQL TUNING ADVISOR, TKPROF,SQL TRACE OEM grid control 12c and command line

Extensive experience maintaining, enrolling users, system security, controlled and monitored user access to the database, operating 24/7, with 40-50 concurrent users at any given time

worked on ASM redundancy, Managing ASM disk failures & replace failed ASM disk with a new disk

Monitored resource utilization from both database and O/S level making suggestions for upgrades for software and hardware (memory, CPU, disk) which resulted in higher overall system performance.

Supported up to 100 databases and applications, including development, test, and production servers, loading initial, upgrades, and software patches. Products include Oracle Enterprise Manager, SQL, PL/SQL, Recovery Manager, Oracle Data Pump, and Oracle Partitioning. Analyzed all database updates to insure integrity of database design, performance, optimization, and security.

Have worked in Oracle 10gR2 and 11gR1, 11gR2 (11.2.0.1, 11.2.0.2),12c and worked interchangeably across multiple O/S platforms (AIX, HP/UX, Sun Solaris 8,9,10, Linux Redhat 5,9 and Windows 2000+ servers supporting 100s of schemas to prevent and/or fix 1000s of production problems

Have upgraded oracle databases from 10g to Oracle 11g and Oracle 11g to Oracle 12c using DBUA and scripts on Linux red had 5.9 server

Performed on-call duties 24x7 consistently over 6 years

Highly experienced in all the phases of Software Development Life Cycle (SDLC)

Most recently supported Oracle 11g RAC database projects, mission-critical HA using ASM disk groups, RMAN backup and recovery alongside primary and physical standby disaster recovery configurations on Linux Red Hat platforms. Solid Experience utilizing Oracle EM Dbconsole and Oracle Enterprise Manager Grid Control NGUM JUDE NFOR

ac8qbs@r.postjobfree.com

301-***-****

Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g RAC environment.

Proficient in setting up Standby Database using OEM grid control and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD, configure datagaurd broker for switchover and failover

Ample knowledge on working with AWS services such as IAM, S3, EC2, RDS

Implemented Goldengate integrated capture and coordinated replicat (available from OGG 12c) to improve the performance of data replication to targets

Managed Oracle GoldenGate installation, configuration, troubleshooting abend, and performance issues.

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.

Proficient in Logical backups/database migration using DATAPUMP, load data using SQL*LOADER

Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL*LOADER

Refreshing Dev and Test instances with data from Production on a regular basis using TTS,DATAPUMP and cloning, perform database Security using auditing and TDE

Good experience of creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.

Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user Tablespace across Oracle databases.

Experience in applying security patches to the databases, Data Migration using datapump and export/import.

Management of Objects, Schemas, Partitioning the tables and Indexes Work experience:

Oracle Database Administrator:

July 2014 - present

CIGNA Health Insurance-Wilmington, DE

Performed daily DBA activities, including database backup and recovery, testing, and performance monitoring and tuning, refreshes, Rebuilding of Indexes, if bulk load of data is inserted, Perform database health check.

Queried databases using SQL and PL/SQL and server scripts to verify data integrity

Completed a 2-month temporary duty assignment providing 7x24 on-call DBA support for production databases, responded to trouble calls from multiple production database sites throughout US

Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning using tools like AWR,ADDM,EXPLAIN PLAN,ASH,SQL TUNING ADVISOR,TKPROF,SQL TRACE automated via OEM grid control 12c and both command line

Implemented Oracle ASM 12c software installation and configuration (Grid Infrastructure) and partitioning Disks in Linux.

Supported up to 100 databases and applications, including development, test, and production servers, loading initial, upgrades, and software patches. Products include Oracle Enterprise Manager, SQL, PL/SQL, Recovery Manager, Oracle Data Pump, and Oracle Partitioning. Analyzed all database updates to insure integrity of database design, performance, optimization, and security.

Eliminated months of production server performance issues by systematically troubleshooting and resolving the problem with no further downtime

Extensive experience maintaining, enrolling users, system security, controlled and monitored user access to the database, operating 24/7, with 40-50 concurrent users at any given time

Developed, tested and maintained a Disaster Recovery plan proving beneficial using DataGuard Broker in 11gR2 environment between multiple data centers

SUN PRODUCTION CORPORATION

SALT LAKE CITY, UT

APRIL 2015---AUG 2018

/PL/SQL DEVELOPER

DEC

Successfully designed and developed a backup/recovery strategy and procedures for several Oracle database instances, such as RMAN incremental level 0, incremental level 1, incremental updated, incremental differential, incremental cumulative following company SLA, PTO and RTO.

Most recently supported Oracle 11g RAC database projects, mission-critical HA using ASM disk groups, RMAN backup and recovery alongside primary and physical standby disaster recovery configurations on Linux Red Hat platforms. Solid Experience utilizing Oracle EM Dbconsole and Oracle Enterprise Manager Grid Control

Managed and set up database security, access control, using standard, fine grain auditing and TDE

Modified scripts to provide reports as to health of databases and provided reorganization information

Migration of database from one server to another server with zero downtime using Oracle Golden Gate.

Setup and maintain documentation, Create database objects

Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems

Implemented Data guard, creating physical standby databases in 11g RAC environment for production database.

Resolve Performance issues by tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms, tune all Oracle instance components including SQL and PL/SQL

Installed, Configured and Administered Oracle Golden gate to replicate table data between databases

Patch database for security and bug fixes using Opatch utility for applying patch set Upgrade (PSU).

Troubleshoot archivelog Gaps between the primary and standby database using RMAN incremental backup and manually by copying the logs across without down time.

Completed a 2-month temporary duty assignment providing 7x24 on-call DBA support for production databases across the globe; responded to trouble calls from multiple production database sites throughout US

Monitoring and administration of databases using OEM 12c Cloud control 12.1.0.4.

Using Oracle DataPump utility making faster exports/imports using Network_link on large databases

Support application performance issues using 12c Cloud control / AWR / ASH / ADDM / Traces.

Install, upgrade Oracle Enterprise Manager (OEM) 12c.

Manage Oracle Real Application Cluster (RAC) for Oracle 11g R2, apply Oracle Security Patches to adhere to the security policy.

Loaded spatial data into database using SQL Loader and creating spatial Indexes.

Optimized the queries, tuning of SQL statements using tools like Explain plan, Auto trace, Tkprof, Sql tuning advisor, DBMS_PROFILER, made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes

Create and Configure new 12C pluggable databases (PDB's) using DBCA.

Worked on Database Upgrade from 11.2.0.3 to 12.1.0.1 using DBUA.

Migrated Non Container databases to 12c Pluggable databases.

Upgraded 11g databases to 12c standalone and container database

Utilize Oracle Universal Installer (OUI) support

Set up oracle goldengate integrated capture for automatic dependency awareness of dynamic load balancing with the aid of parallelism

Upgradation of Grid Infrastructure and Oracle Database from 11.2.0.2 to 11.2.0.4 on 3-node RAC environment

Migration of database from one server to another server with zero downtime using Oracle Golden Gate.

Implemented Data guard, creating physical standby databases in 11gRAC environment for production database.

Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate.

Used Goldengate for configuring online change synchronization between the source and target database using Datapump.

Increased performance of Goldengate by using range parameter and multiple threat replicat processes.

Successfully configured and installed Oracle GoldenGate for Schema/Table replication.

Configured DDL Replication in GoldenGate to enable DDL Synchronization.

Troubleshoot GoldenGate erroneous Skipping Transactions using LOGDUMP utility.

Configured Integrated Extract & Integrated Replicat as a substitute to conventional Classic mode to increase the performance.

Used Convchk Utility in Goldengate to repair the corrupted Checkpoint Table.

Improved performance of replicat by using Batch SQL Parameter & Max Transops parameter to split the transactions.

Performed regular system Upgrades and applied latest patch sets to all Oracle Enterprise servers, piloted all changes in a controlled environment prior to deployment.

Periodic validation of oversized indexes and index rebuild when required.

Recommendations for SQL statement tuning for SQL statements that are identified as impacting production performance.

Good communication with excellent analytical skills, willingness to learn and improve and ability to work within a team and independently.

Environment: Oracle Linux 6 & Red Hat Linux 5.0, Oracle 10g,12c and 11g, GoldenGate, Oracle Enterprise Cloud control 12c, RMAN,11g RAC, Active DataGuard, ASM, TKPROF, Explain plan, AWR, ADDM, remedy, SQL* Plus, PL/SQL, SQL* Loader.

Oracle Database Administrator:

June 2012 – July 2014

Weis Market Inc-Sunbury, PA

Responsible for administration and supporting Oracle 11g and 12c databases.

24x7 Production database administration, support and monitoring to ensure a proactive problem solving.

Experienced in generating statistics of databases using ADDM in OEM 12c.

Installation and configuration of 11gR2 3-node RAC. Upgrades of prior versions to Oracle latest release.

Build Oracle Real Application Cluster (RAC) systems over ASM for the clients.

Maintained and enhanced the scripts used for Oracle RAC/non-RAC installation.

Implementation and Setup of Physical standby databases, DataGuard and provide support for Oracle Dataguard implementation for Disaster Recovery

Worked in setting up the Dataguard broker for automatic failover and switchover by enabling Fast_Start Failover

Experience in implementing 12c new feature, Fast-start Failover (FSFO) setup in Data guard as a solution to High Availability.

Applied Latest PSU Patches (11.2.0.4.6) on Physical Standby Databases.

Configured replication of Tables using Goldengate.

Performed Initial Load of Database replication using Goldengate.

Worked on Goldengate Replication failures and Initial Data Load issues.

Implemented Oracle Advanced Security options such as data encryption for data privacy.

Performed Patch set updates, CPU patches on RAC Databases to minimize the security issues and provide bugs fixes.

Unix Shell scripting for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.

Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Worked actively in planning for storage space requirements and placing them for optimum I/O performance.

Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption).

Monitored databases, set threshold and alert using OEM grid 12c for tablespace usage

Configured and implemented Oracle 11g Active Data Guard for Database Disaster Recovery use Data Guard broker

(DGMDRL) to automate switchover and failover

Implementation database maintenance by ensuring database Security, creating Users, Roles and granting Privileges

Restore and recover databases from file system backup in order to bring database to the original state as per the business and user requirement.

Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM

Installed, configured and maintained Oracle Databases and Applications

Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Meta link.

( GOLDEN GATE SPECIALIST)

SCOTTRADE-ST,LOUIS, MO

MARCH APRIL 2013- 2012-JAN JAN 2015 20

Implemented automated backup strategy using the UNIX shell script CRON UTILITY Technical Skills

HP-UX 11, Red Hat Linux4, Windows 2000/2003, OEM 12c, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 11g RAC, Streams, CDC, Goldengate, DataGuard, service now SQL*Plus, PL/SQL, ASM, J2EE, ToadV9.7 & SQL, Navigator V6.1.

Oracle production DBA (Internship):

Jan 2012 – May 2012

Mobile Telecommunication Network, Bamenda/cameroon

24x7 Production database administration, support and monitoring to ensure a proactive problem.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.

Used transportable tablespaces (TTS) to move the data on a different platform and also much faster than performing either an export/import or unload/load of the same data.

Assist in the Implementation of 10g Data Guard and Bi-directional streams implementation.

Use Oracle Enterprise Manager (OEM) on daily basis to observe the performance of the production databases and also set trigger for alert.

Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Implemented and followed data security standards and Security User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.

Use different backup types and strategies like hot, cold, and import/exports based on the business requirements.

Applying security patches both Server side and Client side and Performed testing.

Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Worked with production DBA team in perfect coordination with seniors and team members.

Performed database cloning to setup test and development databases.

Responsible for optimizing the queries and application tuning.

Performed SQL tuning and assist developers with coding PL/SQL.

Provided support to Application Database Administrators in designing the database Environment: Oracle database 10g (10.1.0.5 to 10.2.0.4), Redhat4, HP-UNIX 10.0, RAC, TOAD, TTS, Erwin 7.2, J2EE, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader Education:

Bachelor’s Degree in Information Technology

University of Buea

Certification:

Oracle Certified Associate (OCA)

.

BARCHELOR DEGREE IN COMPUTER SCIENCE

ORACLE PRODUCTION SUPPORT DATABASE ADMINISTRATOR

SCOTTRADE- ST, LOUIS MO

MARCH 2012



Contact this candidate