Data Oracle

SKILL SUMMARY

Proficient experience as an IT Database Professional with over 6years plus experience in oracle database administration and postgreSQL database. Proficient in Oracle 11g R1, 11g R2, 12c, 18c and 19c. Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing.

Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM).

Regular Proactive Health Checks for all the Oracle and PostgreSQL Databases through my automated shell scripts.

Managing/Building Standby (Slave/Replication) Servers for all the PostgreSQL Databases as requested by the Application Teams based on criticality of the Applications.

Monitor Database Performance, CPU Utilization and Memory Resource Utilization.

Monitor the Sessions and the Database Activity and identify Sessions causing Contention and work on the Root Cause Analysis.

Monitoring Space Utilization and Tablespace Usage and Table Fragmentation.

Managed Backups/Restore of PostgreSQL Databases using pg_dump/pg_restore and pg_basebackup.

Worked with DEVOPS and agile environment.

High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.

Lots of hands 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.

Performed database administration for production and development support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on 10g, 11g and 12c oracle databases.

Installed and Administered Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.

Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA).

Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.

Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.

Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.

Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.

Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.

Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose.

Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.

Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases.

Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.

Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control

TECHNICAL SKILLS

Databases: Oracle 12c, Oracle 11g, Oracle 10g, Postgresql

Oracle Database Tools: SQL*Loader, OEM, Toad, TKPROF, EXPLAIN PLAN, AWR, ADDM,

ASH, Exp/Imp/Data Pump, AWR, DBCA, DBUA, Oracle Migration,

Grid Control

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

EDUCATION

University of Buea

Bs in Computer Science

Oracle certified associate 12c

AWS Solution Architect Associate certified (SAA)

PROFESSIONAL EXPERIENCE

Quintiles Transnational - Charlotte, NC

July 2014 – March 2020

Oracle Database Administrator

Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).

Implementing Oracle 11g & 12c RAC for mission critical Application & Databases.

Oracle 11g &12c RAC Database administration, configuration and maintenance.

Managed Backups/Restore of PostgreSQL Databases using pg_dump/pg_restore and pg_basebackup.

Managed PITR (Point-In-Time-Recovery) during Disasters for PostgreSQL Clusters.

Regular Proactive Health Checks for all the PostgreSQL through my automated shell scripts.

Creation of physical standby DR, logical standby reporting databases, active dataguard & snapshot standby.

Deploy the Database Objects requested by the Application Team.

Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the cronjob periodically in regular intervals.

Created indexes to facilitate easy user interface implementation and tuning.

Creating & Managing Database Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles and Privileges.

Monitoring Day-Day Backups, Log's & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.

Experience in Backup & Recovery using RMAN which includes hot backups and Cold backups.

Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.

Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.

Installed and applied various patches which include Critical Patch Update (CPU), Patch Set Update (PSU) and One-off patches using opatch and runinstaller, also involved in upgrading oracle database 10g to 11g and 12c.

Experience on working with data guard physical/logical standby databases.

Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.

Database Refreshing / Replication from production to testing using Exp/Imp.

Highly experience in migration oracle databases and PostgreSQL to both EC2 and RDS in the cloud.

Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.

Provided maintenance of user accounts, privileges, profiles and roles.

Experience in implementing security in AWS using IAM.

Involved with OLTP relational databases system analysis, design, implementation and management.

Upgrade/Migration of Databases from Oracle 10g, 11g, 12c, 18c and 19c Cross platform migration from different platforms.

Administered (11g RAC) environments adding and removing nodes to the cluster.

Extensive experience using SNOWFLAKE to clone database from PROD to DEV.

Supported off-hour on call support for database related issues.

Ensuring load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.

Created logical and physical design installed and upgraded databases.

Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements.

Reorganized data files identified and eliminated contention factors like I/O, buffers and locks.

Allocated the separate rollback segments for the Batch processing jobs in order to speed up processing.

Extensive experience using ETL tools such as SAS Business Warehouse and Oracle Warehouse Builder

Reorganized data files, identification and elimination of contention factors like I/O,

buffers and locks.

Configuring PostgreSQL Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, PEM, SolarWinds.

Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.

Responsible for all backup, recovery of PostgreSQL databases using BART and pg_dump.

Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.

Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside the database environment

Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.

Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters.

Installation and configuration of Oracle database 11g on various OS.

Monitoring key performance indicators to ensure that continuous improvement efforts result in defect. reduction, increased margins and overall efficiency within the process.

Moving of objects across databases using Data pump, Export and Import, partitioning of tables for performance.

Data refresh from production to test and development, Performed Hot and Cold Backups using shell scripts and written nightly scripts and scheduled using CRONTAB.

Administration of ASM addition, dropping disks Rebalancing.

Testing RMAN backups quarterly, Creating the duplication database using RMAN backups

Perform PSU and CPU patches and upgrades on oracle versions from 12c,18c and 19c.

Extensive experience in migrating data across heterogenous platform between oracle and SQL Server and MYSQL platforms.

Experience with installation, configuration & administration of Oracle Golden Gate replication utility, working with configuration/administration/managing systems & databases.

Ability to design, developing, testing and deploying web applications on AWS S3.

Hands-on experience in using AWS command-line in LINUX, WINDOWS, Some experience with AWS Cloud control.

Some experience in configuration of Ansible.

Some experience in managing SQL Server databases.

Created Oracle Wallets and implemented Tablespace level TDE security.

Experience in using Oracle Golden Gate to replicate data from oracle to PostgreSQL.

Upgrade Oracle Golden Gate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments.

Configuration and Administration of data guard for Disaster recovery (Physical, Logical and Snapshot standby).

Installed and Configured OEM grid control for maintenance administering the databases.

Contact this candidate