A talent and resourceful Oracle DBA professional with over 6+ years of diligent experience. I have supported the complete life cycle of the SDLC. I have worked on Oracle 9i, 10g, 11g and 12c versions. I have done database administration duties including production support, installation and configuration, database upgrades, patch management, database migration, backup and recovery, performance tuning, database cloning, golden gate and security management. I have supported customized Applications like HR, FIN and PEOPLESOFT
Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.
Experienced in Performance Monitoring tools like OEM, AWR report, DBMS_PROFILER to troubleshoot some PL/SQL codes.
Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, OEM Grid, monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
Experience with SQL coding including DDL, DML and fine-tuning those SQL's for better performance.
Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring. Expert in RMAN backups including full, incremental and cumulative.
Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN.
Experience in applying patches/ patch sets to the databases.
Extensively worked on Import/Export and Data Pump Import/Export tools.
Knowledge in configuring ASM (Automatic Storage Management)
Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and Real time replication using Golden gate.
High ability to analyse and understand the AWR reports and can fine tune the databases for maximum performance.
Install, configure and upgrade to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle 12c features.
Performed database monitoring and tuning to ensure databases run at peak performance; troubleshooting production performance issues.
ASM, BI, Compliance reports, Client, Database administration, DBMS, Disaster recovery, Event management, Government, Linux, 2000, NT, OLAP, Oracle, Peak, Coding, Real Time, Scripts, Solaris, SQL, Teradata, Troubleshooting, UNIX Shell Scripting, Utilities, Windows Server
Oracle Corporation | Austin, TXSenior Cloud Database Administrator11/2018 - Current
CPA GLOBAL LIMITED | Austin, TXOracle Database Administrator03/2016 - 06/2018
Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
Refreshing Dev and Test instances with data from Production on a regular basis.
Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
Thorough knowledge in setting up infrastructure for databases in huge datacenters.
Installed Oracle 11g on Linux platform using ASM.
Creating Materialized views and Materialized View Logs for Data Replication.
Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
Worked on building and rolling out new 12c databases for TEST/DEV/QA environments.
Implemented oracle 12c active standby database for test database environment.
Handled my group of 4 people in all and lead them for getting best results.
Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports.
Provided recommendations using ADDM reports.
Analyzed the trace files Using TKPROF utility.
Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat and crs_profile.
Responsible for setup and implementation of 2Node RAC on IBM-AIX in log and 11gR2 using Veritas cluster server.
Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.
Performed various tasks like Administering RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
Developed compliance reports and performed auditing at higher levels.
Scheduling repetitive activities like gathering schema statistics, exports, tablespace usage report using crontab.
Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
Extensively used Data pump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
Capacity planning: Allocate system storage and plan future storage requirements.
Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer.
Installation and configuration of Oracle databases environments (10/11g), upgrades, patching for security vulnerabilities (CPU and PSU).
Performing monthly and annual performance reports for trend analysis and capacity planning.
Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
Worked on both VMS and UNIX environments.
Troubleshooting of various database performances by proper diagnosis at all levels like SQL.
Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
Used GOLDEN GATE for Zero Downtown Upgrade and Migration.
Experience in writing UNIX/SHELL scripts for providing the reports.
Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.
J.B. Hunt Transport, Inc | New York City, New YorkOracle DBA02/2015 - 05/2016
Troubleshot and resolved web application issues resulting from customers and other departments with a high success rate.
Worked with clients to analyze computing and network needs and implemented appropriate solutions with every department.
Experience in performance monitoring/tuning/troubleshooting - Oracle database services with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, ASH and SQL TRACE.
Experience in Installation, configuration and maintenance of Physical, Logical, Active standby databases supported by Data guard on Oracle 10g, and 11g RAC for disaster recovery purposes.
Generated ASH, ADDM and AWR Reports using OEM from Oracle 10g, 11g and 12c database and analyzed the reports for better performance, time consuming SQL queries, tablespace growth, and database availability.
Implemented database re-organizations as required to improved performance and ensure maximum up-time of the database.
Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and ACFS file systems.
Migrated multiple stand-alone databases to RAC databases using Rconfig, RMAN and OEM.
Migrated single instance databases from NON-ASM to ASM file system to improve performance.
Expert in Installation of Oracle 10g, 11g and 12c software and created multiple databases including Plug-able and container databases in oracle 12c.
Implemented TDE, Data Redaction and database Auditing to improved data integrity and security.
Applied PSU on standalone TEST environment using OPatch and same PSU (Grid and RDBMS Patching) on production cluster using OPatch Auto.
Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and OEM.
Implemented and managed logical backup/recovery with Data pump and Export/Import utilities.
Cloned databases using RMAN and Manually using scripts.
Implemented Point In Time Recovery on one or more tablespaces to recover lost of a table(s) while eliminating down time for the database.
Installed SQL Server EE 2012 on windows and created databases, triggers, tables, procedures, functions and database diagrams.
Extensive experience in Upgrading databases from 10g to 11g and 12c using DBUA, Data pump, Manually, Transportable Table space and Oracle Data guard.
Education and Training
Government High School (Advanced Level Certificate in Business studies)
Siantou University Complex YaoundeBS in Business Management and Administration