Oracle Apps Technical Consultant
Key details
- Location
- India
- Work style
- Remote
- Job type
- Full-time
- Function
- Operations & Strategy
- Focus area
- other
- Posted
- 5h ago
Skills
application developmentdata migrationdata structureslinuxoracleoracle databaseoracle e-business suiteperformance tuningpl/sqlshell scriptingsoftware architecturesqltroubleshootingunixxml
About the role
This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for an Oracle Apps Technical Consultant based in India.
As an Oracle Apps Technical Consultant, you will play a key role in developing, customizing, and maintaining enterprise applications built on Oracle E-Business Suite (EBS) R12. You will work closely with functional consultants and business stakeholders to translate business requirements into reliable, scalable, and efficient technical solutions. Your responsibilities will span technical development, database programming, system integrations, data migration, and production support. Using your expertise in SQL, PL/SQL, Oracle Forms, BI Publisher, and Oracle application architecture, you will help optimize business-critical systems and ensure seamless application performance. You will also contribute to troubleshooting complex technical issues, improving system reliability, and maintaining compliance with Oracle development standards. This is an excellent opportunity to join a collaborative, technology-driven environment where technical expertise, continuous improvement, and customer-focused solutions are highly valued.
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.
- 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.
- 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.
Requirements:
Benefits:
How Jobgether works:
We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.
We appreciate your interest and wish you the best!
Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.
#LI-CL1
How well do you match this job?
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.