Sr. Oracle DBA Resume

TECHNICAL SKILLS

Database: Oracle 11g,10g, 9i

Database Tools: Sqlplus, RMAN, Toad, Datapump

Operating Systems: Linux, AIX,UNIX, HP, windows.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

Creating and maintaining all databases required for development, testing, education andproduction usage.
Performing teh capacity planning required to create and maintain teh databases.
Performing ongoing tuning of teh database instances.
Installation & configuration of new versions of teh Oracle RDBMS and its tools and any othertools that access teh oracle database.
Planning and implementation of backup and recovery of teh Oracle databases
Performing database re - organizations as required to assist performance and ensuremaximum uptime of teh database.
Putting standards in place to ensure that all application design and code is produced wifproper integrity, security and performance. Performing reviews on teh design and codefrequently to ensure teh site standards are being adhered to.
To assist wif impact analysis of any changes made to teh database objects.
Ability to perform both Oracle and also operating system performance monitoring and tanecessary adjustments.
Perform database tuning and performance monitoring .
Having teh knowledge of managing oracle RAC databases 11g.
A good understanding of teh underlying operating system.
Sound communication skills wif management, development teams, vendors and systemsadministrators.
Setup and maintain documentation and standards.

Confidential

Sr. Oracle DBA - Oracle Database Administrator

Responsibilities:

Up gradation from oracle 10g to oracle 11g .
Handling Severity - I,II issues and submit teh IR and RCA report for teh issue andproviding solution wifin defined timelines.
Performing production critical activities.
Good knowledge of Real Application Cluster 11gR2.
Approving POA(Plan Of Action) for database activities.
Creation and managing physical and logical standby .
Creation and managing Snapshot Standby and active dataguard .
Handling Database performance related issues.
Implementation of Oracle database hardening .
Restoration of Oracle database in different location using RMAN .
Observing gaps in daily activities and setting processes to overcome them.
Configuration of DR for critical production databases.
Performing DR-DRILL (Switchover-switchback ) activity
AWR and ADDM Report Monitoring and if required taking necessary action.
Monitoring operating system performance .
Taking Export Import Backup or data pump backup for backup purpose or for creating

Test/Development Environment

Confidential

Responsibilities:

RMAN and User Managed backup and recovery .
Installation and configuration of ASM .
Relocate teh tablespace from non-ASM to ASM, when database online .
Multiplexing of control file in ASM using RMAN .
Implementation of teh migration of database from raw storage to ASM.
Troubleshooting Logical Standby (MIS) & Physical standby (DR) related issues.
Disk space planning for next 6 months according to database growth.
Monitor teh Index for better performance.
Index Rebuilding and Stats Gather as per requirement
Reduce teh Table fragmentation and Stats Gather as per requirement for teh betterperformance of teh sql queries
Differentiating Tablespaces on storage level (Table/Index/Temp)
Purging teh oracle tables as per planning .
Creation of test databases from production one.
Onsite support and maintenance of teh database as DBA on regular basis.
Automation of backup tasks in Windows, AIX and Linux environments.
Troubleshoot database related errors and abnormalities and performed databasecorrective actions after normal business hours .
House-keeping activity for Alert log, Trace files, Listener log, Archive logs and backup ofthe database as per company standard retention policy .