We provide IT Staff Augmentation Services!

Oracle Dba Resume

0/5 (Submit Your Rating)

Oklahoma City, OklahomA

SUMMARY

  • Over 8 years of IT experience, 7 years of extensive experience as an Oracle DBA on10g, 11g and 12c.
  • Worked onOracle 10g and 11gStandalone and Cluster Environment.
  • Build RAC from scratch on Red Hat Enterprise Linux
  • Experience in Data Center Migration.
  • Experience in setting up Oracle Data Guard.
  • Experience in setting upGrid Control and 12c Cloud Control.
  • Experience in setting upASMdisk groups.
  • Experience in setting upGoldenGate.
  • Experience in Setting up Materialize View Server.
  • Worked with the many new features of 11g
  • Worked with Data Pump to clone tables, schemas and databases
  • Worked on Tablespace/Extent/Segment Management
  • Worked on Backup and recoveries using user managed and RMAN.
  • Setup Oracle Enterprise Manager (OEM) and worked on 12c cloud control.
  • Worked on Database monitoring / performance / diagnostics via dictionary views and cloud control.
  • Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).
  • Maintain Oracle fail over databases (Physical and Logical standby databases - Data Guard)
  • Worked on Oracle Tuning Pack
  • Worked on Oracle Flashback / Flash Recovery Area (FRA)
  • Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
  • Experience monitoring Oracle RDBMS availability, database exports, Data Pump, tablespace, and extents fragmentation.
  • Worked on Automated Storage Management (ASM) for 10g/11g databases.
  • Worked on much performance tuning including SQL tuning and instance tuning.
  • Worked with Oracle on open issues.
  • Provided On-call support on 24/7 basis.
  • Have written shell scripts to automate database management tasks.
  • Pose strong administrative skills in RHEL.
  • Build RAC clusters from scratch.
  • Worked on Migration project
  • Worked on Upgrade project.

TECHNICAL SKILLS

  • RAC
  • Data Guard
  • ASM
  • GoldenGate
  • ASH
  • Exadata
  • FRA
  • Export Import
  • Data Pump
  • AWR
  • Grid Control
  • 12c Cloud Control
  • Performance Tuning
  • RMAN
  • ADDM
  • Database Cloning
  • Duplicate Database
  • Migration
  • Upgrade
  • SQL / PL SQL
  • Tablespace Management
  • User Management
  • Index Management
  • Shell Scripts
  • Oracle Security

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma City, Oklahoma

Oracle DBA

Responsibilities:

  • Add new nodes to RAC 11g Cluster to distribute the load.
  • Installed and implemented 10g RAC with 4 nodes with ASM.
  • Upgraded Databases from 10g to 11g and applied patches as per requirement.
  • Worked extensively 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 9i to 10g to 11g.
  • 24x7x365 administrative support staff.
  • Configured Data Guard to provide high availability by implementing Physical stand by database.
  • Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
  • Cluster Installation and Configuration, Administering databases in RAC for high availability.
  • Installation, Configure, setup of 11g RAC on Linux.
  • Designed, configured and maintained 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 help in propagating information between databases.
  • Recovered databases and clone applications Using RMAN.
  • Proactive performance monitoring, and capacity planning for future database and server growth.
  • Performed Range Partitioning as a cause to improve the performance of the database.
  • Performed Cross platform migration using transportable tablespaces and RMAN.
  • Performed Import and Export using Oracle Data pump utilities
  • Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
  • Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
  • Used external tables and SQL*Loader to import data from flat files.
  • Monitored database space requirements and adjusted for future needs.
  • Performed version upgrades and patch installs.
  • Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration.
  • Strict adherence to policies and procedures - specifically in regard to change management.
  • Perform database administration tasks as part of a scheduled change management task.
  • Solid discipline in providing end-users timely updates on their problems. Installing server software.
  • Configured and managed agents to work efficiently with Grid Control.

Environment: Oracle 11g databases, Data Guard, 11g RAC, Data pump, Data Pump, 12c Cloud Control, Offshore Team, 24/7 on-call support.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

  • Oracle DBA duties involving development and production support such as 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.
  • Performing Hot/Cold backups of the database through RMAN or User Managed method.
  • Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
  • Review alert logs and dump files to check for any problems related to the database.
  • Perform database cloning/exp/imp to setupidentical databases in the production and development environments.
  • Discoverer Administration including the design and administration of Business areas.
  • Maintained Oracle Application Server 10g for use with Discoverer, Portal and J2EE deployments.
  • Developed PL/SQL based program for loading Data Mart.
  • Oracle Applications server including OID. Implementation of Oracle Applications Server for use with Portal, Custom Forms and Reports and Discoverer 6i.
  • Create and maintain users, roles and privileges.
  • Upgrade/Migrated the production and development databases from 9i to 10.2.0.1 to 10.2.0.2
  • Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
  • Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
  • Involved in Database sizing, Capacity Planning.
  • Perform Space Management & Troubleshooting the database issues.
  • Upgrading OEMRepository and InstallingOEM 10Grid Control to monitor all the databases.
  • Configured and managed agents to work efficiently with Grid Control.
  • Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists
  • Generated ASH, AWR, ADDM reports from Grid Control and command line.
  • Setting up privileges to create local and remote objects
  • Create materialized views to refresh data at regular intervals.
  • Using materialized view logs to reduce the replication time costs for fast refreshes.
  • Upgrading/Migration from Oracle 8i databases to 9i and to 10g.
  • Installing of quarterly security patches on all non-production and production servers.
  • Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.

Environment: UNIX, Oracle 10g/11g, Oracle, Sun Solaris, Veritas Net Backup

We'd love your feedback!