Oracle Apps Technical Consultant

Accountabilities:: Develop and customize Oracle EBS applications: Design, build, customize, and maintain Oracle E-Business Suite R12 components to meet evolving business and operational requirements. Manage Oracle RICE components: Develop, enhance, and maintain Reports, Interfaces, Conversions, and Extensions (RICE), ensuring reliable integration and functionality across enterprise applications. Develop database solutions: Create, maintain, and optimize PL/SQL procedures, packages, functions, and triggers to support business processes and application performance. Customize Oracle application components: Develop and modify Oracle Forms, Oracle Application Framework (OAF) pages, and Oracle Application Development Framework (ADF) components where applicable. Manage Oracle workflows: Use Oracle Workflow Builder to customize, maintain, troubleshoot, and optimize workflow processes. Build system integrations: Design and develop interfaces between Oracle EBS and external or third-party applications, ensuring accurate and efficient data exchange. Handle data migration and conversion: Execute data migration, transformation, and conversion activities using SQL, PL/SQL, and standard Oracle tools. Ensure data accuracy: Investigate and resolve data inconsistencies, reconciliation discrepancies, and integration-related issues. Provide production support: Analyze and resolve application issues, implement bug fixes, and maintain the stability and availability of Oracle EBS environments. Troubleshoot technical issues: Investigate concurrent program failures, database errors, application performance problems, and other complex system incidents. Optimize database performance: Monitor and tune SQL queries, PL/SQL programs, and database objects to improve execution efficiency and overall application performance. Collaborate with stakeholders: Work closely with functional consultants, business users, and technical teams to understand requirements, deliver technical solutions, and ensure successful implementation. Requirements: Strong hands-on experience with Oracle E-Business Suite (EBS) R12, including its technical architecture, components, and development standards. Advanced proficiency in SQL and PL/SQL, with practical experience developing procedures, packages, functions, triggers, and database objects. Demonstrated experience developing and maintaining Oracle RICE components (Reports, Interfaces, Conversions, and Extensions). Hands-on experience with Oracle Reports and BI Publisher, including XML data structures and RTF templates. Practical knowledge of Oracle interfaces, APIs, and concurrent programs. Experience developing and customizing Oracle Forms, OAF pages, and ADF components, where applicable. Familiarity with Oracle Workflow Builder and workflow customization and troubleshooting. Strong understanding of Oracle EBS architecture, application components, and database interactions. Experience with Unix/Linux environments and shell scripting for application administration and automation. Knowledge of Oracle database objects, SQL optimization, and performance tuning techniques. Strong analytical and troubleshooting abilities, with the capacity to investigate complex technical issues and deliver effective solutions. Excellent communication and collaboration skills, with the ability to work effectively with functional teams, technical stakeholders, and business users. Strong attention to detail, problem-solving capabilities, and a proactive approach to application maintenance and continuous improvement. Benefits: Competitive compensation and employee benefits package. Comprehensive health insurance and additional benefits, including dental coverage. Generous paid time off, subject to applicable eligibility requirements. Volunteer leave opportunities and initiatives supporting community involvement. Employee Assistance Program (EAP) to support personal and professional wellbeing. Access to employee resource groups and activities designed to encourage inclusion, collaboration, and stronger workplace connections. Professional development opportunities through structured learning and mentorship initiatives. Access to leadership development programs, including the SOAR manager development program. Opportunities to contribute to meaningful projects focused on workplace trust, risk management, and technology innovation. Collaborative working environment built around authenticity, curiosity, integrity, teamwork, and customer focus.