Database Administrator Oracle
Resume:
LYDIA KAMGANG
ad09gn@r.postjobfree.com
PROFESSIONAL SUMMARY:
I am an accomplished, Oracle Database Administrator. My professional experiences span over 9 years with in-depth knowledge and proficiency in Backup & Recovery, Security Implementations, Database Design, Monitoring & Tuning, Upgrades, Cloning, and Replication. I am also proficient in an assortment of technologies including Oracle 10g, 11g,12c, and 19c, SQL Dev, and OEM. I possess excellent written, verbal, analytical and organizational abilities. Ability to analyze dB Protect, Nessus and Web Inspect scans, compile daily database reports to ensure the security of the system. Also skilled at learning new concepts quickly, work well under pressure, communicating ideas clearly and effectively.
AREAS OF EXPERTISE:
Installation, configuration, capacity planning
Performance Monitoring & Tuning
Database Security & Patching
Backup & Recovery
Transparent Data Encryption (TDE)
Upgrades & Migration
Grid Control
Database Cloning
Oracle Golden Gate & RAC
Oracle Data Guard & Data Pump
Bash/Unix Shell scripting & Automation
MS SQL server
MongoDB
PROFESSIONAL EXPERIENCE
Elixir DATABASE ADMINISTRATOR Mar. 2021 – Present
Performance Tuning Experience - AWR, ADDM, ASH, SQL Tuning Advisors, STATSPACK, EXPLAIN PLAN, SQL Trace with TKPROF, TOAD.
Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and AWR snapshots and reports.
Installed Active Dataguard for data syncing between primary and standby databases.
Monitoring the database for growth and added space to the table spaces as per demand.
Applied quarterly patches in 11g and 19c environments.
Using RMAN to test and restore from point in time from one server to another.
Created and installed the RMAN recovery catalog. Holds metadata of backups in case of disaster. Can be used to restore database.
Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11g and 19c environments.
Monthly and quarterly SOX reports ran to ensure that the company is in compliance by demonstrating that the organization has met the necessary data security and financial transparency thresholds.
Database creation in MongoDB, create and manage shards, perform backup and recovery through Atlas Compass and Mongosh.
Use multiple backup methods including Mongo Cloud manager, Ops Manager, and backup snapshot depending on the appropriate environment.
Manage storage through WiredTiger
Perform overall database performance tuning through index creations.
Identifying common issues by identifying COLLSCAN and excessive CPU usage.
Part of the on-call production support team for 24/7 on-call production support.
IQ Solutions SR. DATABASE ADMINISTRATOR
Rockville, MD Feb. 2016- Mar. 2021
Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and AWR snapshots and reports.
Utilized Grid Control to administer RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
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.
Refreshing Dev and Test instances with data from Production on a regular basis.
Experience migrating database objects from development through test & into
production environments.
Installed and administered GOLDEN GATE in a unidirectional, bidirectional, and broadcast configuration to mainly replicate data and ensure high availability, in a heterogenous environment.
Worked in a cross functional team that oversaw the Oracle RAC installation & configuration for Linux environments.
Installed and configured the Oracle Golden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replication.
Part of the on-call production support team for 24/7 on-call production support.
JC Penney DATABASE ADMINISTRATOR
Plano, TX March 2012- December 2015
Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 1.
Worked on disaster recovery of exadata dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile.
Performed troubleshooting of database using AWR and ADDM reports.
Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.
Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.
Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
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.
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.
TECHNICAL SKILLS & TOOLS
Backup & Recovery using RMAN
Monitoring and performance tuning using OEM Console, Toad, SQL Developer, Grid Control, Explain Plan, AWR, ADDM
Database migration using Exp/Imp/Datapump, and SQL Loader
Oracle ASM (clusters) and RAC configuration and administration
Work with various operating systems like MS Windows Servers (2008, 2012, 2014), UNIX (Solaris 8/9/10), LINUX (Red Hat)
Oracle Data Guard installation/administration for High availability and Disaster Recovery (DR)
Oracle Golden Gate (Data Replication)
Database migration using Exp/Imp/Datapump, and SQL Loader
Oracle ASM (clusters) and RAC configuration and administration
Installation, configuration and update of Oracle 11g and 12c using DBCA
Education
Western Governors University
B.Sc. - Cyber Security
Contact this candidate