SUMMARY

• IT Engineer and Certified Oracle DBA with 8+ years of rich hands on experience in Oracle DBA, Oracle RAC Admin, Oracle Data Guard Technology, and Oracle Apps admin.
• Expertise in configuration Oracle RAC and RAC One Database on 11g with ASM and OCFS File system on Linux, Aix and Unix OS.
• Set up and Configuration of OEM (12c/11g) Oracle Discoverer, Workflow, TOAD, Oracle Clients and backup tools like HP Data protector, IBM - Tivoli, and Symantec.
• Installation of Oracle Database (11g/10g/9i) on OS like Linux, HP-UX, AIX, Solaris and Windows etc.
• Setting up Disaster Recovery Site on 10g database using data guard method.
• Upgraded Oracle Database 9i to 10g, 10g to 11g.
• Successfully Tested RAC and RAC Once Failover scenarios.
• Applied CPU, DST and PSU patches using OPATCH Auto features.
• Created RAC Services by implementing Client-Side Load Balancing TAF features, and implemented SCAN Listener for 11gR2.
• Platform migration from Solaris to AIX (11.2.0.3) and Window to Linux (9.2.0.6).
• Strong technical knowledge on configuration of OS and Storage tasks like Creating LUN, Logical Groups, Logical Volumes, file system sharing, mail configuration etc
• Experienced in implementing backup and recovery policy using RMAN, Hot and Cold backups.
• Configured and Scheduled Oracle RMAN backup on Tape library using third party tools (DP-HP) IBM Tivoli, Symantec etc.
• Used Export/Import and Data pump utility used for logical backup.
• DBA Activities like space management, Undo segments, Invalid objects and User management with privileges.
• Expertise in various cloning method using RMAN with Active database, RAC to non RAC and ASM to non ASM.
• Configure Flashback Recovery Area and used some of features like Flashback table, query.
• Used OEM 12c/11i to perform different tuning functions like generating AWR reports, tuning advisories, real time activity monitoring etc.
• Experience in Application tuning using session trace file and TKPROF utility.
• Identified and Resolved WAIT EVENTS which cause the performance issues.
• Troubleshooting network, firewall and connectivity issue.
• Extensive experience in resolving issues and bugs related to databases with oracle.
• Relocated data centre components including storage, tape library and servers.

TECHNICAL SKILLS

Oracle Database: Oracle 11g/10g/9i, RAC and RAC One DB. Oracle Data Gaurd.

ERP: Oracle EBS R12/11i, JD Edwards, People Soft.

Operating Systems: REDHAT Linux, HP-UX, IBM AIX, Solaris, SUSE Linux, Windows.

Oracle Tools: Weblogic, Discoverer, Workflow, Developer, Enterprise Manager, ASMCMD.

Other Tools: Quest TOAD, Quest Spotlight for RAC, IBM - Tivoli, HP - Data Protector, Win-scp.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sn. Analyst (Admin)

Responsibilities:

• Configured 2 Node RAC Database 11gR2 with ASM on Solaris.
• Upgraded GRID and DATABASE Environment from 11.2.0.2 to 11.2.0.3.
• Convert Non RAC to RAC database with Non ASM to ASM (vice versa) file system.
• Configured Oracle RAC One Database on AIX 7.
• Trouble shoot patching issue related with file system with AIX.
• Cloning of Oracle Database RAC to Non RAC and ASM to Non ASM.
• Performed cloning using RMAN Active Database features.
• Advised and implement the cloning policy for test and development instances.
• Enabled Flashback recovery area and used flashback query feature of oracle.
• Configured Oracle Discoverer, Weblogic server with RAC database.
• Worked on setting up policy for database to meet ISO 27000:9001 certificate requirement.
• Re-organize database structure and relocated servers from one Datacentre to other.
• Involved in capacity and resource planning.
• Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, and volatility of the data, recovery time allowed etc.
• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Using precise identified performance bottlenecks using AWR report like queries utilizing high CPU, internal lock waits, redo log buffer waits and Cartesian joins etc.
• Used Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Relocation of servers, enclosure, storage and tape library.

Environment: 2 node RAC on Solaris, ASM, Oracle Weblogic, Oracle Discoverer (FMW), Symantec Tape library, IBM Tivoli, SPORTLIGHT for RAC (TOAD).

Confidential, Rockledge, Florida

Sn. DBA Admin

Responsibilities:

