SUMMARY

• 18+ years IT experience working as Oracle Exadata DBA, 12c,11g RAC DBA, ORACLE 10g RAC DBA, Senior Consultant, Database Architect and Tech lead for Confidential, Confidential . and working closely with Management Consulting companies on IT solution implementations for clients in e - Commerce, Finance and Manufacturing sectors.

AREAS OF EXPERTISE

• Creating oracle Custer File System (OCFS)
• Managing ASM instances in a RAC environment
• Use ASM & Snapshot and Replication techniques
• Veritas Cluster
• Installing and Administering Oracle Clusterware
• Install and configure ASMLib
• Configuring Automatic Storage Management (ASM )
• Creating RAC Cluster using ASM
• Convert a single-instance database to RAC
• Add a new node to your cluster database
• Extending RAC upto 16 nodes
• Removing a node from your cluster database
• Rolling upgrade of Oracle Home in a RAC Cluster
• Cloning Oracle Clusterware and RAC
• Upgrade and patch Oracle Clusterware, RAC, and RAC databases from 11.2.0.2 to 11.2.0.2.5 in a rolling fashion
• Applied Oracle Clusterware and RACCPU patches
• Managing and Monitoring RAC using Enterprise Manager Grid Control
• Implemented Oracle Applications High Availability using Transparent Applications Failover ( TAF), RAC Guard
• Creating a multiple node production RAC environment with 2 node RAC Standby using DataGuard for a true 24/7 available production system
• Configuring RMAN for RAC
• Implemented Transparent Application Failover ( TAF)for TNS connections/ETL jobs in RAC
• Implemented Oracle Fast Connection Failover (FCF)for JDBC connections
• Distributed Transaction Processing (DTP),
• Using RMANto Backup RAC environment and create backup scripts.
• RAC Performance Tuning
• Setting up and Managing Services for workload management and Applications High Availability
• Backup and Recovery of OCR and Voting file
• RAC-specific wait events, global enqueues, and system statistics
• Set performance-metric thresholds on services
• Configure services aggregation and tracing
• Configure server-side callout
• Diagnose and troubleshoot a RAC instance
• Configure the server- and client-side ONS
• Configure server-side connect-time load balancing
• Change voting disk and OCR configuration
• Enable Oracle Clusterware debugging
• Implementing Oracle Maximum Availability Architecture ( MAA)
• Implementing Oracle Streams to create a unique Reporting solution
• Implement Golden Gatefor Replication
• Implement Flash Recovery Area and also created RMAN script to put continuously updated Backup in Flash Recovery Area.
• Implemented recovery using FLASHBACK
• Configure XA and non-XA Transaction connection configuration in GridLinkin WebLogic cluster in Fusion Middleware

TECHNICAL SKILLS

Operating Systems: UNIX (AIX 5.2,HP-UX 11,Sun Solaris 2.6), LINUX, HP-UX,AIX

Backup & Recovery: RMAN Backup and Recovery, OEM Enterprise Backup UtilityVeritas Snapshot and Volume backup, NetappsSnapMirror and Netapps Snapshot, HP3PAR, COMMVAULT.

Hardware: Exadata, Supercluster, HP 9000, Sun Enterprise 6000,Sun Enterprise 10000, IBM RS 6000, LinuxStorage SAN, NASSecurity SOX, HIPAA, GLBA, ISO2700x, NIST and COBIT

PROFESSIONAL EXPERIENCE

Confidential

Oracle Exadata12c RAC, Exadata 11g RAC, Golden Gate DBA

Responsibilities:

• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Software and firmware maintenance of the Database servers in the Database machine including upgrades and patching
• Software and firmware maintenance of the Exadata Storage Servers in the Database machine including upgrades and patching
• Software and firmware maintenance of the InfiniBand Switches in the Database machine including upgrades and patching
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions
• Provide and implement performance and tuning recommendations of all components in the Database machines
• Advise, provide guidance and develop Disaster Recovery strategies for these Database machines
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Created certified processes and procedures for maintenance and upgrading of all database machines.
• OneCommand configuration on Exadata
• Upgrading Exadata environment
• Maintaining Exadata hardware
• Configure, Maintaining and trobleshhing Exadata Cell disk/Grid Disks
• Troubleshooting Exadata smartscan/offloading issues
• Bare metal restore of Exadata DB node and CELL node
• Monitoring the Infiniband Switches/ports,HCA ports on DB/CELL nodes and IB topology
• Troubleshooting Infiniband/RDS performance issues
• Configuring IORM/DBRM and Implementing Oracle Exadata best Practices
• Migrating databases to Exadata
• Setting and Monitoring Exadata using EM12c
• Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues
• Using ASMCMD to manage ASM instances
• Managing servers through DCLI command
• Utilizing Flash Cache
• Using ADRCI command to package incidents for Oracle SR
• Oracle Exadata 12c RAC and 11g ( 11.2.0.3) RAC Administration
• Looking into Long Running SQL and Performance issues
• Performance Tuning for Production jobs and critical SQL in Oracle 12c RAC and 11g ( 11.2.0.3) RAC
• Creating SQL Plan Baselines with proven good performing Plans
• Creating and Managing high availability services in oracle RAC.
• Configuring services in Oracle Grid
• Upgrade from 11g RAC from 11.2.0.3 to 11.2.0.4
• Applying Patches in Oracle Exadata 12c RAC and Oracle Exadata 11g RAC.
• Building and Managing Oracle 12c RAC and 11g ( 11.2.0.3) RAC Dataguard environments
• Building Oracle 12c RAC and 11g ( 11.2.0.3) RAC disaster recovery environment
• Participate in Disaster Recovery testing
• Participate in production switchover test exercises from Primary to Dataguard and Dataguard to Primary
• Installing and Configuring Oracle Enterprise Manager 12c and monitoring all targets from Oracle Enterprise Manager 12c
• Migrating Oracle 12c RAC and 11g ( 11.2.0.3) RAC environments to Exadata
• Managing ASM environments and adding, removing and managing disks in ASM 12c RAC,11g RAC DBA Responsibilities
• Created a Multitenant container database ( CDB) that contained 12 Pluggable Databases (PDB)
• Created pluggable databases (PDB) by cloning a source pluggable databases (PDB)
• Created pluggable databases (PDB) by moving a non- multitenant container database CDB into a pluggable database (PDB)
• Worked on Upgrades of 4-Node Oracle 10g RAC to 4-Node Oracle 11g RAC
• Worked on Upgrades of 4-Node Oracle 11g RAC to 4-Node Oracle 12c RAC
• Upgrade ASM and Grid Home
• Worked on Migration to ASM storage
• Building 4 Node Oracle 12c Data Guard RAC
• Building Oracle Disaster Recovery
• Upgrading 4 Node 10g RAC from 11.2.0.3 to 11.2.0.4 and then migrating to Oracle Exadata
• Reconfigure RAC after change in Public IP
• Reconfigure RAC after change in Private IP
• Reconfigure RAC after change in VIP
• Reconfigure RAC SCAN IP and port change
• Defining RAC Services based on Business Requirements and Load.
• Configure Oracle Enterprise Manager Grid Control to monitor environments.
• Unix Shell scripting
• Implementing security rules from SOX, HIPAA, GLBA, ISO2700x
• Implemented Oracle Database Vault
• Implemented Oracle Audit Vault
• Implemented Oracle Advanced Security
• Implemented Oracle Data Masking
• Implementing Oracle Wallet

Confidential

Oracle Exadata12c RAC, Exadata 11g RAC, Golden Gate DBA

Responsibilities:

• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Software and firmware maintenance of the Database servers in the Database machine including upgrades and patching
• Software and firmware maintenance of the Exadata Storage Servers in the Database machine including upgrades and patching
• Software and firmware maintenance of the InfiniBand Switches in the Database machine including upgrades and patching
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions
• Provide and implement performance and tuning recommendations of all components in the Database machines
• Advise, provide guidance and develop Disaster Recovery strategies for these Database machines
• Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Created certified processes and procedures for maintenance and upgrading of all database machines.
• OneCommand configuration on Exadata
• Upgrading Exadata environment
• Maintaining Exadata hardware
• Configure, Maintaining and trobleshhing Exadata Cell disk/Grid Disks
• Troubleshooting Exadata smartscan/offloading issues
• Bare metal restore of Exadata DB node and CELL node
• Monitoring the Infiniband Switches/ports,HCA ports on DB/CELL nodes and IB topology
• Troubleshooting Infiniband/RDS performance issues
• Configuring IORM/DBRM and Implementing Oracle Exadata best Practices
• Migrating databases to Exadata
• Setting and Monitoring Exadata using EM12c
• Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues
• Using ASMCMD to manage ASM instances
• Managing servers through DCLI command
• Utilizing Flash Cache
• Using ADRCI command to package incidents for Oracle SR
• Oracle Exadata 12c RAC and 11g ( 11.2.0.3) RAC Administration
• Looking into Long Running SQL and Performance issues
• Performance Tuning for Production jobs and critical SQL in Oracle 12c RAC and 11g ( 11.2.0.3) RAC
• Creating SQL Plan Baselines with proven good performing Plans
• Creating and Managing high availability services in oracle RAC.
• Configuring services in Oracle Grid
• Upgrade from 11g RAC from 11.2.0.3 to 11.2.0.4
• Applying Patches in Oracle Exadata 12c RAC and Oracle Exadata 11g RAC.
• Building and Managing Oracle 12c RAC and 11g ( 11.2.0.3) RAC Dataguard environments
• Building Oracle 12c RAC and 11g ( 11.2.0.3) RAC disaster recovery environment
• Participate in Disaster Recovery testing
• Participate in production switchover test exercises from Primary to Dataguard and Dataguard to Primary
• Installing and Configuring Oracle Enterprise Manager 12c and monitoring all targets from Oracle Enterprise Manager 12c
• Migrating Oracle 12c RAC and 11g ( 11.2.0.3) RAC environments to Exadata
• Managing ASM environments and adding, removing and managing disks in ASM 12c RAC,11g RAC DBA Responsibilities
• Created a Multitenant container database ( CDB) that contained 12 Pluggable Databases (PDB)
• Created pluggable databases (PDB) by cloning a source pluggable databases (PDB)
• Created pluggable databases (PDB) by moving a non- multitenant container database CDB into a pluggable database (PDB)
• Worked on Upgrades of 4-Node Oracle 10g RAC to 4-Node Oracle 11g RAC
• Worked on Upgrades of 4-Node Oracle 11g RAC to 4-Node Oracle 12c RAC
• Upgrade ASM and Grid Home
• Worked on Migration to ASM storage
• Building 4 Node Oracle 12c Data Guard RAC
• Building Oracle Disaster Recovery
• Upgrading 4 Node 10g RAC from 11.2.0.3 to 11.2.0.4 and then migrating to Oracle Exadata
• Reconfigure RAC after change in Public IP
• Reconfigure RAC after change in Private IP
• Reconfigure RAC after change in VIP
• Reconfigure RAC SCAN IP and port change
• Defining RAC Services based on Business Requirements and Load.
• Configure Oracle Enterprise Manager Grid Control to monitor environments.
• Unix Shell scripting
• Implementing security rules from SOX, HIPAA, GLBA, ISO2700x

ConfidentialDataGuard DBA

Responsibilities:

• Installing Oracle Clusterware
• Installed and Maintained Oracle Applications implementations on 2 node RACusing ASM
• Implementing High Availability using RAC Guard, Transparent Applications Failover ( TAF) and
• Adding and Removing nodes in RAC using Enterprise Manager Grid Control
• Adding new nodes by Cloning Oracle Clusterware and cloning oracle code
• Backup and Recovery strategy and configuring RMAN for RAC
• Using RMAN to Backup RAC environment and create backup scripts.
• RAC Performance Tuning
• Implement Oracle Virtualization
• Implement Physical and Logical Standby using DataGuard
• Implement Physical Standby using DataGuard
• ImplementRedo Transport compression to reduce redo transfer time and faster resolution of gaps in Physical Standby
• Implement Logical Standby using DataGuard
• Implement Transparent Data Encryption for specific columns in Logical Standby
• ReKeyTransparent Data Encryptiontables in Logical Standby
• Implementing Oracle Streams to create a unique Reporting solution
• Worked on configuring Capture, Stage and Apply on Oracle Streams
• Setting up Oracle Streams to load the Data Warehouse environment
• Using Oracle Streams to create Testing environments
• AdministeredGolden Gateenvironment
• Implement RMAN compression for faster backups
• Implementing High Availability storage Solution using Veritas
• Disaster Recovery Testing
• Installation and Configuration of OBIEE and Informatica
• Unix Shell scripting
• Implementing security rules from SOX, HIPAA, GLBA, ISO2700x
• Installation of Oracle Golden Gate
• Configuration of Oracle Golden Gate
• Administration of Oracle Golden Gate
• Configuring Oracle Golden Gate on for RAC and placing trail files on ASM
• Responsible for installation SQL Server 2005, 2008 database
• Create table, procedure, function, view and trigger
• Develop SSIS, DTS package.
• Configure job and maintenance plan.
• Schedule all type of backups
• Manage users and permission
• Provide 24/7 support for the database and application issues.
• Configure and monitoring Logshipping and Replication.
• Configure job and maintenance plan.
• Worked with Developers to fix performance related issues.

