Oracle Application Database Administrator

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.