Data Oracle

Saamah *********@*****.*** Oracle DBA Phone: 502-***-****

Oracle DBA PROFESSIONAL SUMMARY:

Enterprise DBA support utilizing around 5 years of Experience in Oracle Database Administrator, providing 24X7 productions and development support 11g R2 RAC, 10gR2 RAC, 9i databases on different platforms like HP-UX, SUN SOLARIS, AIX, Red Hat Linux and Windows.

Best practices for Oracle Database Infrastructure, Standards and Implementation.

Implementation of best case scenarios for enterprise wide Database backup/recovery solution analyzing the specific business needs and optimizing the use of existing infrastructure

Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control.

Worked on 12c Cloud Control

Applied CPU, PSU and one off patches.

Analyze application activity, tuning the particular data caused for poor performance

Installation of Oracle Databases on Standalone and RAC cluster.

Data Guard setup with Primary and Standby Databases.

Strong Oracle RAC Installation, Configuration and Tuning Skills on Red-Hat Linux and Sun Solaris.

Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option.

Strong SQL skills to perform the data base operations.

Intermediate PL/SQL skills.

Very familiar with Oracle Dictionary Views.

Worked on many export import and Data Pump tasks.

Used Shell scripts to automate jobs.

Scheduling backup Jobs using Cron (UNIX) and Schedule Task (Windows).

Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.

Physical database design, Logical database design, normalization, de-normalization

Set up Oracle GoldenGate uni-directional and Bi-directional setup.

Familiar with Database security and auditing.

Setup procedure for Database statistics gathering

Worked on Upgrade and Migration Project.

Collections of performance data for specific time range using STATSPACK, AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN, and SQL Trace.

Analysis of Database Wait Events.

Troubleshooting for slow performing SQL by enabling Database tracing including session specific tracing. Performed SQL Tuning using Explain Plan.

Setting up Enterprise Manager notification procedures, who gets what notification, monitoring frequency, threshold limits for process memory, disk usages etc.

Setup Data Guard.

Excellent problem solving skills in Data Guard environment.

TECHNICAL SKILLS

Primary Skills – Oracle Admin

Database Installation, Configuration, Support and Maintenance

Database Backup and Recovery (RMAN and User managed)

OEM, TOAD, TKPROF, STATSPACK, SQL*Loader

Storage and Space management

Performance Tuning (Memory management, SQL Tuning, Lock etc.)

Shell Scripting

User, Role, Profile management

SQL, PL/SQL Programming

Project: Upgrade & Migration

Index Rebuilding and monitoring Usage

Oracle Net, TCP/IP

Oracle GoldenGate Replication

Additional skills

Operating Systems

Windows2008/2012

RHEL

AIX

Oracle Solaris

HPUX

Languages

C, C++

Other Databases

Oracle 9i to 12c, Microsoft SQL Server

Replication:

GoldenGate

Active Data Guard

Materialize Views

PROFESSIONAL EXPERIENCE:

HP (Supporting Sabre), Austin TX Aug 2013 – Present

Oracle DBA

Role & Responsibilities:

Supported different clients with multi-terabyte databases.

Installed Standalone and RAC Database Servers

Completely build RAC from scratch including OS and RAID configuration.

Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.

Build Data Guard

Worked and resolving gaps.

Responsible for new 11g database installation

Upgraded and patched existing Oracle homes.

Build 2-node 11g R2 cluster from scratch on Linux.

Build Data Guard.

Designed roles and assigned permissions

Responsible to improve the performance by using the Hints, Index, Explain Plan

Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace

Automating the backup processes using shell scripts.

Build RAC clusters and added nodes.

Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space

Export and Import of User, Tables and Database using exp/imp and Data Pump

Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces, and Temporary Tablespaces.

Used exp/imp, data pump and dblinks to move the data

Worked on standard and enterprise edition of the Oracle RDBMS.

Worked on database backup using RMAN for HOT backup and scripts written for COLD backup.

Worked on schema Reorganizations for better space management

Performed Database Refreshes and Database Copies for Development, Test and Production databases

Installed, Migrated, configured and tested Oracle 9i databases in various environments

Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.

Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers

Data modeling / Logical database design and implementation (including index design)

Migration of system and applications from Oracle 9i to 10g.

Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks

Create and maintain multiple databases.

Create multiple 11g databases on RHEL5 in development.

Schedule backup in 11g using db console.

Monitoring frees space in tablespaces, Archive log destination, Database/Listener availability, Blocking Locks monitoring etc.

Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Stand by databases to ensure high availability, data protection and disaster recovery.

Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g

Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.

Implemented backup strategies which involved taking an incremental backup and enabled the block change tracking feature.

Worked with Oracle in troubleshooting issues.

Worked with Development team in deployments.

Environment: Oracle 10g, 11g R2, RAC, Oracle Data Guard, Oracle GoldenGate

Cars, Chicago, IL June 2011 to July 2013

Jr. Oracle DBA

Roles & Responsibilities:

Build database servers.

Performed Silent installs.

Ran scripts

Install database with dbca, scripts and silent install.

Worked with Sr. DBAs and shadowing them.

Implemented procedures and practices regarding database design, development, monitoring, access, and upkeep.

Helped deploying RAC

Helped deploying Data Guard.

Installed Oracle clients on application servers.

Worked on a faced pace working environment.

Developed and implemented backup and recovery strategies.

Developed policies and procedures for system operations to better serve clients.

Setup Alerts via Grid Control.

Load Data using SQL Loader from flat files

Supported developers in running scripts

Used TOAD to manage databases.

Worked on SQL Server 2005 and 2008 instances.

Schedule daily and weekly maintenance jobs in SQL server

Setup the log shipping to create standby database in DR data center.

Database Backup, Database Restore and Database Recovery using various tools.

Database Reorganizations for better space management.

Performed Database Refreshes and Database Copies for Development, Test and Production

Supported multiple accounts on versions 9i to 11g

Silent Installation of Oracle 11g on CentOS

Create and maintain users, roles and privileges.

Installed and configured Oracle Grid control.

Extensively used data moving utilities like export/import, Data pump, Migrated flat files from different sources into Oracle Database using SQL*Loader and Performed DB cloning.

Performed Online/Offline database backups.

Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.

Environment: 10g, 11g, 11g Grid Control, RHEL

Contact this candidate