SUMMARY

• Over 11 years of experience as Oracle DBA, worked on 24/7 production support and project implementations of Oracle 11g/10g/9i/8i databases on Various Platforms.
• Excellent 24/7 production support experience, can work in On call and shift rotation support.
• Excellent experience in Oracle multi nodes RAC 11G & 10G and administration of ASM.
• Expertise in Oracle Data guard 11G and 10G, data guard broker, observer. Implemented various active - passive and active-active data guard projects with Max availability and zero lag.
• Designed and implemented backup and disaster recovery strategies. Logical backup using and full/ partial export/import and Data Pump. Effective used conventional and RMAN for backup and recovery.
• Experience in Performance Tuning of databases, gather stats, AWR report, Sql query tuning and execution plans.
• Excellent experience in Cloning, Upgrade, Installation, Patching, Troubleshooting and Administration of various components of E-Business Suite 11i & R12.
• Worked on database and RAC upgrade projects like 10G to 11G with Raw file system to ASM conversion.
• Administration of Oracle E-Business Suite concurrent managers and jobs, troubleshooting of long running concurrent jobs.

TECHNICAL SKILLS

Oracle Applications: Oracle Application Rel 12.1,, 11i

Tools: & Utilities: Rman, OEM

Operating Systems: Sun Solaris 2.10,2.9, 2.8, Red hat Linux 2.4, 2.5

RDBMS: Oracle 11G, 10G, 9i and 8i

High availability: Oracle RAC 10G, 11G, ASM, Oracle data guard, OS clustering, Golden gate

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Implementation and administration of Oracle 10G, 11G multi nodes RAC.
• Administration and implementation of ASM with NetApp / EMC SAN
• Convert stand alone Oracle 10G database to Oracle 10G two nodes RAC.
• Setup and configure Rman proxy backup and recovery with the help of storage admin using SAN deport-establish-split-import.
• Implementation of Active/Passive Metro virtualized Data Center model (MVDC), Primary/Standby instance using Oracle 10G, 11G DataGuard, DG broker and SAN storage.
• Administration of E-business suit 12.1, 11.5.10 using AD utilities
• Administration of Concurrent manager and troubleshoot concurrent requests related issues.
• Apply AD patches to E-business suit 12.1
• Manage and apply changes on middle and database tier using auto config
• Upgrade of 10G CRS to 11G Grid infrastructure
• Upgrade of 10G database to 11G database.
• Migration of databases using data pump and transportable tablespaces method
• Implementation and administration of Oracle 10G Data Guard and DG Broker in maximum availability mode on two nodes RAC.
• Implementation and administration of Data Guard Fast Start Fail Over (FSFO) and Observer.
• Testing of Active / Passive Data Guard switch over and Fail over.
• Extensive experience in troubleshooting of Data Guard and Broker related issues happen during Primary and Standby role switch over.
• Administration and configuration of Oracle Golden gate.

Confidential

Oracle DBA

Responsibilities:

• Worked as production support Onsite DBA lead of Oracle application 11.5.10, 11.5.9, oracle databases 8i, 9i, 10G and 11G.
• Managed and provided 24/7 support of production databases, weekend On call support for critical production issues.
• Experience in Oracle application and database failover setup using Symantec veritas cluster
• Installation and administration of Oracle two node RAC 10G, 11g.
• Analysis and application of AD patches on Oracle application.
• Cloning of Oracle database & application using RMAN restore, rapid clone and autoconfig
• Implementation and administration of parallel concurrent processing.
• Migration of Oracle application and databases to new hardware.
• Implementation and administration of custom concurrent manager queue and set specialization rules.
• Maintenance of Oracle Applications using AD utilities
• Managing concurrent managers and jobs, troubleshooting of long running concurrent jobs.
• Configure and administration of Apache load balancing for Oracle application
• Backup and recovery of databases using RMAN and sync/split netbackup.
• Migration of database backup from hot/Rman filer type backup to Rman Netbackup.
• Cloning/refresh of Oracle databases using RMAN, hot backup, cold backup and exp/imp.
• Upgrade of oracle databases from 9i to 10G/11G
• Database character set conversion to UTF8
• Databases performance analysis and health report
• Proactive database monitoring by setting up UNIX shell scripting
• Application of Oracle RDBMS patches like DST, security and bug patches
• Sql and database performance tuning with the help of Ignite tool and AWR reports.
• Document/SOP for day to day Operations support tasks and KT to new DBA.
• To meet SOX control, work and coordinate effort of half yearly password changes of all the accounts related to Oracle application and database.
• Yearly SOX in-scope Oracle databases restoration from tape backup and get business sign off
• Provide data, change evidence and change approval to internal and external auditors.
• Review and remediate database security and control failure with SOX PMO team.
• Understanding application owners/users requirements and issues related to Oracle application and databases and providing timely resolution.

Confidential

Oracle DBA

Responsibilities:

• Administration and support of Oracle E-business suit 11.5.9, 11.5.10 and 9i RDBMS.
• Cloning and patching of Oracle application 11.5.9, 11.5.10
• Administration of Oracle concurrent manager, maintenance of Oracle application using adadmin, autoconfig.
• Oracle apps sysadmin activities like creation of users, responsibilities, printer setup and profile update.
• Backup, restoration and recovery of Oracle databases.
• Open and follow up Oracle SR(Tar) for application and databases related issues.
• Work on users request and issues related to Oracle database and application issues.
• Member of project team of oracle application 11.5.9 to 11.5.10 upgrade along with UTF8 migration.
• Monthly release and code migration to Production.
• Troubleshooting of concurrent manager related issues, long running jobs.
• Creation and administration of concurrent manager work shifts.
• Troubleshoot database performance related issues.
• On-Call DBA for 24x7 support of P1 issues

Confidential

Oracle DBA

Responsibilities:

• Oracle application DBA Operation support and implementation of oracle application 11.5.5, 11.5.9, 11.5.10 instances for various North American clients. Role was to provide Offshore Oracle Applications DBA Operation support for Multiple North American projects.
• Maintain, Administer Oracle Production Environment and other Oracle products of Large DB Size (> 1 TB)
• Cloning various instances for development as per the requirements.
• Maintain, Administer Oracle Databases and other Products during the project.
• Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, Contention Resolution scenarios for the various Environments.
• Setting up users, responsibilities, and printers, registering of forms and reports, setting-up profile options.
• Administered Multi-node installation of Oracle Applications.
• Performance tuning at both application and database level.
• Configuration of Autoconfig, Oracle Applications Manager and Generic Service Management.
• Tuning the database and the Applications including Oracle Concurrent manager.
• Worked on adadmin utilities to maintain Oracle Applications.
• Applied Maintenance packs, Family packs and one-off patches.
• Performed patch analysis for patches involving lot of pre-requisites.
• Used the Patch Merge feature for merging lot of patches.
• Configuration of Shared Pool, DB Block Buffer, Redolog Buffer and Initialization Parameter file for optimum performance of database.