Job Detail

Job Title: Database Administrator

Job Type: Full Time

Location: Iselin, NJ

Job Description:

·         Install, configure, administer and monitor production, staging as well as test databases running on 12c, 11gR2 and Oracle EBS R12 on OEL, RHEL environments.

·         Responsible for backup/restore/tar and cloning of oracle applications to development/test instances and database refresh frequently.

·         Patching Oracle EBS R12 instances using ADpatch, ADOP utility and phases.

·         Apply Fusion Middleware Technology stack patches (OHS, WebLogic, FMW) for EBS R12.2 environments.

·         Responsible to do Oracle Database upgrades from 11gR2 to 12c and Oracle Apps R12.1.3 to 12.2.4.

·         Perform database and application cloning (RMAN, rapid clone and automated clone).

·         Develop scripts for database monitoring and maintenance.

·         Full Database, Point-in-Time, and Object Level recovery using RMAN.

·         Configure Parallel Concurrent Processing (PCP).

·         Configure Application Servers Load-Balancing using Big IP Hardware Load Balancer.

·         Code Migration between different environments using FNDLOAD.

·         Configure Oracle Data guard (ADG) for Oracle Disaster recovery on standalone databases using 11g Active Duplication.

·         Document critical issues with root cause analysis, provide timely resolution of service tickets.

·         Resolve database performance and database capacity issues using tools such as statspack, awrrpt, addm, and ad-hoc shell/SQL scripts.

·         Proactively tune the performance of EBS application.

The minimum requirement for performance of the job duties is a bachelor’s degree (or equivalent) in Computer Science or a directly related IT field with 3 years of relevant work experience or master’s degree with 1 year of relevant work experience.