Oracle Manager

KULA AATOZ ZODUA

Email: *********@*****.*** Phone: 415-***-****

I have 6 years of professional experience as an Oracle Database Administrator. I possess complete life cycle knowledge including Installation. I have worked on Oracle 12c, 11g, 10g versions involving database administration, production/development support, installation and configuration, upgrades, patch management, migration, backup and recovery, performance tuning, cloning, space management and security admin.

Professional Summary

Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

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.

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 Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfil the storage needs.

Installation and configuration of oracle Golden Gate.

Experience in using Golden Gate to support data replication in the Oracle database environment.

Proficient in Database administration activities such as user management, space management, Monitoring, Creating Database, Managing Oracle Instance and Database security and Materialized Views.

Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, Advisories, TKPROF, SQL TRACE,EXPLAIN PLAN for the better performance.

Performance Monitoring and Tuning of Database using Grid Control & Diagnostic pack (AWR, ASH ADDM)

Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).

Experience in taking backup and performing recovery.

Designed and implemented Oracle Real Application Clusters (RAC) on Linux.

Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.

Experience in conversion of Single Node Instance to multimode RAC with ASM, and adding instance to existing RAC.

Experience in Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.

Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).

Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery.

Experience in applying PSU patch on standalone as well as RAC databases.

Experience in Golden Gate upgrade from 10.4 to 11.2.

Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.

Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional

replication using Oracle 11g Golden Gate on RHEL 5 platform.

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.

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.

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.

Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.

Education

Stella Maris Polytechnic– Monrovia – Liberia

B.A. Economics and Accounting

IT CERTIFICATIONS

Oracle Certified Associate

SQL Fundamentals

CompTIA A+

CompTIA Network+

Scrum Master

DBA_Technical Skills

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

RDBMS

Oracle 10g, 11g, 12c

Languages

SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, NX

client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

Experience

BMC Software - Houston, TX September 2017 – Present Oracle Database Administrator

Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON- CDB) Databases.

Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using data guard switchover and Export & Import.

Applied the Clusterware (GI), Database (RDBMS) Patches i.e PSU patches and one-off patches (for Bug resolution) using opatch.

Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c as part of performance improvement by utilizing the new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.1).

Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.

Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Datapump and Normal ) for restoring the specific objects at the database level.

Building Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.

Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.

Worked and implemented Database Wallet for Oracle 11g also called as keystore from 12c and TDE (Transparent Data Encryption) for Encrypting the Sensitive data using column encryption and tablespace encryption, also used TDE for Goldengate replication too.

Also tested disaster recovery with database failover and switchover also tested Goldengate replication after that using DBFS filesystem and ACFS.

Efficiently performed installation, setup and creation of four 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

Leading the effort of Cross-platform migration of Oracle databases to Oracle SuperCluster.

Monitoring of the databases using Oracle Enterprise Manager (12c).

using Oracle Enterprise Manager (12c).

Setting up replication of databases using Oracle Golden Gate.

Involved in Installation and configuration of Oracle 11gR2 RAC (2node) using oracle Clusterware and ASM.

Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Standby Database (Active Data Guard), Replication.

Worked on import/export, export data pump/import data pump and SQL- loader.

HP-UX Platform migration to Oracle Linux 6.3 Using RMAN Transportable table space

Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.

Recovering GoldenGate corruptions and managing host/cluster maintenance mode blackouts

Implemented Initial DataLoad, Batch/Online replication, Security in GoldenGate.

Applying PSU / CPU Patches applying Oracle DST Patches on Oracle database.

Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Write and modify UNIX shell scripts to manage Oracle environment.

Implemented Initial DataLoad, Batch/Online replication, Security in Golden Gate

Created users, granted roles and privilege management. Maintained user accounts and privileges to maintain application security.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

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/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Acxiom - Little Rock, AR September 2014 – August 2017 Oracle Production Support Database Administrator

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

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.

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 9i (9.2.0.7) 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, Suse Linux, RAC, ASM, RMAN, AWR, ADDM, SQL*

Plus, SQL*Loader, OEM, TOAD 10.0.

Arvin Meritor (Meritor) – Troy, MI April 2012 – June 2014 Role: Oracle Database Administrator

Used Secure SCP & FTP extensively for the File transfers from machines to remote server.

Application of Oracle software patches when/where necessary.

Create oracle databases on configured servers using both the DBCA & Database creation scripts.

Worked on user management mainly on grants, privileges, roles and profiles.

Designing and developing SQL procedures, query performance tuning.

Performed hot and cold backup and recovery using RMAN and UNIX Scripts

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.

Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).

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.

Monitoring tablespace issues, creating tablespaces and adding datafiles.

Involved in session management and monitored the critical wait events, blocking sessions in the database.

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

Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

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.

Experienced in cloning the databases using HOT and COLD backups.

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

Created a stand by database by using RMAN Duplicate in order to reduce the down time for the

PROD database during the migration process.

Backup/Recovery monitoring and reporting using Oracle RMAN

Create database Objects, Tablespaces, Schemas as needed.

Schema migrations from Development to Production via Tech Test environments.

Database refresh from Production to Tech Test as needed.

Environment: Oracle RMAN, Oracle 10.2.0.1, Oracle 11g, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Contact this candidate