Sr. Oracle DBA Resume

SUMMARY

Over 7+ years of professional experience as Oracle DBA.
Worked extensively on Oracle 11g, 10g, 9i, and 8i versions.
Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
Experience in installation, configuration and administration of Oracle 11g RAC, Oracle 10g RAC, Oracle 9i, 8i databases, Standby Databases (Active DataGuard) for High Availability, Disaster Recovery and Reporting purpose on operating systems UNIX( Sun Solaris, HP - UX, IBM AIX), LINUX (RedHat, OEL).
Worked as a team member to provide 24x7 on call production database support.
Expertise in writing SQL queries and PL/SQL codes.
Hands-on experience in Oracle 11g RAC/10g RAC implementation & administration.
Hands-on experience with RAC Clusterware configuration and patching, RAC Backup and Recovery.
Experienced in Grid installation.
Expertise in Hot/Cold Backups and Cloning of Databases.
Proficient in using Flashback Technology, Log Miner, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).
Expertise in database space management, memory tuning, and application tuning.
Expertise in troubleshooting and performance tuning.
Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
Expertise in performing database refreshes using Export and Import utilities (exp/imp) at all level. Performed the same using Data Pump Export and Import utilities (expdp/impdp) in 10g&11g versions.
Hands-on experience in Grid control, Streams, and Golden Gate.
Used Cron jobs to automate many DBA tasks.
Proficient in raising Service Request (SR) with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.
Extensively used Oracle Enterprise Manager (OEM) to do the daily tasks regarding performance and maintenance.
Good experience in Patching and Upgradation.
Expertise in upgrading Oracle development and production databases from 9i to 10g&11g.
Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM to improve the performance.
Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck. Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments.
Create database maintenance plans, including updating statistics, re indexing, structure modifications, Capacity plans, and index analysis.
Hands-on experience in implementing enterprise databases on enterprise storage solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).
Experience in database cloning with RMAN and patch management.
Hands-on experience in capacity planning.
Performed point-in-time recovery whenever needed.
Excellent communication and analytical skills.
Expertise in co-ordination and communication with system administrators, business data analysts, and development teams.

TECHNICAL SKILLS

Database: Oracle 11g RAC, Oracle 10g RAC, Oracle 9i, Oracle 8i.

Operating Systems: Red Hat Enterprise Linux (RHEL) 3.x, 4.x, 5.x, Oracle Enterprise Linux (OEL) 5.x, Sun Solaris 5.8/5.9/5.10, AIX 5.1, 5.2, 5.3, HP-UX 10.x, 11.x, Windows NT/95/98/2000/XP/2003.

Technologies: Oracle Enterprise Manager(OEM), OEM Grid Control, Datapump Import/Export, RMAN, SQL Loader, Log Miner, VERITAS Net Backup, Erwin Data Modeller, Data Stage.

Tools and Utilities: PL/SQL, SQL*Plus, SQL*Loader, Stored Procedures, Triggers, UNIX Shell Scripting, TKPROF, STATSPACK, DBMS SCHEDULER, Toad, VMware, Win SCP, Putty, Golden Gate.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship