We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

4.00/5 (Submit Your Rating)

RI

SUMMARY

  • 8 years of experience in IT working as Oracle Database Administrator in Oracle 9i, 10g, 11g databases on various platforms (AIX/Red Hat Linux/HP - UX/SunOS/Windows) along wif various Oracle technologies like Real Application Clusters (RAC), Data Guard, Multi Master Replication, Oracle Automatic Storage Management (ASM). Experience in:
  • Performing daily tasks such as troubleshooting based on alerts and incidents
  • Providing production support to several 24x7 mission critical applications
  • Supporting more than 600+ databases including Production and non-production databases
  • Configuring and Implementing Oracle backup and recovery for Oracle Databases using RMAN
  • Refresh/Create database using RMAN Duplicate/Alternate host restores
  • Schema structure backup using Datapump utility
  • Installing Oracle Database software 9i, 10g and 11g,12c, Data Guard, Oracle 11g RAC, on UNIX/Linux and Windows platform
  • Upgrading various databases from 9i to 10g, 10g to 11g and 10g Standalone databases to 11g RAC.
  • Installing Grid Infrastructure for Cluster and Standalone systems
  • Applying Oracle Patches (CPU/PSUs and One-off patches)
  • Performing Database maintenance activities like Table/Index rebuilds, DDL implementation, PSU Patching, Bug Fixes
  • Scheduling jobs using CRON and DBMS JOBS
  • Database monitoring using OEM, Grid Control, Database Control, Toad
  • Troubleshooting performance issues using AWR/ASH/ADDM/Statspack
  • Hands on experience in using Oracle 10g Grid control, 12c Cloud Control

TECHNICAL SKILLS

Database: Oracle 9i, 10g, 11g, 12c, MS-Access

Operating Systems: AIX, Solaris, HP-UX 11, Red Hat Linux, WINDOWS

DB Tools: Oracle Grid/Cloud Control, RMAN, DataPump, Exp/Imp, SQL Loader, TOAD, SQL Developer, Data Guard

Programming Languages: UNIX Shell Scripting, SQL, C, Core Java

PROFESSIONAL EXPERIENCE

Confidential, RI

Sr. Oracle DBA

Responsibilities:

  • Worked as Oracle DBA to support Production and various non-prod environment and maintaining Oracle databases 11g/10g/9i on Solaris, HP-UX, AIX, and Linux
  • Monitored and supported Oracle databases using OEM
  • Actively participated in Install and configure Oracle 11g 2-node RAC database, Oracle 12c database for CRM application, applying oracle patches
  • Configured Oracle database backup using RMAN utility
  • Supported multiple projects in reviewing and applying code enhancements and application upgrades
  • Performed Data migration from flat files to Oracle database using SQL Loader

Confidential

Team Lead and Sr. SAP Oracle DBA

Responsibilities:

  • Team Lead for Oracle DBA’s to support 24/7 Production and various non-prod environment and maintaining Oracle databases 11g/10g/9i on Solaris, HP-UX, AIX, and Linux in SAP and Non-SAP environments
  • Intensively involved in teh area of Server Configuration for Oracle RAC Database Software Installation, Created standby database for Data Gaurd
  • Monitored Performance of Oracle database and performed Tuning wif Database control, OEM, Grid Control, Run AWR report and identify issue
  • Data migration for large tables using cron tab job by creating par file for Data pump.

Confidential

Team Lead and Oracle DBA

Responsibilities:

  • Led DBA team to provide 24/7 Production and non-prod enhancement support of a team sized 15 DBA’s(Onsite & Offshore)
  • Performance monitoring and tuning wif AWR and ADDM reports.
  • Create Users, Roles and Managing Security & Concurrent administration.
  • Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose
  • Database cloning, Job scheduling using cron tab in oracle Database

Confidential, Danbury, CT

Sr. Oracle DBA

Responsibilities:

  • Data migration: Participated in Migrating 7 TB Production Superdome database (Oracle 10g) to Oracle 11g environment from one datacenter to another on Linux and UNIX and windows based platform.
  • Created Oracle SR’s
  • Upgraded instance from oracle 10g to oracle 11g
  • Handled Releases (DDL, DML Changes) across different applications
  • Monitoring teh database for CPU utilization, Blocking sessions or killing unwanted user processes

Confidential, N.J

Sr. Oracle DBA

Responsibilities:

  • Install and configuration of Oracle Linux (OEL-5) on Oracle Virtual Machine Installation and configuration of Oracle VM Manager on Linux.
  • Created and Monitored Server Pool on Oracle VM environment wif oracle VM Manager. Created and monitor user for VM Manager.

Confidential, MA

Sr. Oracle DBA

Responsibilities:

  • Developed RMAN backup and recovery strategies for Oracle databases.
  • Performed tuning and query optimization.
  • Managed large tables wif partitions on tables and indexes for faster access.
  • Used AWR, ADDM, STATSPACK for Monitoring and Performance.

We'd love your feedback!