Data Security
Resume:
Lidwina Fonmboh
**************@*****.***
Oracle Database Administrator
Skills
6+ years of experience in the field of Database Administration.
Proficient in Oracle Database Administration activities such as Upgrades, Patches and use of my oracle support.
Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access, Security and auditing
Oracle Database Administration experience in variety of different environments like HP-UX, SUN SOLARIS, AIX, RedHat Linux and Windows.
I also have some experience in SQL Server database. Using tools like the SSMS to manage and monitor sql databases.
I have experience in creating sql server databases, users and database links.
Experienced in taking backups and restoring sql server databases.
Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to RAC environment.
Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation.
Migrating and Upgrading the Databases between different environments and versions.
Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases.
Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
BACKUP, configure RMAN centralized backup for all database. Create standby database from
Active database using RMAN. Cloning of RAC to Non-RAC database using RMAN. Test & validate restore and recovery for SLA.
Responsible for all database activities such as User management, space management, database security management.
Design, document, implement, and maintain all backup, recovery including disaster recovery.
DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, tablespaces, indexing, data maintenance, user management, and maintenance and solving critical errors like ORA-600, ORA 7445.
Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts.
Setting up Oracle read only replication with materialized views and developed scripts for automating the rebuilt process of replication.
Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, creating database links, managing user groups and tuning. Applied CPU patches.
Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
Good experience in applying Critical Patch Update (CPU Patches) on Databases.
Planned and implemented Oracle 10g, 11g, 12c Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).
Patching the databases with CPU/PSU on quarterly cycles or ad-hoc needs.
Installed and configured Oracle Cloud Control and deployed agents on managed targets.
Experience with Oracle Cloud Control, Oracle Grid Control, Oracle Enterprise Manager (OEM), ASM, AWR, ADDM, Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor.
Proactive monitoring, identifying areas that need to be improved in the application and database using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring.
Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
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 Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
Experience
DELOITTE-INDIANAPOLIS,IN
January 2019-Till date
Database Administrator
Worked in an environment comprising 500 databases with the largest databases each of size 8TB.
Experience with OEM13c and upgrading from 12c to 13c.
Extensively used AWR, ADDM and explain plan for periodic performance tuning.
Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
Heavily indulged in database deployments and Data fixes using tools like myeclipse, SQL Developer, Toad and SQL plus.
Worked very closely with developers. Deploying PL SQLS and SQLs. Optimizing them to run at its best.
Monitored Goldengate using 12c Goldengate Plugin and also Goldengate Director and shell scripts for alerting GG process down alerts.
Performed periodic refreshing/cloning of production databases to development & testing databases using datapump and RMAN Duplicate database.
Database monitoring/maintenance, replication process and performance tuning are done using OEM12c and OEM13c and worked on a project of migrating from oem 12c to 13c.
Experience in handling large databases up to 8TB in size largest tablespaces and tables.
Implemented and maintained 19c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases
Installation, Configuration of ASM, RAC databases.
Migrated databases from 10g, 11g to 12.1.0.2.0 using utilities like RMAN, datapump and transportable tablespace.
Implemented replication on databases using Golden gate between homogeneous and heterogeneous databases.
Successfully performed installation, setup and creation of Primary & Standby database using dataguard to deliver no data loss with maximum availability mode.
Current project. Migrating all databases from 11g to 19c using datapump. I am lead in this project.
Creating Application Users, Database schemas, profiles, synonyms,granting privileges and roles, and creating database links and resetting of users passwords.
Implementing and taking advantage of the datapump 19c new feature for better db performance.
HANSEN TECHNOLOGY- ALLENTOWN, PA
July 2016 – December 2018
Database Administrator
Worked in an environment comprising 500 databases with the largest databases each of size 7TB.
Installed and Configured Oracle 11g (3 node RAC) CRS using ASM, 11.2.0.3 RAC (2 node cluster) using GI setup.
Upgrade/Migration of Databases from Oracle 11.2.0.2 to 12.1.0.2.0
Monitored Goldengate using 12c Goldengate Plugin and also Goldengate Director and shell scripts for alerting GG process down alerts.
Involved in the installation, configuration and extended support to Oracle 11g, 12c two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
Involved in converting a single instance database to Oracle 11g, 12c 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).
Performed Database Maintenance Tasks, Rebuilding Fragmented tables, gathering statistics, refreshing materialized views, created partition tables and maintaining index's
Enabled Flashback for database to create restore points and supporting DDL changes
Used Oracle database vault and proactively protecting application data, Created Oracle Wallet, Enabling Transparent Data Encryption, Automatic Login Enabled for Transparent Data Encryption, Setting and Resetting the Master Key, Adding and Removing Salt from an Encrypted Columns, created encrypted table spaces and backup wallet and master keys to tapes
Installed, configured Oracle database Vault and database Fire wall server and Implemented Advanced security 12c Oracle Advanced Security using TDE (Transparent Data Encryption) and Enabling Auto Login for the Keystore for cdb$root and Pluggable databases
Applied PSU quarterly on 11g/12c GRID & RDBMS homes using opatch auto and Up-gradation of 11g/12c databases and Implementing catalog backup from RMAN
Database monitoring/maintenance, replication process and performance tuning are done using OEM12c/13c.
Experience in handling large databases up to 7TB in size and largest table of size 60GB with 145 million records.
Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases
Installation, Configuration of ASM, RAC databases, Adding Services and maintaining GRID control.
Migrated databases from 10g, 11g to 12.1.0.2.0 using utilities like RMAN, datapump and transportable tablespace.
Implemented replication on databases using Golden gate between homogeneous and heterogeneous databases.
Performed replication between databases using Materialized Views and DB links from a remote database.
Successfully performed installation, setup and creation of Primary & Standby database using dataguard to deliver no data loss with maximum availability mode.
Worked closely with application teams for rolling application.
Performance tuning of Oracle instances
Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.
Installation, configuration and maintenance of Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle 11g, 10g.
Extensively used AWR, ADDM and explain plan for periodic performance tuning.
Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..
Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
Designed Logical and physical database for business transaction functionality.
Provide production support for the deployed project till it is stabilized.
Refreshing development/test database from production using Export/Import & RMAN backups.
Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.
Whitehall Holdings Inc - Cincinnati, OH October 2014 – June 2016
Oracle Technical Support Database Administrator
Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
Partitioning Tables, Rebuilding of Indexes, Secure files, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
Implemented Oracle Physical Standby DataGuard on multiple oracle 11g / 12c databases.
Configured DG Broker for easy Failover/Switchover during outages and Convert to Snapshot standby during DR test every 6 months.
Troubleshooting and fixing DG Broker configuration.
Troubleshooting and Fixing out of sync Oracle Physical Standby DataGuard using RMAN incremental backup.
Upgrading Oracle databases from 11.2.0.x to 11.2.0.4 and from 11.2.0.4 to 11.2.0.4.5 and from 11.2.0.X to 12.1.0.1.
Quarterly PSU patching on AIX/RHEL for 11g/12C databases on Standalone and RAC DB's using rolling patching.
Applying/Rolling back one-off patches to/from Standalone or RAC DB's.
Loading data from flat files to database using SQL*Loader, External Tables.
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 10g 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 OEM12c.
Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting
Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.
Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
Refreshed/cloned databases using RMAN utility.
Performed Database upgrade from Oracle 10g (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
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.
Made optimal use of Oracle Support in resolving the SRs.
24 X 7 Production & Development database support and administration.
Education
Bachelor’s degree in Accounting
University of Buea
september 2013-November 2016
TECHNICAL SKILLS
Databases: Oracle 10g, 11g, 12c and 19c, Microsoft sql server 2014/2016.
Database Tools: SQL Loader, Toad, OEM Grid, RMAN,, Exp/Imp/Data Pump, Log miner, SSMS,Statspack/AWR, DBCA, DBUA, ADDM, Remedy,MyEclypse2017 and Citrix.
Operating Systems: UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX, windows, Exadata.
Contact this candidate