Oracle 11g DBA Data Warehouse Application Specialist Resume

OBJECTIVE:

Looking for a mid - level 11g Oracle DBA position “local (within 20 miles of zip 20147) or 100% remote”.

SUMMARY:

12+ years of experience under the belt as an Oracle Database Administrator having hands on experience in production support, installation, configuration, upgrades, patches, performance tuning, plan stability, backup and recovery, cloning, space management, database security, migration, data guard, partitioning, documentation and e-2-e Performance Tuning and Optimization on databases ranging from 8i to 11g (RAC and no-RAC).

TECHNICAL SKILLS:

SOFTARES & TOOLS: TOAD, SQL Developer, SQL Navigator, Cygwin, Exceed, Oracle APEX, OEM, Microsoft Office, MS VISIO, SQLPLANBASELINES, SQL Profiles, 11gR3 DBA-skills.

EXPERIENCE:

Oracle 11g DBA Data Warehouse Application Specialist

Confidential

Responsibilities:

On-Call by rotation 24x7 production DBA support, application/development DBA on 100 TB of business-critical database.
Experienced in building databases in AWS cloud infrastructure. Sound knowledge of Amazon web Services.
Extensive knowledge on database administration for Oracle 8i, 9i, 10g, 11g with experience in very large-scale database environment and mission critical OLTP and large (up to 100TB) Dara Warehousing systems.
Experienced in managing Oracle databases running on MS-Windows, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
Hands on experience in Oracle RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation). Installed multiple n-node RAC Clusters.
Experienced in RAC Cluster ware administration, Configuration and Patching.
Experience in Data-guard configuration, implementing and maintaining standby databases.
Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
Performed Oracle Partitioning and automated generation of partitions and related indices.
Created SQLPLANBASELINES and PROFILES to fix database plan stability.
Supported multiple development teams in Query optimizations and tuning.
Provided AWR Analysis and Reporting for making root cause decisions.
Experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.
Experienced in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
Solid hands-on experience in writing/editing UNIX Shell Scripts.
Experienced in Database PATCHING AND UPGRADES. Expertise in upgrading Oracle Development and Production databases.

Oracle 10 and 11g DBA (Associate)

Confidential, Houston, TX

Responsibilities:

Installed and configured many Oracle Apex instantiations on corporate servers.
Designated DBA on Servicing and Tuning 100 TB of an Oracle Data warehouse running on 6-node RAC cluster.
Ran trace such as 10046 and 10053 and ran TKPROF to find the root cause of the suboptimal execution.
Created contingency solutions in the form of RAC node failover. Also supported Physical Stand-by as part of the strategy for failover.
Extensive knowledge and experience on managing very large Data Warehouse databases.
Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.
Experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB.
Experience in Flash-Back Technology.
Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.
Experienced in Capacity Planning and Bench Marking.
Proficient in raising Service request with Oracle Support and using Metal ink to resolve the bottlenecks in the database environments.
Setup of High Availability of the database using RAC, Standby, Data guard.
Support Development teams to optimize and standardize database changes through builds and deployments. implementation and managing of RAC, Active Data-Guard, and other high availability environment.
User Account management: Creating Users, Disabling users, Responsibility management.
Troubleshoot day-to-day database issues to ensure system stability and output.
Wrote documentation for databases i.e. standards, definitions and procedures.
Maintain Oracle Data-guard physical standby database for disaster recovery.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship