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.