About the Role: The Senior Oracle Applications Database Administrator is responsible for supporting the upgrade and ongoing maintenance of Oracle eBusiness Suite environment, providing expert-level database administration, performance tuning, automation, and guidance on best practices while collaborating with IT teams and ensuring system stability across all environments.
Scope of Work/Responsibilities
Oracle eBusiness Suite (EBS) Upgrade and Support
- Provide support in the ongoing technical upgrade of Oracle eBusiness Suite from version 12.1.3 to version 12.2.13.
- Troubleshoot issues during and after the upgrade with in-depth knowledge of the EBS 12.2 architecture.
- Guide the Database Administration Unit on best practices for maintaining an EBS 12.2 environment.
- Share knowledge of the EBS 12.2 ecosystem with other database administrators to enhance team capability.
Collaboration and Communication
- Assist the Database Administration Unit with Oracle database administration tasks.
- Report progress weekly to the Supervisor during team meetings.
- Work autonomously while coordinating and communicating with other ITID staff including team leads, QA, and developers.
Oracle Database Administration
- Perform cloning operations.
- Handle backup and recovery tasks:
- Export/import for schema refresh.
- Perform database recovery.
- Full database restore and recovery.
- Point-in-Time Recovery (PITR).
- Implement backup policies and strategies.
- Configure and administer Oracle Data Guard.
- Conduct performance tuning activities.
- Manage storage:
- Manage tablespaces.
- Monitor and request disk expansion.
- Manage users and permissions:
- Create users and roles.
- Grant and revoke privileges.
Database Monitoring and Issue Resolution
- Monitor the overall performance of Oracle databases across all environments (development, testing, UAT, SIT, production).
- Perform daily checks on database availability.
- Deploy customizations and handle ad hoc requests.
- Assist the development team with potential application code issues.
Patching and Maintenance
- Apply patches to Oracle databases as needed, including bug fixes and security updates.
Software and Tool Management
- Manage and maintain tools used by the Database Administration Unit, including:
- Oracle Enterprise Manager (OEM).
- Oracle Application Express (APEX).
User and Stakeholder Support
- Attend to end-user requests and issues by coordinating with relevant units and other departments.
Vendor and External Support Coordination
- Liaise with Oracle Support to follow up on internal Service Requests related to Oracle database or Oracle E-Business technology stack.
Automation of DBA Tasks
- Automate routine DBA tasks using Ansible or shell scripting, such as:
- Monitoring and gathering database and server information.
- Performing database backups.
- Regular database cloning and schema refresh.
Requirement and Qualification (Education & Work Experience)
Education and Work Experience
- Bachelor of Science in Computer Engineering or equivalent.
- Minimum of 8 years of experience in Oracle Database and Oracle E-Business Suite management.
- Hands-on experience upgrading Oracle E-Business Suite from version 12.1.x to 12.2.x.
- Minimum of 3 years of experience maintaining and managing Oracle EBS 12.2 in Business-as-Usual (BAU) operations.
Technical Knowledge
- Strong understanding of Oracle E-Business Suite 12.2 architecture and technical components.
- Proficient in Oracle EBS 12.2 cloning and patching (DB and Application) using ADOP.
- Skilled in troubleshooting common Oracle Application issues.
- Experienced in filing Service Requests using My Oracle Support (MOS).
- Proficient in Oracle RMAN backup and recovery procedures.
- Experienced in configuring and managing Oracle Data Guard.
- Strong performance tuning capabilities for Oracle Databases.
- Solid working knowledge of SQL*Plus and PL/SQL programming.
- Familiar with SQL Developer for database development and management.
- Proficient in managing Oracle databases using Oracle Enterprise Manager (OEM).
- Functional knowledge of Oracle EBS HR and Financial modules.
Optional Technical Knowledge
- Experience managing Oracle Applications and Databases in Azure Virtual Machines.
- Experience working with Oracle MySQL and PostgreSQL databases.
- Experience with Unix/Linux operating systems administration.
- Familiarity with network infrastructure and troubleshooting.
Soft Skills
- Strong client-oriented approach with the ability to mediate, resolve conflicts, and address client inquiries.
- High level of motivation and a proactive, team-player attitude.
- Strong work ethic with the ability to work effectively in multicultural environments.
- Excellent time management, organizational, and interpersonal skills.
- Ability to maintain confidentiality of sensitive information and records.
- Strong communication, writing, and presentation skills for meetings and documentation.
Tools/Software
- Oracle Enterprise Manager (OEM).
- SQL Developer.
- Oracle Application Express (APEX).
- Familiarity with Ansible or shell scripting for automating DBA tasks.
Certification (if applicable)
- Certifications not listed, but you may consider adding relevant ones such as:
- Oracle Certified Professional (OCP) Oracle Database.
- Oracle E-Business Suite R12 Applications DBA Certified Professional.
- Microsoft Azure Administrator Associate (if applicable to cloud experience).
Work Arrangement
Remote
Work Schedule is from 8:00AM 5:00PM Manila Time.
