Data Oracle

Name: Fatima J

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

Phone: 630-***-****

PROFESSIONAL SUMMARY

Over 6 years of Database Administration Experience

Provided day to day Database operations support

Provided support on-call rotation.

Managed 10g, 11g and 12c Databases

Managed 12c cloud control.

Build ASM diskgroups and managed ASM databases.

Build 11g and 12c Data Guard for Disaster Recovery site.

Build 12c Active Data Guard for Reporting tools.

Build and Administered 4 node RAC Cluster.

Proficient in managing database on RHEL, Solaris and Windows Environment.

Upgraded databases to 12c.

Migrated from non-ASM to ASM databases.

Proficient with Oracle Performance Tuning using ASH, AWR, ADDM and dynamic views

Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.

Installed CPU, PSU and one-off patches.

Very proficient with RMAN restore and recoveries of databases.

Set up jobs from 13c cloud control.

Setup monitoring of databases from OEM.

Worked on various exports imports from exp/imp and Data Pump.

Proficient in writing shell scripts to automate job

Proficient in RHEL and other Linux platforms.

Performed Security administration tasks, setup users accounts, passwords, roles, profiles and quota

Monitored data files, logical data storage and data growth activities

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

Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.

Perform capacity planning required to create and maintain database environments

Clone Database using RMAN duplicate / Export Import / Data Pump

Create thorough documentation of installation procedures and administrative tasks in the clustered environment.

Good working knowledge in Exadata

Good working knowledge in Oracle GoldenGate Replication.

Build 2 node and 4 node RAC Cluster

Worked with offshore/onshore teams.

SKILL SET:

DB Installation RAC Build Data Guard RMAN Data Pump Cloning Patching ASM

Charlotte Russe

Chicago, IL

Jan 2014 to Present

Oracle DBA

Provided support to ecommerce databases.

Build many 2 node RAC clusters.

Migrated databases from standalone to cluster.

Migrated databases from non-ASM to ASM

Worked with Developers, Application, storage, OS and network teams on projects.

Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, and Data Guard.

Build Physical Standby Data Guard for Disaster Recovery project.

Build Active Data Guard for Business Reporting applications.

Performed health checks in RAC instances using crsctl and srvctl utility.

Worked with offshore developers and DBAs.

Managed databases from command line, TOAD, SQL Developer and OEM.

Troubleshoot OEM Agents.

Restore and recovered databases using RMAN

Expertise in Tablespace Management

Expertise in User Management.

Resolved various performance Tuning scenarios

Applied patches to Grid Infrastructure and RDBMS homes

Applied CPU and PSU patches.

Involved in Tuning the RAC interconnect Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.

Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment.

Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.

Create thorough documentation of installation

Involved in SQL Query tuning

Used Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.

Provided 24/7 on-call support.

Refresh databases using export import and Data Pump

Cloned database using RMAN Duplicated database.

Provided support for databases hosted on Exadata.

Setup jobs vai crontab and 13c cloud control.

Provided limited support on Oracle GoldenGate.

Troubleshoot performance and network connectivity issues.

Pace

Chicago, IL

Jan 2011– Dec 2014

Oracle DBA

Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases

Monitoring database events as part of a Production support and level 1 staff.

Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR)of databases.

Performed cross platform migrations from Oracle 10g to Oracle 11g (Solaris-Linux)

Proficient in migrating data base from 9i/10g to 11g by applying latest patch sets.

Configured RAC on oracle 11g RAC.

Involved in administration of over 150 Oracle 11g/10g R2 instances.

Implemented Oracle advanced security across various database levels.

Developed Oracle Forms and Reports for the user interface; a data load using PL/SQL and SQL Loader; and Unix scripts to download and manipulate files

Development of PL/SQL and Web PL/SQL stored procedures.

Proficient in Oracle Materialized view replications.

Used Data guard for data migration from various database’s.

Installation and maintenance of Oracle 11g database.

Involved in the process of tuning and refining queries of various applications.

Implementing 10g Data guard with one physical database

Converted a single instance database to Oracle RAC 10g.

Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.

Extensive usage of ADDM, AWR, ASSM, features of 10g.

Developing Hot, cold and logical backup scripts to automate the backup procedures.

Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.

Restoration and recovery from backup.

Cloning of application from production environment to test environment and application of patches.

Moving data from development to production through transportable tablespace exports.

Monitoring the table growth, database growth, current users, and system resource usage.

Implementing standby database and database replication to provide high availability of database.

Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.

Continuous monitoring of database performance during peak and non-peak loads using STATSPACK

Involved in team management, team building exercises for the DBA team.

Contact this candidate