SUMMARY: INFORMATION TECHNOLOGY PROFESSIONAL
Expertise in: Oracle Database (RAC, ASM, RMAN, DR) Administration

• Highly accomplished, innovative and deeply driven Oracle and database professional with 7+ years of Oracle/Information Technology experience in which 6+ years DBA and infrastructure Management Experience Globally with around 3+ years with active RAC (Real Application Cluster) and Data Guards experience as a 24X7 Database and Application DBA on all flavors of Oracle (7.x/8/8i/9i/10g/11g) RAC and non-RAC environments with Disaster Recovery setups and ASM storage architecture. I am experienced on Oracle Streams using Oracle Packages as well as Golden Gate.

• Oracle Certified DBA.
• Working in team of 5 to 7 DBAs as a team member and managed many database and infrastructure projects.
• Extensive experience on 2Nodes, 3Nodes and 4Nodes Oracle RAC (9i/10g/11g) on AIX 5L / 6.1, Red hat Linux AS 2.x/3/4/5, Sun Solaris 8/9/10 OS platform using Oracle Clusters (oracm, CRS and latest 11gR2 Grid Architecture) along with all other latest Oracle Databases technologies setups like ASM and OCFS including Preparation of OS Environment and storage for RAC, installation, patching, Upgrades (normal as well as rolling upgrades), maintenance and adding and removing Nodes in current RACs and doing through testing of all RAC nodes using FEMA guidelines at Server Level, Interconnect, Failover/load balance and Database level. Numerous 9i to 10g to 11g RAC and no-RAC upgrades experience.
• Actively involved designing and executing Disaster Recovery / Business Continuity Plan using Oracle Data guard with failover / switchover scenarios and other technologies like snap mirror.
• Actively involved in setting up Stream environments with Oracle Packages/Golden Gate for data sharing between distributed databases.
• Sound experience on Oracle ASM Technology (ASMLib setup, creating disks using oracleasm, migration to and from file systems, moving database from one ASM disk groups to another, disk groups management, adding/removing disks from disk groups, manual rebalance etc) with variety of storages like IBM ESS series Storage DS8100/8300 and Shark with SVC (SAN Volume Controller), HDS and EMC.
• Worked in environments of small 20 GBs size databases up to 4 TB Size Databases/DW.
• Extensive experience of setting up Oracle Enterprise Manager & Grid Control and database control for monitoring, tuning and managing Oracle RAC and non-RAC Environments.
• Right now working as a Database team member with a group of DBAs for client MFX FAIRFAX
• Thorough understanding and experience of Oracle Database Server, Architecture and Instance, Logical and Physical Structures and B/G Processes, Database Planning, Installation / Creation / Up Gradation / Migration, Managing Users/Roles/Privileges and Utilities like SQL*Loader, Export, Import, Data Pump and ETL Processes.
• Sound RMAN experience of Backup, Restore, Cloning and Point in time Recovery in different scenarios and requirements using RMAN, Data pump and Flashback with different backup technologies like VERITAS Net Backup, TSM, Commvault, SQL Backtrack and logical backups like export dumps.
• Wide experience of Tuning and Optimizations for good Throughput and Performance including RAC/Cluster related performance issues.
• Evolving self for new and updated technologies in Oracle, keeping pace with upcoming Oracle releases, technologies and putting those in practice in day-to-day work.

Technology Snapshot

RDBMS: Oracle 8/8i, 9i and 10g(R1&R2) RAC, 11g(R1&R2) RAC, Data Guard.
Job Function: DBA
OS/Environment: AIX 4L/5L/6.1, HP-UX 9.0.x/11.x, SOLARIS 8/9/10, Red Hat Linux ASE 2.1/3/4, Windows Servers 2000/2003
CASE/DBA Tools: CA Model Mart, ERWin, 9iOEM/10gGrid, TOAD, Exceed, Golden Gate
Monitor Tools : SQL Analyzer, OEM, 10g GRID with OCM, RDA, Quest Spotlight

Education

Professional Qualification

OCP-DBA
B.S (IT) US Equivalent.
Credential Evaluation Report.

Employer: : Confidential,LLC
Clients: : Confidential,
Title: : Database Administrator
Date of Employment: : May 2011 To Till date

Employer: : Confidential,
Clients: : Confidential,
Title: : Database Administrator
Date of Employment: : JAN 2010 To April 2011

Employer: : Confidential,
Clients: : Confidential,
Title: : Database Administrator
Date of Employment: : FEB 2008 To NOV 2009

Employer: : Confidential,
Clients: : Confidential,
Title: : Oracle DBA
Date of Employment: : NOV 2005 to OCT 2007

Employer: : C.G.Web Solution
Title: : Oracle DBA
Date of Employment: : Jul 2004 to AUG 2005

