A Detailed and goal-oriented Oracle Database Administrator with 5+ years of experience in designing, implementing and maintaining Oracle 10g and 11g RDBMS. Supported a variety of mission critical applications with Oracle 10g, 11g and 12c. Worked across a multitude of platforms (Solaris, UNIX, and Windows) in production and development environments with responsibilities encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Performance Monitoring and Tuning, auditing, RAC, Data Guard, Grid Control and production support. Excellent communication /documentation skills and strong aptitude to analyze and resolve problems.
BSc Sociology and Anthropology University of Buea Cameroon
HP-UX 10.x, 11.x. Sun Solaris, Linux Enterprise Red hat. Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup.
Executed and implemented user helpdesk tickets of various issues via REMEDY database from creating user accounts, read-only accounts on a database & table down to assisting them with logging into the database. Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB.
Experience in Installation of Oracle Databases 10g, 11g and 12c versions.
Experience in the Upgrade of Oracle Databases in patch set Level and also in version Level (10g to 11g) and (11g to 12c).
Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
Experience in Backup & Recovery techniques of databases running using RMAN and backup tools like NetBackup.
Experience in maintaining high Availability like RAC and implemented 11g RAC 2 Node with ASM/Non-ASM storage.
Experience in weekly and monthly code migrations using Quest Stat and also manually.
Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
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.
Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
Hands on experience in complete recovery, incomplete recovery, Flashback Recovery, Disaster Recovery, recovering data files, tablespaces and control files.
Troubleshoot Database performance issues using Explain plan,AWR,ADDM,ASH and OEM advisors
Implemented Physical Backups (offline/online) and Logical Backups including Datapump tools expdp and impdp.
Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB
Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g.
Highly experienced in performance monitoring/tuning/troubleshooting.
Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, and SQL TRACE. Applying patches under UNIX platform.
Oracle Database Administrator, 01/2014
to Current Staples Inc – Framingham,
Monitoring space, wait events, locks and long operations running on the database Monitoring the session waits for the database performance and resolving the performance issues.
Monitoring the database for growth and added space to the table spaces as per demand.
Generating AWR/statspack reports on regular basis to identify the database performance at peak load.
Tuning the SQL statement by analyzing the explain plan and ADDM reports Implemented scripts to monitor and get information on free space, alert log errors provided maintenance of user accounts, privileges, profiles and roles.
Involved with OLTP relational databases system analysis, design, implementation and management.
Upgrade/Migration of Databases from Oracle 10g to 11g, Cross platform migration from different platforms.
Experience on working with data guard physical/logical standby databases.
Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
Documented the Standard Processes for peers to follow.
Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
Extensively working on new builds of 11gR2 RAC / RAC-ONE / Data guard environments with ASM on Linux/AIX platforms Responsible for Online and Offline backups of the oracle database using RMAN Setup and Configuration of OEM 12c, Agent installations using various methods & configuring target hosts/databases for monitoring.
Set up alerts and notifications from 11g OEM Applying CPU/PSU Patches on ERP instance and Plain databases.
Cloning of Test/DEV instances from Production systems.
Maintained Oracle 11gR2 RAC high availability with ASM file system with Cluster Stat and Grid infrastructure on Linux environments.
Performed an upgrade of Oracle Database from 11g to 12c.
Creation and configuration of new database server and database environments.
Performing Monthly Re-org of complete databases using expdp and impdp Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
Work with infrastructure teams on any infrastructure issues such as server performance, network issues, scheduling and monitoring.
Implemented Physical standby for disaster recovery using Data Guard on Oracle 11g.
Performed Database upgrade from 11g to 12c.
Applying interim patches, PSU and CPU patches using OPATCH utility to resolve bug fixes.
Perform Database backups using RMAN and NetBackup tool.
Worked extensively on supporting RAC Databases.
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.
Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
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.
Created logical and physical design installed and upgraded databases.
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 10g/11g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.
Oracle Production Support Database Administrator, 03/2012
to 12/2013 ADP – Chicago,IL
Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
Active participation in change and release management.
Develop various POC for upcoming upgrades/implements.
Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT and TOP.
Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
Worked extensively on tools like CRSCTL and SRVCTL.
Performed migration of database from one platform to another.
Involved in working on ASM databases.
Creating of ASM Disk groups and assigning the disks to the disk group.
Creating table spaces, tables, and users for custom applications.
Plan and schedule RMAN backups (hot, cold and incremental backups) Setup 12c Oracle Enterprise Manager (OEM) Implemented Transparent Data Encryption (TDE) for database security.
Involved in the installation, configuration and extended support to Oracle 10g, 11g two Node RAC (Real Application Cluster) with ASM and file system on AIX platform.
Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
Automated the Data Replication process using Materialized Views for reporting databases.
Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 22.214.171.124 database using GRID infrastructure with ASM file systems on RHEL 5.5.
Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 126.96.36.199 and Oracle 10.2.0.5 RAC databases.
Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
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/11g environments.
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.
Junior Oracle Database Administrator, 04/2011
to 03/2012 Brown Brothers Harriman & Co – New York,
Installation and configuration of Oracle database 10g (10.2.0.1) on various OS platforms Created primary database objects (tables, views, indexes) once application developers have designed an application 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.
Monitored Customer Databases, physically located in U.S and Remote administration of fifteen Production Databases in UNIX environment Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks Environment: HP-UX, Windows, Oracle 10g, 11g, SQL, PL/SQL, SQL plus, TOAD.