Oracle Database Administration

Siegen HR Solutions; Manila; On-site; PHP 558,000 - 892,800; Full time

Job summary

A staffing solutions firm in the Philippines seeks an experienced Oracle Database Administrator to manage Oracle e-Business Suite Release 12. Key responsibilities include database health monitoring, optimization, performing upgrades, and ensuring security administration. Candidates should possess a Bachelor's degree in Computer Science or Information Systems and have relevant experience with Oracle applications and SQL scripting. This role will play a crucial part in ensuring the efficient operation of databases in a dynamic environment.

Qualifications

• Experience as Oracle Application DBA.
• Skilled in using Oracle e-Business Suite Release 12.
• Bachelor's Degree in relevant field.

Responsibilities

• Manages the Oracle e-Business Suite release 12.
• Monitors and maintains database health, tuning, and SQL reviews.
• Performs database upgrades and cloning, including RAC operations.

Skills

Oracle Database Administration

SQL/PL SQL

Unix Shell scripting

Education

Bachelor’s Degree in Computer Science or Information Systems

Tools

Oracle e-Business Suite Release 12

Job description

About the job Oracle Database Administration

KEY RESPONSIBLITIES

• Manages the Oracle e-business suite release 12.
• Execute the following activities:
  • Database refresh to non-production DB
  • Daily database health check monitoring, tuning and minor SQL reviews
  • Capacity planning and execution
  • Quarterly access review
  • Database optimization
  • Database security admin
  • Deployments to production
  • Performance test planning and execution
  • Apply patches as mandated by project/vendor
  • Monitor and fix table locking/blocking; monitor alerts and fix issues
  • Creates, updates delete SSI packages and stored procedures
  • Cloning Oracle applications using rapid clone
  • Patching Oracle applications using adpatch
  • Performing database upgrades, including upgrading Oracle applications from 11i to R12
  • Setting up multi-tier Oracle Application environment
  • Installing/upgrading/administering Oracle RAC databases
  • Cloning databases from RAC to NON RAC
  • Set up and administer ASM
  • Back-up and recovery of Oracle databases using RMAN utility
  • Unix Shell scripting/SQL/PL SQL

TO QUALIFY

• Experience as Oracle Application DBA
• Skilled in using Oracle e-Business Suite Release 12
• Bachelor’s Degree in Computer Science, Information Systems or equivalent