Oracle Application Database Administrator

Lancesoft Philippines; India; On-site; INR 1,500,000 - 2,000,000; Full time

Job summary

A leading technology services company in India seeks a Senior Oracle Applications Database Administrator to ensure support for Oracle eBusiness Suite upgrades and maintenance. This position requires a minimum of 8 years in database management and experience with Oracle E-Business Suite versions 12.1.x to 12.2.x. Responsibilities include collaborating with IT teams, performing database recovery tasks, and ensuring system stability across environments. The ideal candidate will have strong communication skills and a proactive approach.

Qualifications

• Minimum of 8 years of experience in Oracle Database and Oracle E-Business Suite.
• Hands-on experience upgrading Oracle E-Business Suite from version 12.1.x to 12.2.x.
• Strong understanding of Oracle E-Business Suite 12.2 architecture.

Responsibilities

• Support the upgrade and maintenance of Oracle eBusiness Suite environment.
• Triage issues during and after upgrades with in-depth knowledge of EBS architecture.
• Monitor performance of Oracle databases across all environments.

Skills

Oracle Database Management

Performance Tuning

Automation with Ansible

Client Communication

Education

Bachelor of Science in Computer Engineering or equivalent

Tools

Oracle Enterprise Manager (OEM)

SQL Developer

Oracle Application Express (APEX)

Job description

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:
• 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.
• Regular database cloning and schema refresh.

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.
• 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

• 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

Work Schedule is from 8:00AM – 5:00PM Manila Time.