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.