Administrator (Oracle APS DBA) at ERNI Philippines

Mandaluyong, Metro Manila, Philippines -

Full Time

Start Date

Immediate

Expiry Date

11 Jan, 26

Salary

0.0

Posted On

13 Oct, 25

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle Database, Oracle E-Business Suite, Database Administration, Performance Tuning, SQL, PL/SQL, Oracle RMAN, Oracle Data Guard, Troubleshooting, Backup and Recovery, Cloning, Patching, Oracle Enterprise Manager, Oracle Application Express, Ansible, Shell Scripting

Industry

IT Services and IT Consulting

Description

Founded in 1994 and headquartered in Switzerland, ERNI is a leading Software Development company with over 800 employees worldwide. Specializing in IT and software engineering, we drive innovation in process and technology. Our first service center in Asia Pacific, located in Metro Manila (Mandaluyong), supports clients across Europe, APAC, the Philippines, and the USA. As we continue to grow, we're looking for passionate and motivated individuals to join our team. Why ERNI is the Perfect Place for You: 🏡 • International Exposure: Work with global clients on cutting-edge projects. • Inclusive Culture: Thrive in a collaborative and diverse work environment. • Career Development: Enjoy continuous learning and professional growth opportunities. 🤩Perks and Benefits: • Career Stability: Enjoy a stable career path with ample project opportunities. • Immediate Coverage: Private HMO and insurance benefits from day one. • Jubilee Celebration: A 5-year milestone includes a complimentary trip to any European ERNI sites. • Comprehensive Benefits: Government-mandated benefits including 13th-month pay. • Skill Enhancement: Access free training and certifications. • Baby Basket: To welcome your newborn to the ERNI family. • Fruit Basket: Boost of vitamins during hospitalization. • Office Perks: Enjoy free snacks and coffee. 🔐Growth and Opportunities: • Free Training: Advance your skills through technical and non-technical training. • Challenging Projects: Engage in complex software projects across MedTech, Industry, Finance, and Transportation. • Supportive Environment: Benefit from a team dedicated to guiding and supporting your success. • Recognition and Advancement: Receive acknowledgment for your efforts and opportunities for promotion. • Open Communication: Experience transparency and value your input in our culture. ⏱Flexibility: • Hybrid Work Setup: Balance remote and in-person work for better work-life integration. 🎉Events: • Connect and Celebrate: Participate in a variety of events including leisure, summer, family, social, and year-end gatherings. 👋What are our wishes: 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. 💼How can you contribute to the team? Scope of Work/Responsibilities 1. Oracle eBusiness Suite (EBS) Upgrade and Support • Provide support in the ongoing technical upgrade of clients 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. 2. 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. 3. Oracle Database Administration • Perform cloning operations. • Handle backup and recovery tasks: a. Export/import for schema refresh. b. Perform database recovery. c. Full database restore and recovery. d. Point-in-Time Recovery (PITR). e. Implement backup policies and strategies. f. Configure and administer Oracle Data Guard. g. Conduct performance tuning activities. • Manage storage: a. Manage tablespaces. b. Monitor and request disk expansion. • Manage users and permissions: a. Create users and roles. b. Grant and revoke privileges. 4. 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. 5. Patching and Maintenance • Apply patches to Oracle databases as needed, including bug fixes and security updates. 6. Software and Tool Management • Manage and maintain tools used by the Database Administration Unit, including: a. Oracle Enterprise Manager (OEM). b. Oracle Application Express (APEX). 7. User and Stakeholder Support • Attend to end-user requests and issues by coordinating with relevant ITD units and other clients' departments. 8. 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. 9. Automation of DBA Tasks • Automate routine DBA tasks using Ansible or shell scripting, such as: a. Monitoring and gathering database and server information. b. Performing database backups. c. Regular database cloning and schema refresh.

Responsibilities

The role involves providing support for the technical upgrade of Oracle eBusiness Suite and performing various database administration tasks. Additionally, the candidate will troubleshoot issues and guide best practices for maintaining the EBS environment.