Oracle Apps EBS Technical Consultant

Key Responsibilities

• System Customization & Development: Conduct standard secondary development and personalized customization for Oracle EBS R12.2.10 core modules (GL, AP, AR, BOM, FA, PO, INV, OM, WIP) including form modification, report development, workflow configuration and function expansion, complying with Oracle official specifications and enterprise coding standards and follow JE development standard and version control procedure.

Prepare Program Migration Steps, Technical Specification (MD070) and Unit Test Report (TE110) according to JE development standard.

Perform Program Unit Test and assist in Problem solving during Functional Test (FAT) and User Acceptance Test (UAT)

• Cross-System Integration: Design and develop stable data interfaces between EBS and third-party systems (MES, WMS, CRM, OA, payroll system, etc.) via PL/SQL, API, WebService, REST API and OAF, ensuring accurate and consistent data synchronization.
• Performance Tuning & Optimization: Optimize SQL statements, concurrent programs and interface execution efficiency, resolve system bottlenecks, slow queries and program exceptions guarantee stable ERP operation.
• Technical Support & Troubleshooting: Provide daily on-demand technical support, quickly locate and fix system bugs, data anomalies and functional failures; analyze business requirements and deliver feasible technical solutions.
• System Upgrade & Maintenance: Participate in EBS R12.2.10 patch updates, version iterations and environment migrations, proficiently apply AD ZDDP online patching mechanism to ensure zero business interruption during upgrades and complete regression testing.
• Documentation & Team Support: Compile standardized technical documents (development design, interface specs, deployment records, troubleshooting logs); accumulate project experience, maintain team knowledge base and guide junior developers.
• Project Delivery: Participate in requirement review and solution discussion, control development progress and quality to ensure on-time and high-quality project delivery.

Job Requirements

Mandatory Requirements

• Bachelor’s degree or above in Computer Science, Software Engineering, Database or related technical majors.
• 10 to 13 Years Oracle EBS R12.2 exclusive development experience, with independent full-cycle customization, integration and project delivery experience.
• Proficient in Oracle PL/SQL development, including packages, stored procedures, triggers and functions; skilled in SQL tuning, index optimization and database performance analysis.
• In-depth understanding of EBS R12.2 architecture, AD utilities and ZDDP online patching mechanism, familiar with EBS standard development tools and specifications.
• Master core EBS development technologies: Concurrent Program, Form/Report Builder, OAF, standard API invocation and data migration tools.
• Proficient in system interface development, familiar with WebService, REST, XML and EDI technologies.
• Grasp basic Linux/Unix commands for system deployment, log checking and daily maintenance.

Preferred Requirements

• Have EBS R12.2 project implementation experience in large manufacturing company
• Rich experience in system performance tuning, data migration and patch upgrade projects.
• Proficient in English for reading official Oracle technical documents.
• Fluent English written and spoken is required for the position, spoken Mandarin an advantage

Core Competencies

• Solid EBS technical foundation and independent solution design ability.
• Excellent cross-department communication and teamwork skills for accurate requirement docking.
• Strong responsibility and execution capability, able to deliver tasks under pressure.
• Good learning awareness to keep track of new Oracle EBS technologies and optimization methods.