Employer: DataCede staffing LLC
Project: Confidential,
Role: working as a Team member
Platform: IBM-Mainframe, AIX 5.2 / 5.3/ 6.1, RHL AS 2.1/3/4, Windows 2000/2003
Technology/Software: Oracle 9i/10g/11g RAC with ASM, 10g/11g EM Grid and Data Guard,
Client: Confidential,New Jersey, USA

Employer: Software programming and consulting Inc
Project: ASCAP Infrastructure and DR Support
Role: working as a Team member
Platform: Solaris 8 / 9 /10, Red Hat Linux AS 2.1/3,OELinux 4,5
Technology/Software: Oracle 9i/10g/11g RAC with ASM, 10g EM Grid and Data Guard,
Client: Confidential,New York, USA

Confidential, is Technology Company providing critical business solutions in the areas of insurance technology; data center outsourcing and managed application services. Manages oracle, Sql databases for different clients in MFXFairfax Dataceneter.

As a part of DBA Role, all databases have to be managed on daily basis to support ongoing Projects as well as new application developments. As a part of HAA, 2 and 3Nodes Oracle 9i, 10g and 11g Real Application Clusters (RAC) are set on IBM pSeries Servers (p4/p5/p6) on AIX 5L/6.1 and RHL AS 3/4 Platforms using Oracle Clusters with Latest technologies like ASM on IBM ESS series Storage DS8100/8300 (RAID5) controlled by SVC and for various Development, QA, Staging and Production work along with Data Guards in Production for Disaster Recovery Purpose.

• Oracle Database Backup and Restore Operations redesign using RMAN and TSM
• Single Instance 8i/9i Databases to be merged, upgraded to 10g and migrated to 10g RAC
• Oracle Database Upgrade from 9i RAC with HACMP to 10gRAC with CRS
• Migration of Oracle Databases from GPFS File System to ASM
• Implementation of IBM SAN Volume Controller (SVC) for storage virtualization
• New IBM Servers (p6 570s) Evaluation for Oracle Applications and Databases
• Implementation of latest Oracle 10g Grid Control for Database Management

Project: Confidential,
Role: Oracle DBA
Platform: Solaris 8 / 9 /10, Red Hat Linux AS 2.1/3
Technology/Software: Oracle 8i, 9i/10g RAC, Data Guards, VERITAS Clusters/ CRS.

• Design and successfully execute DR strategies using 10gR2 Data Guards
• Designed and implemented RMAN backup strategies for active DR/BCP.
• Implemented Oracle 10gR2 Grid.
• OCFS Implementation and OS Level setup for RAC
• Implementing 10gR2 RAC using ASM on Solaris 9/10
• Providing 24X7 On-call Support.
• Implementation of active Oracle Monitoring using SMARTS, Grid and Shell Scripting.

Employer: Confidential,
Project: Confidential,
Role: Oracle DBA
Platform: HP-UX 9.x/11.x, AIX 4.x/5.x, RHL AS 2.1/3, Sun Solaris 9/10, Windows 2000/2003
Technology/Software Oracle 7.x/8/8i/9i/10gR2 RAC and non-RAC,
Responsibilities:

• Handling Installation and creation of new oracle databases, 2Nodes/3Nodes/4Nodes Oracle 9i /10g RAC, Oracle Data guard. Adding Nodes in Present RACs
• Preparing OS Environment for Database, especially RAC environment doing through testing of all RAC nodes using FEMA guidelines at Server Level, Interconnect, Failover/load balance and Database level.
• Installing OCFS, Formatting Storage, converting to OCFS. Mounting OCFS Devices.
• Setting up ASM for 10g RAC
• Setting up 9i OEM environment and 10g Grid and 10g Database Control
• Up gradation, migration, cloning and patching of Databases, RAC and Data guards.
• Database Fail over / Switch over activities for maintenance and time-to-time DR drills with Oracle9i/10g Data guard.
• Maintaining up-to date security of the Oracle Database applying Critical Security Patch releases by oracle. Testing & applying patches & bug fixes for new releases
• Backup, Restoration, Cloning and Recovery in different scenario
• Hot and Cold backups
• Backup and Recovery with and without RMAN
• Complete / Incomplete Recovery
• RMAN with different MML Clients like Veritas, TSM, Commvault
• Continuous monitoring of Database Performances and identifying any bottlenecks hindering the performance of the database
• Extensively involved in maintaining & updating the database documentation
• Writing housekeeping and monitoring Shell scripts for various databases.

Employer: Confidential,
Role: Database Administrator
Platform: Solaris 8, Windows 2000
Technology/Software: Oracle 8i, C++ Builder, PHP, Crystal Reports
Responsibilities:

• System Requirement Analysis and designing data Models for New Databases
• Existing Database analysis, normalizations, de-normalization and designing
• Centralize Security design and programing using SQL/PLSQL using Oracle Provided Security features. Production Database installation, setup and monitoring.