PROFESSIONAL SUMMARY

• Extensive experience in Real Application Clusters RAC Planning, Real Application Testing RAT , Configuring and Implementation, Performance Tuning, backup and Recovery of RAC databases using RMAN.
• Experience in installation, upgrades, TAR support, patches. Duties included database creation, backup/recovery, tuning/reorganization, cloning, user and security management, general troubleshooting, auditing, and configuring servers.
• Designed and implemented backup and recovery strategies. Logical backup using and full/ partial export/importand Data Pump. Effective used conventional and RMAN for backup and recovery.
• Upgrading Oracle RAC CRS/ASM/RDBMS from oracle 10.2.0.4 to 11.1.0.7
• Experience in OLTP and datawarehouse databases.
• Migrating Standalone 8.1.7 and 9.2.0.8 databases to RAC 10.2.0.4
• Implementation of 10GR2 4-node and 8-node RAC with Oracle ASM Automatic Storage Management on AIX environment.
• Migrated databases from oracle 8i, 9i, and 10g on red hat Linux platform to oracle 10g RAC in 11g on development, integration and production environment using Import/Export, performance tuning tools PerfStat, AWR,ADDM .
• Experience in Database resource manager DRM for RAC and non RAC databases.
• Experience of High Availability of Service in RAC.
• Extensive experience in Data Guard Implementation - Physical and Logical.
• Worked on 2 nodes, 4 node RAC Real Application Clusters databases on Solaris 10, AIX and Linux.
• Provided support to application team to solve all database related issues.
• Installed and Configured RAC on IBM-AIX 10g with 4 nodes server side load balancing using Automatic Storage Management.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Successfully implemented physical and logical standby database using Oracle Data Guard feature for High availability configuration.
• Experience in advanced recovery methods like PITR and TSPITR.
• Supported the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours.
• Experience in maintaining and monitoring databases By Oracle Enterprise Manager OEM .
• Experience in installation OEM 10.2.0.4 Grid Control database server.
• Experience in U pgrade and Migration of oracle database to higher version and other platforms using Oracle Data Migration Assistant.
• Experience in P erformance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Configured and implemented Oracle Streams Advanced Replication for high availability. Also worked on Distributed Database Experience in SQL query optimization using explain plan, Utlbstat/ Utlestat, TKPROF reports, gathering statistics, Running scripts, pinning the objects.
• Troubleshoot Database performance issues using Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM .
• Design and debug Perl database backup script, and other Monitoring script.
• Experience in full life cycle of database administration. Worked both as a development and Production Support DBA .
• Quality Assurance for databases before and after migration.
• In-depth knowledge of setting up RMAN backups and maintaining catalog schema. Proficient in creating auxiliary and duplicate databases using RMAN
• Experience with OEM agent and GRID control Installation and configuration.

Technical Skills:

Sr. Oracle Database Administrator December 2010 TO till date

Oceaneering is a global oilfield provider of engineered services and products, primarily to the offshore oil and gas industry, with a focus on deepwater applications. Through the use of its applied technology expertise, Oceaneering also serves the defense and aerospace industries.

Roles and responsibilities:

