PROFESSIONAL SUMMARY:

• Having around 10+years of experience as an Oracle Applications R12/11i Database Administrator with 11g
• RAC&12c on Exadata. Sound understanding of database requirement with a global mindset, and strong quantitative and conceptual abilities with strong database management skills. Have been working as ORACLE
• APPS DBA with Informatica handling production databases along with development and testing instances and reporting to the senior manager. Specific expertise in implementation, upgrades, Applying patches, cloning and troubleshooting of Oracle apps 11I/R12 with Informatica, SOA, and OBIEE concepts.
• Good exposure and support experience on Fusion Middleware products OBIEE, SSO/OAM Oracle
• AccessManager, Oracle Identity Management (OIM), Oracle Internet Directory (OID), WebLogic, SOA Suite andWebGate.
• Good experience working with Oracle Support for Bug fixes by raising Confidential /SRs, conducting OWC, as well as the follow - up process of Incident and Change request management for support activities.

SKILLS:

Database Administration ERP: Oracle E-Business Suite R12.2, R12.1.1, R12.1.2, Oracle-Applications DBA R12.1.3, 11i, Oracle-Core DBA-10g,11g,12c

DB Tools: Recovery manager (RMAN), Oracle RAC,

Oracle Exadata: ASM, Toad, SQL Developer, Dataguard, Exp/Imp, Oracle-Database Admin andData pump, Oracle-Enterprise Manager

O perating systems: Red Hat Linux 5, Sun Solaris on Oracle-TOAD SPARC 10.5, HP-UX PA-RISC 11.31 and Windows 2000, Oracle-Core DBA

WORK HISTORY:

Oracle Apps DBA

Confidential, Halliburton, Houston

Responsibilities:

• Sound knowledge on OEM, SQL.
• Plus, Export, Import and SQL.
• Loader as well as traditional UNIX command that requires for Oracle/ Exadata DBA.
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Implementation of Oracle Backup and Recovery strategies using COLD BACKUP, HOT BACKUP, and RMAN environment: .
• Good understanding of Exadata features like smart scans, HCC, flash cache.
• Monitoring File systems thresholds for all Exadata server, non-Exadata server, cluster databases.
• Managing Exadata database for non-prod/prod environment.
• Maintaining RAC databases.
• Relocating Services belonging to RAC databases.
• Storage and database migration from the file system to ASM.
• Small file to big file tablespace migration.
• Managed WebLogic server.
• Work closely with the developer provides Oracle DBA support and technical support for multiple applications in development, test and production environments.
• Involves in Database schema refresh activities from Production to stage.
• Experienced in Tuning: Used Explain plan and TKPROF for SQL/PLSQL Tuning; Performance tuning i.e. tuning SGA, I/O distribution using STATSPACK.
• Troubleshoots (locks, network connection etc) and documents database problems as they arise.
• Strong analytical, technical, Research, technical writer, general business, and functional skills are blended with excellent communication skills with around 8 years of working experience.
• Configuration and Creation of the database and Upgrades.
• Creating a Physical backups script using RMAN.
• Creating and implementation of RMAN With and without Recovery Catalog.
• Creating and Maintaining standby databases.

ORACLE APPS DBA

Confidential

Responsibilities:

• Oracle Application Configuration (R12.1.3) on Linux with LSH application.
• Maintaining oracle 11g (11.2.0.3) database.
• Configuration of OBIEE 11.1.1.7 with Oracle EBS.
• Experience in Data Warehouse Administration Console (DAC) setup and configuration.
• Upgradation of LSH(Life Science HUB) from2.2.0.5 to 2.2.07.
• Experience in Informatica (9.5.1,9.0.1 and 9.1.0) setup and administration.
• Experience in Informatica power center production support activities.
• Experience with ETL / EL-T Tools such as Oracle Data Integrator (ODI), Informatica or Oracle
• Warehouse Builder (OWB).
• Setting up DB Connection Pools so that OBIEE can access data from various sources.
• Applying patches from Oracle to the instance to resolve few application issues.
• Configure Oracle Enterprise Manager (OEM) and generate AWR reports for performance analysis.
• Storage task including creation and maintenance of datafiles TableSpace, Filegroup and other database structure like Rollback Segments.
• Configure scripts for database growth and archives files generation report.
• Patching with various utility using AD patch, Database patch and Application patching.
• Sysadmin Work-This involves solving different User issues in the database as well as the application end, executing sqls and scripts in the Apps domain for the users, creating DBlinks, user account creation, responsibility modification, profiles setting, granting roles and privileges to users, tracing, etc.
• Maintaining Oracle Applications R12instances Activities.
• Participate in a team to maintain & support for multiple oracle databases and applications in high availability (24 X 7) heterogeneous environment.
• Confidential creation and reviews with Oracle.

