Oracle Applications DBA (11i, R12, RAC) – Perm, Contract, C2H, Available for Phila Area

June 24th, 2013
Experience: Oracle Applications E-Business Suite 11i and R12
Available: Immediately
Location: Greater Philadelphia area, NJ, NY, DC, VA, MD
Travel:
Rate/Salary: VERY Competitive (both salary or on a billable basis)
Contact: mzahour@proactivestaff.com or call 610.933.5700

 

What makes her stand out from the rest:

  • Over 8 years of significant Oracle Applications DBA experience and very good communication skills.
  • Just completing a long term contract with a company in the King of Prussia area where she is supporting seven Oracle Applications environment and over 200 instances.
  • Targeting a permanent FTE position.
  • Extensive experience with Oracle Apps 11i and R12 and database from 9i to 11g on RHEL, AIX, Solaris, Windows platforms. Full lifecycle experience: installation, configuration, upgrade and support.
  • Experience in configuration, managing and monitoring of RAC (11g on Linux), ASM, Dataguard and also with Oracle tools like RMAN, SQL Developer, Data Pump, SQL Loader etc. Experience in installing, configuring, supporting OBIEE 11g, Oracle 11g Middleware/Fusion products DBA, supporting, Hyperion 11g, OID/OAM 11g version.
  • Extensive experience with operational tasks: backup and recovery, cloning, performance tuning, etc.

 

Expertise:

  • Over 8+ years of experience as Oracle 11g/10g/9i DBA and Oracle Applications (ERP) 11i/R12 DBA.
  • Over 3+ years of experience as Oracle 11g Middleware/Fusion products DBA, supporting OBIEE 11g, Hyperion 11g, OID/OAM 11g versions.
  • Expertise in Installation, maintenance, upgradation, administration, backup and recovery of Oracle database and has significant experience in Oracle 11i/R12 E-Business suite system administration, database administration including installation and upgrades of the Oracle Applications 11i/R12 and Products registration as well as end user support.
  • Performance and Tuning: Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, AWR reports, ADDM Reports, Tkprof and Explain Plan Methods and knowledge in INDEX REBUILDING and INDEX TUNING.
  • Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import) and proficient in RMAN.
  • Expertise in implementing EBS Workflow Notification Mailer with various kinds of SMTP/IMAP servers and   troubleshooting Workflow and Notification issues
  • Very good Experience in Standby, Data Guard, Database Security and Auditing.
  • Proficient in physical/logical design, SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers
  • Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
  • Hands on Experience in using tools like Data Pump, SQL* Loader, Oracle Streams.
  • Performed Instance Cloning, Code migration processes, Oracle grid-control.
  • Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN(RMAN Duplicate), VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).
  • Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).
  • Have exposure to Automatic Storage Management (ASM) configuration.
  • Experience in configuration management with AutoConfig and Maintenance of Oracle Applications 11.5.8, 11.5.9, 11.5.10, 12.0.x, 12.1.x with single and Multi node environments.
  • Experience of Oracle Applications upgrades (11.5.10 to R12, 12.1 to 12.3) process.
  • Experience includes Backup & Recovery using RMAN, Performance Tuning using TOAD, OEM and Confio tools, DB Security, Patching, Cloning using Rapid Clone, Unix Shell Scripting, cronjobs, perl scripting.
  • Worked in a Team of database administrators in a large IT shop/Data Centers with hundreds of Databases.
  • Expertise in implementing Shared APPL_TOP for multi node Architecture for both internal and External Tiers (DMZ) and also experience with PCP implementation.
  • Experience in Oracle APEX (formally known as HTML DB) including installation, upgradation and custom code troubleshooting.
  • Extensive working experience in OBIEE & UPK administration.
  • Recently implemented Oracle Access Manager 11g with Oracle E-Business Suite as a Single Sign-On Implementation.
  • Experience in Implementing SSL for Oracle E-Business Suite Applications
  • Experience with Single Sign On and OID registration with E-Business Suite and Oracle Portal Administration including installation and cloning.
  • Experience in Oracle Support management, EBS Concurrent Managers administration, shell script development, documentation of various EBS patching, cloning, upgradations and new employee training.
  • Experience includes Oracle Discoverer 10g installation, upgradation, and EUL migration and Cumulative Patching.
  • Experience includes E-Business suite patching of ATG.RUP.4,5,6,7 and JDK & JRE plug-in upgrades, Developer 6i patchset upgrades, 17,18,19 and HRMS Year End Payroll Patching,  platform migration from AIX to OEL of Oracle Database and EBS. Also supported the printer’s configuration and support (OMPLUS). Worked on quarterly CPU patching, concurrent managers troubleshooting, OATM migration, workflow configuration and troubleshooting, iStore configuration and support, shared APPL_TOP support, 11.5.10.2 baseline patching, MWA support, GIS support.
  • Worked with Oracle Fusion product with installation of Oracle 11g OID, 11g OAM, Weblogic Services, and Single Sign on Implementation for E-Business Suite.
  • Expertise in installing Discoverer (multiple versions) and integrating to ERP Applications.
  • Expert knowledge in Relational Database concepts and have been involved in Entity-Relationship modeling.
  • Knowledge on Golden gate.
  • Worked on External node setup in DMZ for i-modules like iSupplier, iExpenses.
  • Expertise in installing Discoverer (multiple versions) and integrating to ERP Applications.

 

Skills:

  • Oracle ERP: Oracle Apps versions 11.5.9, 11.5.10(.1 & .2), R12.0.4, R12.1.1, R12.13 with Oracle Financials, Manufacturing, HRMS, ASCP modules.
  • Databases: Oracle 11gR2, 11gR1, 10gR2, 10gR1, 9i, SQL Server 2000, 2005
  • Languages: PL/SQL, SQL, C, C++, Java, Perl, UNIX Shell Scripting.
  • Operating systems: Windows 2000/NT/XP/2003, RHEL Linux 4 & 5, Oracle Enterprise Linux 4 & 5, Solaris 8/9, AIX 5.3, 6.1.
  • Database Tools: Oracle Enterprise Manager, Oracle Grid Control, SQL Analyzer, PL/SQL developer, TOAD, Oracle SQL Developer.
  • GUI Tools: Developer 2000 (Forms 4.5, 5.0, 6i, 10g, 11g), Visual Basic 5.0.
  • Others: Knowledge of HTML programming, Internet Technologies.
  • Back up Tools: RMAN, SQL*Loader, Export/Import, Data pump, Net Backup.

 

Leave a Reply