• Perform logical backup and import schema from Test Environment to Production Instance for JD Edwards ERP.
• Identified WAIT Events like LIBRARY CACHE LOCK and resolved hanging session issues.
• Code Promotion on various instances like TEST/DEV/QA environments.
• Helping the Production teams in Applications Performance Tuning and providing 24*7 Production Support.
• Analysed AWR reports for optimization of DB performance periodically.
• Created Oracle Services using TAF features of Oracle RAC DB.
• Advised Backup policy and instance strategy.
• Co-ordinated with system administration team in setting up Oracle server OS parameter.
• Involved in testing of various scenarios for fail over with High availability architecture of Oracle.
• Recommending application code changes (processing strategies, queries, use of RDBMS features)
• Daily refresh of test database by PROD RMAN backups.
• Database Sizing, Table space Management, Transaction Management, Security Administration.
• Involved in database design for other database connectivity.
• Configured database links to connect other database.

Environment: 2 node RAC on Linux, OCFS2 Oracle JDEdwards.

Confidential

Sn. Oracle DBA

Responsibilities:

• Administration and maintenance of Oracle Database 10.2.0.3.
• Upgraded Database from 10.2.0.3 to 11.1.0.7.
• Applied Rollup patches, DST, CPU patches.
• Used OPatch utility to apply patches form various oracle tool.
• Involved in Requirement Analysis, Design, and Implementation of Test Environment for UAT, Disaster Recovery Site, and Warehousing database.
• Configured Workflow E-Mail notification mailer for Inbound and Outbound mail notifications for Oracle Workflow.

Environment: HP-UX 11.21, EBS R12, HP Servers, Kintana, WinScp.

Confidential

Responsibilities:

• Installed and Configured Oracle Database 10g on Solaris.
• Tuned Solaris kernel parameters.
• Created physical standby DB using data guard method for legacy system.
• Participate in Architecture and Design of new production databases.
• Set up Cron jobs to monitor file systems usage, archive logs, backup logs and cleaning up of these file systems periodically, and also RMAN Hot Backup Scripts.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking (track, document, and correlate), Database corruption (checks database status, and periodically verifies database integrity), Low disk spaces (track and trend space utilization), Performance issues (track and trend overall database performance and database area, index, and drive performance).

Environment: Solaris, M4000/T2000 Sun Servers

Confidential

Responsibilities:

• Implementation of Oracle Database 10.2.0.3 on HP-UX 11.31 with HP EVA 4400 Storage.
• Involved in LUN, Volume Groups creation and configure storage RAID level.
• System admin and storage admin tasks for HP-UX 11.31 (IA).
• Scheduled Ignite backup for OS and root file system.
• Configured RMAN backup using Data Protector Utility (HP Backup Tool).
• Perform routine database tuning and administration activities for several Oracle databases.
• Designed and implement Backup and Instance strategy.

Environment: HP-UX 11.31 IA x64,EVA 4400, DP 6.0, EBS R12.

Confidential

Responsibilities:

• An active team member involved in administering Oracle E-Business Suite 11i Instances.
• Cloning of EBS from RAC to non RAC environment.
• Configured RMAN backups with TIVOLI Net backup utility.
• Implemented and used OEM for monitoring and maintenance of large and multiple Dbs.
• Supported multiple instances (14 Database Server) (60 Non Prod DB) with huge databases and large number of end users.
• Enhancements to existing systems as per project requirements and query optimization on Production, Acceptance and Development environments.
• Wrote monitoring scripts to check reports for space, backup, etc which are kept in crontab.
• Performed application SQL tuning using SQL Trace/Explain plan and TKPROF and database tuning for optimum performance.
• Responsible for creating tables and indexes, performance monitoring of queries, table space allocations, and data striping, and troubleshooting.
• Performed DBA preparatory steps prior to loads, and while moving data between SIT, UAT and Production systems.

Environment: AIX, Tivoli, 2 Node RAC cluster on 10.2.0.3, Toad.

Confidential

Jn. Oracle Admin

Responsibilities:

• Upgraded 9.2.0.6 to 10.2.0.3 on Windows.
• Cross platform migration from Windows to Suse Linux.
• Created tables, indexes, and assigned constraints on them.
• Provided tuning support for SGA (shared pool, buffer pool and log buffer pool etc).

Confidential

Responsibilities:

• More than 200 DB installation and remove for application testing scenario on multiple OS.
• Installed and configured Oracle 10.2.0.3 Database on HP UX, AIX, Solar1Bis, RHEL, Windows Test and Production Systems using product base utility (WINDCHILL).
• Implemented Oracle 10g RAC with OCFS2 on RHEL 4 for the demonstration and research work for the team.