Oracle Manager

ANNIE KNOWMEN

Email: *******@*****.***

Tel: 310-***-****

Profile

An Accomplished Oracle DBA with seven years of experience in Oracle Database Administration in large-scale production environments across multiple platforms. Ability to provide expert-level technical support in all aspects of database administration including Installation and Configuration, Database Security, Golden Gate for Replication, Cloning memory management, performance monitoring and tuning, RAC, Data Guard, Backup & Recovery, Upgrades and Patching, OEM Grid control, Migration, Data Modeling, oracle Stream Linux and Windows OS.

Skills Summary

Proficient experience as an IT professional along with extensive experience as an Oracle Analyst.

Expert in Oracle 12c, 11g R1, 11g R2.

Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL Tuning, database access and Security and auditing.

Configure Manager, Replicate and Extract processes and implement bidirectional replication using Oracle Golden Gate on RHEL 5 platform.

Performing Fault Injection Test Case for verifying High availability at each layer of RAC and stack like port failover, instance failover, ASM failover and nodes failover.

Installation Configuration and Administration of Oracle 12c RAC, 11g RAC and oracle 10g RAC database with Flex Cluster and Flex ASM.

High ability to analyze and understand the AWR reports and can fine-tune the databases for maximum performance.

Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.

Implement RMAN backup (full, incremental and cumulative) hot/cold backup and recovery, cloning database-using RMAN.

Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.

Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA).

Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.

Performed backups and crash recoveries using conventional hot/cold backups and RMAN

Performance Tuning of the database through Database Tuning, SQL Tuning utilities like STATPACK, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA, Oracle Enterprise Manager(OEM), distribution of disk I/O, Sizing of tables and indexes and dell Fluid Cache/Fusion IO - Tuning Applications, Tuning Instance, and Tuning Disk Usage to improve database performance

Implemented Data guard in the production environment.

Experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.

Set up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose.

Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR).

Technical Proficiencies

Tuning Tools:

EXPLAIN PLAN, STATSPACK, AWR, ASH and ADDM

Tools and Utilities:

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

RDBMS:

Oracle 10g, 11g, 12c

Operating Systems:

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

Languages: SQL, PL/SQL, UNIX Shell Scripting

Professional Experience

ALPINE ELECTRONICS OF AMERICA INC, TORRANCE, CA

JULY 2016 – Present

Oracle DBA

Involved in Installing, Configuring and Administration of Oracle 10g/11g /12C RAC on ASM.

Upgraded databases from 11.1.0.7, 11.2.0.2 11.2.03 to 12C

CRS upgrades from 11.2.0.2 to 11.2.0.3.

Worked on 2 node and 4 node RAC databases from 200GB - 16TB

Installed 10g /11g binaries on HP-UX and Linux servers and configured new production databases for the same.

Good Knowledge of Physical and Logical Data Modeling using ERWIN

Installation of agent 11g and OEM Grid control 11g.

Involved in capacity and resource planning.

Implemented scripts to monitor and get information on free space, alert log errors provided maintenance of user accounts, privileges, profiles and roles.

Experience using 11g and 12c Golden Gate, including upgrading, setup and support in QA and production ODS.

Ensured that ODS was always in sync with sources by using custom scripts, EM12c monitoring, and Golden gate director notifications.

Follow up on SRs for different issues (SCAN behavior, Node eviction, Failover etc. )

Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.

Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.

Responsible for configuring data guard physical and standby database setup for high availability and handling synchronization issues between primary and standby.

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Done migration of non ASM database to ASM database.

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

Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.

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.

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.

SQL tuning and Database performance tuning done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.

Environment: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Data pump, SQL TRACE, EXPLAIN PLAN

State Farm –Phoenix, AZ

Mar 2012 – June 2016

Oracle Database Administrator

Successfully installed and configured Oracle 12C, 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

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

Automated processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Implementing Data pump, 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 Data pump import/export to move data between 10g/11g environments.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Databases migrated to RAC for improved resiliency and performance.

Security User Management, Privileges, Role, Auditing, Profiling, Authentication.

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

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.

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.

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.

Used TOAD for database management.

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).

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

1.2.0.3.

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

Education/Training

Bachelors in Business Administration/Accounting - California State University,Los Angeles

SAP FICO certified- 2014

Oracle Certified Associate 2017, Oracle University

Contact this candidate