Oracle Database Administrator

Anicet Tiba

Email: ac00t2@r.postjobfree.com

Phone: 301-***-****

PROFILE/SKILLS

Five Years of thorough experience in Oracle Database Administration. Specialization areas include Installation, Configuration, Performance Monitoring and Tuning, Patch Installation, Database Migration, Upgrades, Backup and Recovery, Memory Management, Data Modeling,, RAC, Data Guard, Grid Control configuration, Cloning, Replication, Database Security.

UNIX shell scripts for hot backups, SQL*Loader, export and import of database.

Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Installed Oracle 11g with ASM and OCFS2 File systems.

Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

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.

Installation, Upgradation, Configuration and Troubleshooting GoldenGate 12c software.

Configured GoldenGate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.

Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.

Installed and configured GoldenGate JAgent to work with OEM GoldenGate Plugin.

Expertise in maintaining Database Security using auditing.

Experience in Data Migrations.

Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.

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

Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.

Performance Tuning of the database (Memory Tuning, I/O Tuning)

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.

Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.

Created indexes to facilitate easy user interface implementation and tuning.

Involved in construction of DR sites for all the Production and IST environments.

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 Backups, Hot Backups and Logical Backups.

Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.

Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listner, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.

Experience as 24x7 productions DBA as well the application (development) database administrator.

Experienced in working with very large 24x7 Oracle RAC 10g & 11g databases on ASM of nearly 80GB to 22TB.

Experience in database patching, cloning, upgrade, migration & maintaining standby db server (DR).

Experience with database backup, recovery, and setting up disaster recovery Database servers.

Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems. (Normalization, De-normalization, Entity Relationship diagram, DFD etc)

Expertise in all the phases of Software Development Life Cycle (SDLC).

Experienced in working with DBVERIFY utility and other method to find Data Corruption.

Experienced in resource management like data files with ASM (Automatic Storage Management) (Trouble shooting, Add, Remove Files etc.), online redo log files, control files. Allocating logical storage structures like tablespace, schema and extents as well as configuring Oracle databases on Multi-Threaded Servers Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.

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.

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 TRACE. Applying patches under UNIX platform.

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

EDUCATION

SOA UNIVERSITY (Yaounde-Cameroon)

Master in Management

EXPERIENCE

Cadbury Schweppes Americas Beverages - Plano, TX

July 2013 – till date

Oracle Database Administrator

Responsibilities:

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.

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

IT Security policy enhancement through role & privileges, Implementation of PCI & SOX compliance for Databases.

Provided valuable inputs for various performance tuning issues.

Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.

Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.

Created indexes to facilitate easy user interface implementation and tuning.

Involved in construction of DR sites for all the Production and IST environments.

Performed Database Refresh from Production to IST, UAT and Development databases.

Installing and configuring Oracle WebLogic 11g application server.

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

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

Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.

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.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

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 includeCritical Patch Update (CPU), Patch Set Update (PSU) andOne-off patchesusing OPatch and runinstaller, also involved in upgradeoracle database 9i to 10g and 10g to 11g.

Experience with data movement using Oracle utilities like Export/Import, Data pump and SQL *Loader.

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.

Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.

Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.

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

Planned and configured disk layout, mount points and capacity requirements for servers.

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 9i to 10g, Cross platform migration from different platforms.

Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.

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

Created logical and physical design installed and upgraded databases.

Documented the Standard Processes for peers to follow.

Environment: IBM-AIX, Windows 2003/NT, Oracle 9i, 10g, RAC, TOAD, OEM, DATAGUARD, RMAN, Data Pump, Diagnostic and Tuning Advisors.

Cooper Vision, Inc - Rochester, NY

June 2011 – June 2013

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.

Loading data from flat files to database using SQL*Loader, External Tables.

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 10g 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 (Oracle Enterprise Manager).

Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting

Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.

Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin 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 10g (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

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.

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.

Used TOAD for database management.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

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

TECHNICAL SKILLS

Tuning Tools :

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Tools and Utilites:

RMAN, OEM, SQL*Loader, EXP, IMP, Data pump,, TOAD, Oracle SQL Developer.

RDBMS :

Oracle 9i, 10g, 11g

Operating Systems:

HP-UX 10.x, 11.x, 12c, Sun RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise

Contact this candidate