SUMMARY:

• I have overall 7 + years of hands - on experience as an Oracle Database Administrator. I possess complete life cycle knowledge including Installation. Worked on Oracle 12c, 11g, 10g versions involving database administration, production support, installation, configuration, OEM, Data Guard, Upgrades, Patches, Migration, Backup and Recovery, Performance tuning, Cloning, space management, Data Pump and security.
• Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM.
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• Installed, configured and maintained Physical, Active and Snapshot standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 12c, 11g, 10g.
• Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN.
• Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations.
• Experience in SDLC Methodologies
• Performed Upgrade and Migration of Oracle databases from oracle 10g to 11g & 12c.
• Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches and out of place patches.
• Experience in doing upgrades including maintenance & monitoring implementation.
• Extensive knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
• Knowledge in configuring ASM (Automatic Storage Management)
• Extensive Experience with RMAN Physical and Logical Backups.
• Extensively implemented Data pump, conventional Export/Import (Oracle 12c, 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 Data pump Export/Import (Oracle 12c, 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Worked on Data transferring with export/import utilities and Data pump.
• Highly experienced in performance monitoring/tuning/troubleshooting.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TUNING ADVISOR, AWR REPORT, ASH, ADDM, OEM 13c.
• Applying patches under UNIX platform.

TECHNICAL PROFICIENCIES:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000, Linux red Hat

RDBMS: Oracle 9i, 10g, 11g, 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: SQL*Plus, Oracle Enterprise Manager Grid Control, EXPLAIN PLAN, STATPACK, AWR, ADDM, ASH, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: RCONFIG, ADRCI, DBVERIFY, DG Broker, ASMCMD, SRVCTL, CRSCTL, LSNRCTL, SQL, DBNEWID, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import, LogMiner

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Oracle Database Administrator

Responsibilities:

• Currently doing database upgrades from Oracle 11g to 12.1 and from 12.1 to 12.2 using the command line and DBUA utility, developing and documenting upgrade process as required.
• Applying PSU patches to Oracle 12.1 homes and involved in database (12.1 and 21.2) refresh from Dev to QA and to production for developers to run their tests.
• Managing and supporting of Oracle Production databases running on Exadata X3 and X6 machines
• Migrating 50+ databases from Exadata X2 and X3 machines to Exadata x6 machines
• Working on Exadata X2, X3 and X6 machines which included Half Rack and Full Rack
• Managing all operational aspects of production and development database environments (primarily running Oracle RAC) assigned to me.
• Reviewing and implementing of database schema changes on oracle 12c (21.1 and 21.2)
• Planning and executing patches and upgrades of production and development database environments on Oracle 12c.
• Monitoring database performance and operational metrics.
• Excellent troubleshooting skills and good in fixing real time problems within the database and it’s objects.
• Identifying and solving performance issues using OEM or tools such as AWR report and ADDM or gathering statistics using the DBMs Stats pack.
• Proactively monitoring Oracle 10g, 11g and 12c Databases using Oracle Enterprise Manager (OEM) 13c.
• Ensuring databases are properly backed up and recoverable using RMAN.
• Providing SQL tuning expertise to application developers using tools such as explain plan, SQL Tuning Advisors.
• Assisting in the creation and enforcement of standards and policies related to the enterprise database infrastructure.
• Communicating, advocating for and enforcing best practices and standards.
• Participating in the on-call rotation.
• Managing database infrastructure related projects assigned to me.
• Advocacy, Investigation, testing and implementation of new database features and technologies as assigned by the managers.
• Supporting multiple databases for production, development, test and staging purposes on linux,
• Solaris and Windows environments.
• Implemented a solid SDLC Methodology
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved inOracle Streams.
• Implemented and troubleshooting Golden gate (unidirectional and bidirectional) for real time replication purpose both on homogenous and heterogeneous environments.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package
• Successfully upgraded the databases from 11g to non CDB 12c.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Successfully setup 4 node Primary RAC with 3 node physical standby for new application in 11GR2. Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports
• Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection.
• Database monitoring and performance tuning using OEM 13c, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM,
• 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.
• 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 9i and 10g/11g 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 scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Efficiently performed installation, setup and creation of 3 node cluster RAC with Oracle 11.2.0.3 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 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Environment: Oracle 11g/12cRAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential, New York, NY

Oracle Production Support Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Experience Oracle 11gR2 Golden Gate for the purposes of DATA REPLICATION that is for reducing the complexity involved inOracle Streams.
• Also involved in the configuration of Golden Gate Technology.
• Implemented and troubleshooting Golden gate (unidirectional and bidirectional) for real time replication purpose both on homogenous and heterogeneous environments.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• 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 9i and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM 12c (Oracle Enterprise Manager).
• Documented the Standard Processes for peers to follow.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) Databases.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Suse Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Confidential, Minneapolis, MN

Junior Oracle Database Administrator

Responsibilities:

• 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
• Implemented and troubleshooting Golden gate (unidirectional and bidirectional) for real time replication purpose both on homogenous and heterogeneous environments.
• 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
• Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks
• 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 9i (9.2.0.4), 10g (10.2.0.1) on various OS platforms like HP-UX, Linux, and Windows NT, 2000
• 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
• Worked on the physical and logical designing of the database, which includes the distribution of data- files on different disks.
• 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
• Created primary database objects (tables, views, indexes) once application developers have designed an application
• Monitored Customer Databases, physically located in U.S and Remote administration of fifteen Production Databases in UNIX environment

Environment: HP-UX, Windows, Oracle 8i, 10g, SQL, PL/SQL, SQL plus, TOAD, Linux Red HatBachelors in Computer ScienceUniversity of BueaCameroon