Candidates About

 

Bright-Litandaze Amibang

QUALIFICATIONS

Education

Bachelor’s of Science, MB3 (Molecular Biology – Biochemistry – Bioinformatics), Towson University –     December 2015

 

Certifications:

·         OCA

·         Oracle Golden Gate – in progress

 

Languages

·         French and English.

 

 

 

PROFESSIONAL SUMMARY

• Well rounded production support and project support DBA.
• Working  experience in 24x7 Environments.
• Experience in Linux, Sun Solaris, IBM Aix, RHEL, OEL, Windows, and Exadata environments.
• Experience in handling Production Database Support while working on small projects simultaneously.
• Experience in handling Space related issues of  a Tablespaces.
• Administering & Managing Oracle Users, roles, privileges & creating Database  objects.
• Managing Control files, online redo logs, Archive redo logs.
• Having good Eeperience in configuring  pfile, spfile and parameter management.
• Exporting and Importing database backups using Exp & Imp and Expdp/Impdp utility.
• Configuring and maintaining RMAN to take backup of the Oracle databases.
• Performing backups using RMAN and configuring  recovery catalog.
• Experience Backups & Recovery and Cloning of Database  using RMAN.
• Great experience in Oracle database upgrade from  10g -11g-12c.
• Experience in working with ASM.
• Experience in setting up and managing oracle physical and logical standby using DATAGUARD.
• Experience managing very large databases. (Up to 160TB)
• Generating AWR, ADDM, ASH reports for database performance.
• Great experience with Oracle Golden Gate and working in Exadata environments.

 

 

 

 

WORK EXPERIENCE

 

Exelon Corportion- Baltimore, MD                                                                                       9/2017 – Present

 

Title – Production Support LEAD | Golden Gate DBA

·         Monitoring Oracle Managed File Transfer (MFT) jobs and troubleshoot problems.

·         Monitoring Golden-Gate processes that run on Unix host and Oracle Linux hosts

·         Monitoring for data discrepancies between PROD source systems and data being ingested into the Data Analytics Platform (DAP) target systems.

·         Monitor Oracle Data Integrator (ODI) jobs that run on Oracle Linux hosts.

·         Great experience in performance tuning of 12c instances on exadata platforms.

·         Performing code changes and testing in lower tier environments before loading into Productiion.

·         Assisted in configuring Oracle Golden Gate for unidirectional replication into big data Hadoop.

·         Monitoring of cluster and databases using Oracle Enterprise Manager 13C.

·         Generating AWR, ADDD reports for performance tuning and proving recommendations to application and development team on how to better optimize SQL queries.

·         Experience managing very large databases.

 

Environment

Solaris, AIX, RHEL ,GoldenGate, ODI, OBIEE , ASM, NAS file system, DBCA, Putty, Toad, EXPLAIN PLAN, AWR/ASH/ADDM reporting utilities,exadata X6-2, OEM 13C, RAC, Hadoop, PL/SQL.

 

 

Eversource Energy- Berlin, CT                                                                               3/2017 – 6/2017

 

Title – Project Oracle DBA

·         Excellent experience in installation, configuration, administration, and tuning Oracle 12C instances on AIX.

·         Configured DDboost to work with RMAN for backups purposes.

·         Installed, configured, and maintained ASM and standalone instances.

·         Configured and scheduled backups and scripts for database environments.

·         Created Schemas and tablespaces as needed.

·         Generating AWR, ADDM, ASH reports for data performance analysis.

·         Implemented code changes like DML and DDL using DBArtisan and SQL Developer.

·         Very good exposure with UNIX SHELL scripting.

·         Configured DATAGUARD for maximum performance and High Availability.

·         Configured physical and logical standby DATAGUARD for respective environments.

·         Developed monitoring scripts to monitor logs apply on logical standby environment.

·         Daily monitoring of databases and making sure backups and scripts ran successfully.

·         Worked closely with support teams including Developers, SAS, Network, Backup, Storage, and Security.

 

Environment

Dataguard, ASM, OEM 12C, STATSPACK, MobaXterm, DBartisan, DDboost, Weblogic

Lotus Notes, Standalone instances.

 

 

 

 

Emerson Industrial Automation– Eden Prairie, MN                                  04/2014 – 01/2017

Title – Remote Oracle DBA ( Support and Maintenance)

·         Installed 11g/12c software and created databases in RAC and non-RAC environments for new projects by interacting with multiple application teams.

·         Participated on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements.

·         Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.

·         Performed migration of non ASM database to ASM database.

·         Implemented and configured 12C cloud control agents as well as registering 11g/12c databases on SOLARIS servers.

·         Worked on 11g Grid control and 12C Cloud control and intensively used for Diagnostic & tuning activities.

·         Responsible for maintaining ORACLE 11gR2 using SRVCTL, OEM, maintaining Oracle Cluster ware using CRSCTL.

·         Implemented Transparent Data Encryption (TDE). Used TDE with encrypted columns.

·         Applied quarterly released CPU patches to update and security fixes to Oracle database 11g.

·         Experienced in RAC Administration (11gR2) with ASM storage and backup and recovery using RMAN.

·         Performed database refresh from Prod to Stage and DEV environments as needed.

·         Worked as a member of production DBA team in perfect coordination with seniors and team members.

·         Performed Disaster recovery of Exadata DATAGUARD Physical Standby. Failover/Switchover/Loss of service/Rebuild/Corruption/Loss.

·         Assisted in the configuration of Oracle Golden Gate for Active-active Synchronization.

 

Environment

Oracle 9i,10g/11g/12c database, Linux 4.0., Explain Plan, RAC, Dataguard, ASM,  DBCA, OEM, STATSPACK, TKPROF, Toad, and PL/SQL, Golden Gate, Exadata.

 

 

United Health Group- Herndon, VA                                                         09/2011 – 02/2014

Title - Junior Database Administrator

·         Experience in performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.

·         Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.

·         Worked on application and database security (data access, passwords, network, etc.)

·         Handled daily production problems/change requests with Oracle.

·         Performed daily database administration tasks: User management, Space monitoring, performance monitoring and tuning, alert Log monitoring and backup monitoring.

·         Proactively managed the databases set up alarms for managing any exceptions in day to day management of the databases pre-empted and prevented issues, disasters from happening.

·         Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

·         Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

·         Database refreshes using EXPDP, IMPDP, RMAN Duplicate and cloning.

·         Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.

·         Created a standby database using RMAN Duplicate to reduce the down time for the PROD database during the migration process.

·         Backup/Recovery monitoring and reporting using Oracle RMAN

 

Environment

Oracle 10g/11g/RMAN, ASM, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, AWR,ADDM

 

 

 

Organizational Membership

·         Omega Psi Phi Fraternity, Incorporated

 

Other Skills

·         Experience in virtualization; Creating virtual machines using Solaris, Oracle RHEL, REDHAT-7, OGGPCMR and Ubuntu Operating Systems.

·         Experience working on Amazon Web Service (EC2, RLB, VPC, S3, CloudFront, IAM, RDS, Route S3, CloudWatch, SNS).

 

Ø  Willing to Relocate.