• Refreshing RAC cluster development databases using production database
• Upgrading Oracle 9i non RAC databases to 10G and 11G RAC cluster databases.
• Upgrading Oracle ASM/CRS/RDBMS from 10.2.0.4 to 11.1.0.7 on Unix servers.
• Installing Grid control system using multiple OMS RAC OMR.
• Installing Oracle 10G RAC software on 4 nodes cluster using ASM
• Installing Oracle 11GR2 11.2.0.3 RAC using Oracle Automatic storage management ASM
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Created standby database and worked with data guard to provide high availability.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Auditing and security with Oracle databases
• Migrated databases from Oracle 10.2.0.2 on window 2003 to Oracle 10g on IBM-AIX development, integration, production environment using Import/Export.
• Implemented 6-node RAC using Oracle Clusterware software and ASM Automatic Storage management .
• RMAN setup and writing RMAN shell scripts for automate the backups.
• Working on Replication and streams .
• Applied CPU patches and other patches as required.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Applying CPU patches on RAC and Non RAC clusters.
• Migrating databases from 11G RAC and Non RAC cluster databases to RAC clusters.
• Real Application Testing RAT
• Tuned poor written queries by adding indexes and gathering stats.
• Creating performance report including the database growth.
• Generating and analyzing the AWR report for all the databases every week.
• Supporting production and development database.
• Applying CPU and Bundle 3 patches on 10g RAC environments.
• Creating RAC services with available and preferred nodes.
• Implemented both Server side and client side load balancing for RAC databases.
• Migrating databases from oracle 9i standalone to oracle 10g 4 node RAC.
• Created and Managed user, table spaces, data files and archive log.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Worked on Backup and Recovery using RMAN .
• Worked on oracle Public and Private Database Link
• Worked on creation, rebuild Indexes and moved it across different tablespaces.
• Oceaneering International Services Limited. Houston, TX PeopleSoft Database Administrator December 2010 TO till date
• Well versed with PeopleTools- 8.4X, Application- 8.8, 8.9 and 9.0 releases.
• Providing 24 7 support on PeopleSoft Production instances
• Expertise in PeopleSoft Apps Installation Configuration and troubleshooting Oracle Configuration Manager for PeopleSoft Installations: OCM-10.3.3.2.0
• Adding Web Applications in OEM to monitor availability of Production and non production PeopleSoft Instances
• Installation of OCM on Peoplesoft web, application Servers and Process schedulers
• Configuration of PSEMHUB, PSEMAGENT, PSEMHUBURL on Web servers, Application servers and Process Scheduler
• Checking the status of Collection and scheduling the collection for PeopleSoft Installations
• Maintenance and Support of various PeopleSoft Instances like FSCM 8.8/8.9 , HRMS 8.8/8.9/9.0 , FSCM Brazil, Portal Solutions 9.0
• Installation of OCM on Peoplesoft web, application Servers and Process schedulers.
• Configuration of PSEMHUB, PSEMAGENT, PSEMHUBURL on Web servers, Application servers and Process Schedulers
• Checking the status of Collection and scheduling the collection for PeopleSoft Installations

Tools:

• Oracle Enterprise Manager Grid Control: OEM version:10.2.0.5
• Shut down and Startup of OEM grid control .
• Declaring Blackout in OEM during Application maintenance..
• Installing OEM agent on Linux, as well as Windows servers.
• Troubleshooting issues with web applications, Metrics and Threshold settings
• Trouble shooting issues with OEM agents .
• Oracle Configuration Manager for PeopleSoft Installations: OCM-10.3.3.2.0 .
• SQL Server: MSSQL Server 2000 ,MSSQL Server 2005 ,MS SQL server 2008
• Creation of new database.
• Backup of SQL databases.
• Setting up of Log Shipping for SQL databases using utilities like SQLSAFE.
• Installation and configuration of monitoring tool for SQL servers.
• Professional Experience:
• SSI-SLR Infotect Pvt ltd. Oracle Database Administrator Sr. Oracle Database Administrator April'O4 TO Nov '10
• SLR Infotech Pvt. Ltd. having development office in INDIA and Office in California USA is one of the leading Software Development Company with extensive experience in designing and development cutting edge software solutions.
• Roles and responsibilities:
• Creation and configuration of Oracle RAC database of various sizes 200GB, 400 GB in Dev, Model and Production environments.
• Created 10g databases using DBCA on AIX platform.
• Database Architecture and designing.
• Configuring and maintaining Oracle Streams.
• Install 11gR1 and 10gR2 RAC Clusterware software on AIX and Linux Servers.
• Oracle 10g installation and database creation with ASM.
• Responsible for 10G RAC installation using Oracle Clusterware Software.
• Implemented 6-node RAC using Oracle Clusterware software and ASM Automatic Storage management .
• Responsible for monitoring RAC interconnect performance.
• Refreshing RAC 10g development databases with production databases.
• Responsible for tuning and maintaining of Oracle RAC databases.
• Applying CPU and Bundle 3 patches on 10g RAC environments.
• Creating RAC services with available and preferred nodes.
• Implemented both Server side and client side load balancing for RAC databases.
• Migrating databases from oracle 9i standalone to oracle 10g 4 node RAC.
• Configuring the load balancing and creating RAC services.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Cloning database using RMAN.
• Backup and recovery using RMAN.
• Creating 3 node standby databases for 3 node RAC cluster databases.
• Created standby database both logical and physical and worked with data guard to provide high availability.
• Creating ASM diskgroups for Flashback recovery Area and Datafiles.
• Debug database backup script and other Monitoring script.
• Worked on Auditing and security with Oracle databases..
• Monitor and Configured Oracle 10g databases using OEM .
• Worked with Functions and profiles.
• Worked with Flash Recovery Area.
• Created and Managed user, table spaces, datafiles and archive log.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Worked on Backup and Recovery using RMAN .
• Worked on oracle Public and Private Database Link
• Worked on creati