Professional Summary

Certified Oracle and PostgreSQL Database Administrator over 6 years with Extensive knowledge and proficiency in Oracle 10g, 11g, 12c & 19c versions running on different operating system LINUX/UNIX, SOLARIS & WINDOWS in both development and production support across full SDLC.

Administer over 700+ databases across DEV, QA, UAT and PROD environments via use of command line and Oracle tools-Oracle Enterprise Manager Cloud 12c.

Skilled at installation, configuration, administration, backup and recovery, migration, security, patching, upgrade, RAC, Golden gate, Data guard and monitoring performance tuning.

Experience in creating databases, Tablespaces, indexes, setting privileges and user logins.

Implement the oracle golden Gate and replication for new customer between two production systems.

Install and configured Oracle Data Guard for multiple customers.

Configured Physical and Active Data Guard on 11g and 12c.

Architected the Golden gate based on HA solution.

Upgrade the oracle 10g database to oracle 11g R2.

Installation and configuration oracle RAC two node cluster.

Oracle database character set migration.

Manage production, development, and QA Database environments, including design, trouble shooting, performance and backup/recovery.

Performance tuning and analysis of DDL & DML for improvements

Deploying DDLs, updates

Apply regularly patches and update of database security.

Setup DR and HA strategy and support routine DR testing.

Understanding and experience of both OLTP and OLAP databases.

Excellent knowledge of data backup, recovery, security, integrity and SQL, PL/SQL

Database Refreshes and Cloning Using Export/Import utilities and SQL*loader.

Work Experience

Cotiviti - Atlanta, GA

March 2018 – Present

Oracle Database Administrator

Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.

Upgrading Golden Gate from v11 to 12c.

Troubleshooting Golden Gate using GGSERR.LOG and log dump utility.

Database backup using crontab and shell scripting, restore and recovery using RMAN, RTO/RPO and optimization.

Implemented fast start failover on databases and configuring disaster recovery site using DATAGUARD. Also proficient with new 11g features such as Active DATAGUARD and Snapshot standby database.

Proactively monitor the SQL database servers to ensure high performance and RDBMS optimization design.

Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two nodes RAC.

Manage large complex Oracle RAC clusters with 50+ applications.

Installed Oracle 10g,11g RAC software with ASM & ACFS File systems

Upgraded multiple Standalone and RAC databases and grid infrastructure from 11gR2 to 12cR1.

Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR and ASMCMD.

Experienced with ASM, adding, deleting disks to the disk group.

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

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.

Performance Tuning of Oracle database using OEM, SQL analyzer, Stats pack, AWR, ADDM, ASH, RDA, Explain plan, TKPROF, SQL TRACE and Ora debug.

Performed SQL Tuning using Explain Plan, TKPROF with SQL trace and STA (SQL Tuning Advisor).

Championed database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, Ora2pg, Snowball, DMS and SCT.

Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Conducts performance tuning of indexes and optimization of storage functionality & reviews database design and integration of systems.

Redefinition of tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace.

Research and configure the Oracle AS Cluster Identity Management infrastructure in a High availability environment.

Proficient in installing, configuring, upgrading, and patching all RDBMS listed above, as well as OLTP performance troubleshooting.

Experience and knowledge in migrations, database changes, enforcement of the data integrity

Upgraded databases from 11g up to 19c using DBUA & Manually.

Worked on moving data from one storage area to another.

Data transferring using Export/Import utilities and SQL*Loader.

Cross-datacenter disaster recovery and backup architecture. Performing schema management, database sizing, maintaining privileges. Data migration while upgrading database versions.

Created Oracle Wallets and implemented Tablespace level TDE security.

Also worked on Network data encryption to improve the security and implemented SSL wallet to secure the connections.

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

Created, tracked, and closed service tickets using REMEDY ticketing system and developed a defect prevention process including but not limited to root cause analysis and corrective action.

Database PeopleSoft tools creation, cold, hot and user-managed backups.

Database patches, management, duplication, migration and tuning.

24x7 remote support and on call rotation.

Care Heath - Edison, NJ

March 2014 – March 2018

Oracle Support Database Administrator

Create oracle databases (11gR2, 12c) using both the DBCA & Database scripts.

Created tablespaces, tables, indexes, set privileges and user logins.

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

Work with deployment team members to plan, review and deploy databases and database updates for applications.

User Management, creation, monitoring and management of database users. Altering passwords and granting/revoking access to system/object privileges, roles and auditing user actions.

Backed up and recovered/Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 10gR2 and 11g.

Tuned Databases and SQL Statements using OEM, AWR, ADDM, ASH, SQL TRACE, TKPROF, SQL TUNING ADVISOR, EXPLAIN PLAN.

Designed and developed analytical data structures.

Tested programs and databases to identify issues and make necessary modifications.

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

Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Researched, tested, and made recommendations of data validation tools.

Controlled all databases with high alertness to ensure peak performance, stability and reliability and availability.

Assisted developers with SQL code troubleshooting as well as tweaked applications, procedures, and SQL when necessary.

Developed RMAN backup and recovery strategies and procedures.

Implemented auditing such as standard, value-based, and fine-grained for data security.

Implemented TDE and Network Encryption as advanced security measure for data protection and integrity.

Data loading using external tables, SQL*LOADER, Logical backups using full export and DATAPUMP.

Monitor and tune Oracle database environments for improved system performance, ensure integrity and recoverability of Oracle database structures.

Day to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Forms, Reports and performance issues.

Monitoring database performance and database operation to prevent downtime and slowness of the services.

Implemented shell-scripts for automation of day-to-day activities.

Education and Certifications

Prince George’s Community College - Computer Science

Kumasi Polytechnic - Diploma in Electronics - HND

Oracle SQL Certificate

Oracle Certified Associate - OCA

Oracle Cloud Infrastructure Associate - OCI

Amazon Solution Architect – AWS

Oracle Certified Professional – OCP

CompTIA Network plus Certification

CompTIA A plus Certification

Technical

Databases: Oracle 10g, 11g, 12c & 19c

Database Tools: SQL*Plus, SQL Loader, Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Stats pack/AWR, Share plex, DBCA, DBUA, ADDM, Oracle Migration Workbench, Erwin, Remedy.

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

Francis Osei

Oracle Database Administrator

adlotg@r.postjobfree.com

240-***-****

Contact this candidate