Oracle Database Administrator and Informatica Support

Confidential

Responsibilities:

• Working as Database Administrator for KPN BI RSD and also working on Informatica Power Center production support.
• Maintaining oracle 11g (11.2.0.3) database.
• The configuration of OBIEE 11.1.1.7.
• Experience in Informatica (9.0.1 and 9.1.0) setup and administration.
• Experience in Informatica power center production support activities.
• Experience with ETL / EL-T Tools such as Oracle Data Integrator (ODI), Informatica or Oracle
• Warehouse Builder (OWB).
• Setting up DB Connection Pools so that OBIEE can access data from various sources.
• Applying patches from Oracle to the instance to resolve few application issues.

Oracle APPS Database Administrator

Confidential

Responsibilities:

• Maintaining Oracle Applications R12 and Activities.
• Monitoring the Oracle Apps R12, 11g Database environments Provide applications knowledge in evaluating and improving current business processes Applying patches from Oracle to the instance to resolve few application issues.
• Follow up with oracle product support trough metal ink for any issues those functional consultants raises, which require files, system log files.
• Etc Making sure that scheduled back up jobs of an instance is going fine.
• Maintaining the Oracle Applications using Auto Patch, Ad Admin, Ad controller, Autoconfig, Rapid Clone,
• Ad Relink, License Manager and Ad Splicer etc Applications utilities.
• Cloning the instances from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams.Participate in a team to maintain & support for multiple oracle databases and applications in high availability (24 X 7) heterogeneous environment.
• Generating Statspack report and running tkprof to analyze performance related issues.
• Performing database Health checkups Troubleshooting Concurrent Manager Issues and workflow mailer issues.
• Performed System administration activities like creating users, Assigning Responsibilities, Defining Menus, creating concurrent managers Configure workflow mailer services after refresh.
• Installing and configuring Business intelligence, Oracle SOA Suite.
• Learning the fusion apps applications like Hyperion,BI,Primavera,ECM,IAM and grc.

Oracle Database Administrator

Confidential

Responsibilities:

• Monitoring the Oracle Apps 11i, 10g Database environments Provide applications knowledge in evaluating and improving current business processes Applying patches from Oracle to the instance to resolve few application issues.
• Follow up with oracle product support trough metal ink for any issues those functional consultants raises, which require files, system log files.
• Etc Making sure that scheduled back up jobs of an instance is going fine.
• Maintaining the Oracle Applications using Auto Patch, Ad Admin, Ad controller, Autoconfig, Rapid Clone,
• Ad Relink, License Manager and Ad Splicer etc Applications utilities.
• Cloning the instances from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams.Participate in a team to maintain & support for multiple oracle databases and applications in high availability (24 X 7) heterogeneous environment.
• Generating Statspack report and running tkprof to analyze performance related issues.
• Performing database Health checkups Troubleshooting Concurrent Manager Issues and workflow mailer issues.
• Performed System administration activities like creating users, Assigning Responsibilities, Defining Menus, creating concurrent managers Configure workflow mailer services after refresh.

Database Administrator

Confidential

Responsibilities:

• Applying patches from Oracle to the instance to resolve few application issues.
• Cloning the instances from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams.
• Participate in a team to maintain & support for multiple oracle databases and applications in high availability (24 X 7) heterogeneous environment.
• Confidential reviews with Oracle support personnel.
• Generating Statspack report and running tkprof to analyze performance related issues.
• Creating database users, maintaining Tablespace quotas, privileges and roles.
• Export / Import of tables, Tablespaces and databases.
• Troubleshooting Concurrent Manager Issues and workflow mailer issues.

Confidential

Oracle APPS Database Administrator

Responsibilities:

• Project & Role Description Maintaining Oracle Applications 11i and Activities.
• Applying patches from Oracle to the instance to resolve few application issues.
• Cloning the instances from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams.
• Participate in a team to maintain & support for multiple oracle databases and applications in high availability (24 X 7) heterogeneous environment.
• Confidential reviews with Oracle support personnel.
• Generating Statspack report and running tkprof to analyze performance related issues.
• Creating database users, maintaining Tablespace quotas, privileges and roles.
• Export / Import of tables, Tablespaces and databases.
• Troubleshooting Concurrent Manager Issues and workflow mailer issues.

Oracle Apps DBA

Confidential

Responsibilities:

• Maintaining Oracle Applications 11i and R12instances Activities. Applying patches from Oracle to the instance to resolve few application issues.
• Cloning the instances from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams.
• Participate in a team to maintain & support for multiple oracle databases and applications in high availability (24 X 7) heterogeneous environment.
• Confidential reviews with Oracle support personnel. Planning / consulting for database Upgrade, platform migration and R12 Upgrade