Oracle APPS DBA

We are seeking an Oracle Apps DBA to support Production/ Stage/ Development Oracle EBS in a 24*7 shift support model. The position will be responsible for installation, configuration, upgrading, administrating, monitoring, cloning, Patching, Backup and restore of Oracle EBS. Responsibilities include reviewing application/databases, identifying performance bottlenecks and fixing along with daily production health checks.

Requirements

• Performing Daily health checks for production environment, identifying the performance bottlenecks and working on to fix them.
• Perform regular DBA support using tools like Serena or ServiceNow.
• Providing technical inputs towards maintaining large complex production environment.
• Plan for instance growth requirements.
• Good knowledge in the latest versions of Oracle database/E Business suite architecture and components (19c, 12.2 EBS etc.).
• Knowledge of Oracle security basics, and experience in working with ISO and Auditing.
• Expert in RAC, ASM, WebLogic Administration.
• Experience in all routine DBA tasks including health checks, troubleshooting issues and installations.
• Good knowledge of PLSQL and SQL
• Knowledge of traces, tkprof and find poorly performing SQL.SQL, profiling, rewrite poorly performing SQL.
• Knowledge of Load balancing, PCP, Configurators, JVM’s, archiving and purging tools like HP Archiving, SOA gateway, ekanban knowledge is add on.
• Knowledge of oracle database wait events, Database and Application parameters
• Ability to fine tune the concurrent processing in large EBS environment.
• Extensive familiarity with OEM Tool.
• Install, upgrade, patch and administer the EBS application and database.
• Experience with Oracle data guard.
• Experience in RMAN backup & restore activities

Benefits

• Competitive compensation and benefits programs
• Comprehensive medical and insurance coverage
• Work Authorization Sponsorship for foreign nationals
• Remote Work Policy for eligible roles
• Safety is paramount to us, and we are relentless in our pursuit to provide a Safe Working Environment across our global network and facilities
• Employee development programs
• Equitable opportunities, celebrate diversity, and embrace challenges