Manager Oracle
Resume:
Queendoline Meme Nfor
Email: ********@*****.***
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
*************@*****.***
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