Confidential

Oracle 11g,10g RAC DBA

Responsibilities:

• Installing Oracle Clusterware
• Installed and Maintained Oracle Applications implementations on 4 node RAC
• Implementing High Availability using RAC Guard, Transparent Applications Failover ( TAF) and
• Adding and Removing nodes in RAC using Enterprise Manager Grid Control
• Adding new nodes by Cloning Oracle Clusterware and cloning oracle code
• Backup and Recovery strategy and configuring RMAN for RAC
• Using RMAN to Backup RAC environment and create backup scripts.
• RAC Performance Tuning
• Cloned databases using Snapshot and SnapVolume technology from Veritas and IBM
• Upgrade database from 10.2.0 to 11.2.0.1 in DEV, TEST and PROD
• Implement Oracle Virtualization
• Worked on environments with storage on SAN and NAS.
• Implement Physical Standby using DataGuard
• ImplementRedo Transport compression to reduce redo transfer time and faster resolution of gaps in Physical Standby
• Implement Logical Standby using DataGuard
• Implement Transparent Data Encryption for specific columns in Logical Standby
• ReKeyTransparent Data Encryptiontables in Logical Standby
• Implementing Oracle Streams to create a Reporting Environment
• Worked on configuring Capture, Stage and Apply on Oracle Streams
• Setting up Oracle Streams to load the Data Warehouse environment
• Using Oracle Streams to create Testing environments
• Implement Golden Gatefor Replication
• Implement RMAN compression for faster backups
• Creating index on Oracle Spatial Tables
• Implementing a RAC solution using VeritasClusterware
• Installed SOA suite
• Created SOA Load Balancing and High Availability environment
• Oracle SOA -BPEL Administration
• Used Oracle Enterprise Manager 10g Application Server Control to configure OC4J groups
• Installation and Configuration of OBIEE, Informatica and DAC Unix Shell scripting
• Implementing security rules from SOX, HIPAA, GLBA, ISO2700x
• Responsible for installation SQL Server 2005, 2008 database
• Create table, procedure, function, view and trigger
• Develop SSIS, DTS package.
• Configure job and maintenance plan.
• Schedule all type of backups
• Manage users and permission
• Provide 24/7 support for the database and application issues.
• Configure and monitoring Logshipping and Replication.
• Configure job and maintenance plan.
• Worked with Developers to fix performance related issues.

Confidential

Oracle 10g,9i RAC DBA

Responsibilities:

• Load Balancing using Distributed Transaction Processing (DTP)
• Setting up and Managing Services for workload management and Applications High Availability
• Distributing Workload across different nodes
• Installing, cloning, upgrading, patching and Troubleshooting Oracle Applications 11.5.10.2
• Installing, cloning, upgrading, patching and Troubleshooting Oracle Applications Rel12
• Define Oracle Applications implementation Architecture for clients depending on their requirements. Mostly implementing Load-Balanced, Highly Available Architecture with Multiple Tiers on different platforms.
• Implement Physical and Logical Standby using DataGuard
• Created Reporting Environment using Quest’s Shareplex
• Implemented Backup and Recovery solutions using RMAN
• Cloned databases using Snapshot and SnapVolume technology from Veritas and IBM
• Worked on environments with storage on SAN and NAS.
• Performance Tuning Oracle Application modules ( GL,AP,AR,INV,PO)
• Creating RAC using Veritas Cluster on Solaris server