We provide IT Staff Augmentation Services!

Oracle Dba Resume

Nashville, TN

SUMMARY

  • 5 years of extensive experience as an Oracle DBA on 10g, 11g and 12c in Standalone & RAC.
  • Build RAC from scratch on Red Hat Enterprise Linux.
  • Experience in Data Center Migration.
  • Experience in setting up Oracle Data Guard and Grid Control.
  • Experience in setting up ASM disk groups and Golden Gate.
  • Set up Materialize View Server.
  • Worked with many following 11g new features. For example:
  • SQL Access Advisor
  • SQL Performance Analyzer
  • SQL Plan Manager
  • Table compression enhancement
  • Active Data Guard
  • Upgraded from 10 to 11g R2 to 12c
  • Query Result Caching
  • Invisible Indexes.
  • Database Replay.
  • AWR Baseline Enhancements
  • Automatic Memory Management.
  • Automatic SQL Tuning.
  • Data Recovery Advisor.
  • Read - Only Tables
  • Flashback Enhancements
  • RMAN Enhancements
  • Table Compression Enhancements.
  • Worked on Tablespace/Extent/Segment Management
  • Worked on Backup and recoveries using user managed and RMAN.
  • Setup Oracle Enterprise Manager (OEM) 11g and 12c cloud control.
  • Worked on 11g Cloud Grid Control for database monitoring / performance / diagnostics.
  • Used RMAN extensively to backup, restore and recover databases.
  • Managed Databases on Exadata Machines.
  • Applied CPU and PSU patches.
  • Worked extensive with developers and application team.
  • Used Data Pump and exp/imp tools to refreshes tables, schemas and databases.
  • Managed databases using ASM.
  • Managed databases using 12c cloud control and TOAD
  • Worked with Oracle on open issues.

TECHNICAL SKILLS

Databases: Oracle RDBMS 9i, 10g, 11g, 12c, RAC, Grid Control, Data Guard

DBA Tools/Utilities: RMAN, Oracle Enterprise Manager, AWR, Oracle Diagnostics Pack, dbca, dbua, SQL*Plus, SQL*Loader, Oracle Export/Import utilities, statspack, explain plain, tkprof, TOAD, 12c cloud, data pump

Operating Systems: Linux, Sun Solaris, Confidential -UX, AIX, WindowsLanguages SQL, PL/SQL, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Oracle DBA

Responsibilities:

  • Installed databases on Linux platform
  • Installed 2-node cluster
  • Provide 24x7x365 administrative support staff.
  • Configure Data Guard to provide high availability using Physical stand by database.
  • Use RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
  • Cluster Installation and Configuration, Administering databases in RAC for high availability.
  • Install, configure and setup of 11g RAC on Linux.
  • Add new nodes to RAC 11g Cluster to distribute the load.
  • Install and implement 10g RAC with 4 nodes with ASM.
  • Upgrade Databases from 10g to 11g and apply patches per requirement.
  • Work on data center migrations on multiple database versions. i.e., 9i, 10g and 11g.
  • Responsible for installing and configuring Golden Gate on Oracle Servers.
  • Database migration from standalone to RAC
  • Design, configure and maintain backup and recovery policies including RMAN backups.
  • SQL, PL/SQL Tuning and Monitoring.
  • Compared and contrasted multiple snapshots using AWR.
  • Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
  • Responsible for setting up Oracle Golden Gate to propagate information between databases.
  • Recover databases and clone applications using RMAN.
  • Use AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
  • OEM Grid Control installation and configuration for monitoring and performance tuning.
  • Proactive performance monitoring & capacity planning for future database & server growth.
  • Perform Range Partitioning to improve the performance of the database.
  • Perform Cross platform migration using transportable tablespaces and RMAN.
  • Perform Import and Export using Oracle Data pump utilities.
  • Administer and maintain database security policies and procedures.
  • Experience with administration of high-performance and large-scale multi-terabytes databases.
  • Handle all standard database administrative tasks: proactive performance tuning and monitoring, trouble-shooting, backup, recovery, installations and configurations as needed.
  • Use external tables and SQL*Loader to import data from flat files.
  • Monitor database space requirements and adjust for future needs.
  • Perform version upgrades and patch installs.
  • Applied latest patches as per evaluation requirement.
  • Performing tuning of application with Trace, tkprof, Explain plan, statspack, AWR and ADDM
  • Implemented Oracle database backup & recovery solutions using RMAN.
  • Extensive use of Oracle Data pump, Exports/Imports utility for moving data
  • Performed large batch jobs, and tuning of SQL queries and database systems.
  • Applied CPU and PSU patches.
  • Provided 24/7 on-call support
  • Worked with offshore team members.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

  • Performed Oracle DBA duties involving development and production support: installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
  • Complete Build of 4-node 10g RAC Cluster on RHEL 4 from scratch.
  • Migrated 10g database to 11g R2.
  • Skilled with statspack, AWR, ADDM, ADDM to check health of database & hardware.
  • Used Performance tuning tools such as tkprof, explain plans, oradebug and SQL Trace.
  • Performed database cloning to setup test and development database.
  • Migrated databases to different data datacenter.
  • Experienced with SRVCTL, OCR and Voting Disk of 10g RAC
  • Handled RAC Node hangs and node eviction issues.
  • Maintaining schemas and partitioning tables.
  • Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
  • Index management for better performance, maintenance of Oracle Database
  • Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
  • Responsible for administration and supporting oracle 11g, 10g and 9i databases
  • Created, upgraded, and cloned Oracle databases for Development and testing databases.
  • 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.
  • Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
  • Performed Hot/Cold backups of the database through RMAN or User Managed method.
  • Reviewed alert logs and dump files to check for any problems related to the database.
  • Created and maintained users, roles and privileges.
  • Upgraded databases from 10g to 11g
  • Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
  • Assisted in Database sizing, Capacity Planning.
  • Performed Space Management & Troubleshooting the database issues.
  • Created materialized views to refresh data at regular intervals.
  • Used materialized view logs to reduce the replication time costs for fast refreshes.
  • Upgraded/Migrated databases from 10g to 11g
  • Design and implement database backup/restore methodologies, responsible for troubleshooting performance and networking issues. Basic OS system administration.
  • Strict adherence to policies and procedures - specifically change management.
  • Perform database administration tasks as part of a scheduled change management task.
  • Work effectively with multiple teams at once.
  • Provide end-users with updates on their problems. Install server software.