Job Description :
Sr. Oracle Applications DBA
Madison, NJ
C2H

Job Requirements

Must have hands-on experience with Oracle Applications R12 and database 11g, 12C with installing, patching, cloning, upgrades, monitoring, maintaining and admin utilities, etc.
Must be knowledgeable about underlying Oracle Applications database architecture schemas/products, database objects, file system structure, tables, views, packages, procedures, functions, triggers, sequences, indexes, and constraints.
Must be knowledgeable about UNIX and Linux operating systems, and have experience with cross-platform database migrations, such as AIX to Linux, Solaris to Linux
Must have Oracle ERP application fundamental knowledge, have hands-on experience with Oracle modules, such as GL, AP, AR, PA, FA, HR, and etc.
Expert in Oracle application and database performance tuning
Must have Oracle EBS SSO integration experience
Knowledge of cloud technologies, Azure, AWS, GCP, Oracle
Minimum a Bachelor’s degree in the field of computer science and at least 8 years work experience as an Oracle DBA.
Have hands-on experience in other tools, such as XML, Workflow, Java, Python
Hyperion products work experience is a plus.

Responsibilities
Responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
Installing, upgrading Oracle Applications R12 in a multi-tier environment
Working with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
Supporting both Production and Development Oracle Applications environment
Patching and Maintenance of R12 Oracle Application Environments
Performing database transaction and security audits
Responding to and resolving database/application access and performance issues
Conducting research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts
Planning and coordinating data migrations between systems