We provide IT Staff Augmentation Services!

Oracle Dba Resume

Troy, MI

PROFESSIONAL SUMMARY:

  • Over 7 years of IT experience, years of extensive experience as an Oracle DBA on 11g, 12c.
  • Worked on Oracle 11g and 12c Standalone and Cluster Environment.
  • Experience in Data Center Migration.
  • Experience in setting up Oracle Data Guard.
  • Upgraded from 11g to 12c.
  • Worked on Tablespace/Extent/Segment Management worked on Backup and recoveries using user managed and RMAN.
  • Setup Oracle Enterprise Manager (OEM) 11g worked on 11g Grid Control for database monitoring / performance / diagnostics. planning and scheduling Backups, Database Recovery, taking Logical Backups
  • Maintain Oracle fail over databases (Physical and Logical standby databases - Data Guard)
  • Proficient in Oracle RDBMS including SQL, PL/SQL and all areas of database Administration.
  • Experience monitoring Oracle RDBMS availability, database exports, datapump, tablespace, and Extents fragmentation.
  • Automated Storage Management (ASM) for 11g databases.
  • Installed and Administered Grid Control.
  • Worked with Oracle on open issues.
  • Discoverer Administration including the design and administration of Business areas.

TECHNICAL SKILLS:

Databases: Oracle RDBMS 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 TOAD, data pump. 

Operating Systems: UNIX (HP-UX, LINUX)

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Troy, MI

Oracle DBA

Responsibilities:

  • Migrating/Upgrading Oracle RAC/Standalone and RDS database from 11g to 12.2.
  • Setting up datapump/RMAN backups on regular basis.
  • Working with application side directly as their need.
  • Refresh schemas as per customer s request.
  • On call 24X7 for Production database if needed.
  • Backup/restore & recovery, database monitoring & operating system configurations
  • Performing Hot/Cold backups of the database through RMAN or User Managed method.
  • Create and maintain users, roles and privileges.
  • Review alert logs and trace files to check for any problems related to the database.
  • Perform database cloning/exp/imp to setup identical databases in the production and development environments.
  • Perform Space Management & Troubleshooting the database issues.
  • Installing of quarterly security patches on all non-production and production servers.
  • Upgrading/patching GI on Rac environments.
  • Patched Oracle homes and database via OEM automation
  • Setting up OEM monitoring, installed OEM agents

Confidential, Wichita, KS

Oracle DBA

Responsibilities:

  • Configured Data Guard to provide high availability by implementing Physical stand by database.
  • Used RMAN duplicate database feature to move/clone databases on Linux.
  • Cluster Installation and Configuration, Administering databases in RAC for high availability.
  • Installation, Configure, setup of 11g RAC on Linux.
  • Add new nodes to RAC 11g Cluster to distribute the load.
  • Installed and implemented 11g RAC with 3 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.10g and 11g.
  • Database migration from 10g to 11g.
  • Designed, configured and maintained backup and recovery policies including RMAN backups.
  • SQL, PL/SQL Tuning and Monitoring.
  • Compared and contrasted multiple snapshots using AWR.
  • Tuning Wizard, and Windows Performance Monitor.
  • Recovered databases and clone applications Using RMAN.
  • Responsible for resolving several complex recovery scenarios (including RMAN) with critical production Database. extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
  • OEM Grid Control installation and configuration for monitoring and performance tuning.
  • 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.
  • 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.
  • Proficient in communicating directly with internal resources on a daily basis,
  • Able to work effectively with multiple teams at once.
  • Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for
  • Change Management practices processes
  • Solid discipline in providing end-users timely updates on their problems. Installing server software.

Environment: Oracle 10g/11g databases, 10g/11g (Active) Data Guard, 10g/11g RAC, Data pump, Export/Import, SQL*Loader, Physical Backups, Grid Control

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 setup identical databases in the production and development environments.
  • Discoverer Administration including the design and administration of Business areas.
  • Oracle Applications server including OID. Implementation of Oracle Applications Server for use with
  • Portal, Custom Forms and Reports.
  • Create and maintain users, roles and privileges.
  • 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 OEM Repository and Installing OEM 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.
  • 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/1gg

Hire Now