Sr. Oracle Developer

Indigo Beam; Houston (TX); Hybrid; USD 83,000 - 124,000; Full time

Job summary

Indigo Beam, LLC seeks a Sr. Oracle Developer in Houston, TX for a hybrid role (3 days on-site per week). The contract is 3+ months (1099) with a potential to convert to full-time. Key work includes Oracle EBS customization, OAF components, PL/SQL, APEX, Reports, and XML Publisher.

Responsibilities include integrating with third-party apps via APIs, data migration tasks, performance tuning, and end-user training. Deep understanding of AIM methodology and Oracle EBS R12 features is required.

Qualifications

• Deep knowledge of OAF components including View Objects, Application Modules, Entity Objects and Controller Updates.
• Proficient in PL/SQL, SQL, Java, Oracle Forms, Reports, Workflow Builder, JDeveloper.
• Experience with Oracle Database and related tools for performance tuning.
• Knowledge of different versions of Oracle EBS (R12 and beyond) and their specific features.

Responsibilities

• Customization and Development: Develop and customize Oracle EBS modules using OAF components, PL/SQL, APEX, Reports and XML Publisher; create custom workflows and approvals.

Skills

OAF components

PL/SQL

SQL

Java

Oracle Forms

Reports

Workflow Builder

JDeveloper

Oracle Database

Performance tuning

AIM methodology

Tools

Oracle EBS R12

APEX

Job description

Position: Sr. Oracle Developer

Location: Houston, TX (hybrid, 3 days on-site per week)

Contract: 3+ months (1099), with the possibility of converting to full-time

Only candidates who do not require sponsorship

Key Responsibilities

Customization and Development:

• Develop and customize Oracle EBS modules using OAF components, PL/SQL, APEX application platform, Reports, and XML Publisher.
• Create custom workflows and approval processes using Oracle Workflow Builder.
• Familiar with AIM methodology

Integration:

• Implement integrations with third-party applications using APIs, FTP, and Web Services
• Develop Custom Web ADI solutions to retrieve and load data using excel.

Data Management:

• Manage data migration and conversion tasks, often involving data extraction and transformation.
• Write SQL scripts to query and manipulate data within Oracle databases.

Support and Maintenance:

• Provide ongoing support for existing EBS applications and resolve issues as they arise.
• Conduct system testing and validation for new features and enhancements.

Performance Tuning:

• Identify and resolve performance issues in EBS applications.
• Optimize PL/SQL code and SQL queries for better performance.

Documentation and Training:

• Train end-users on new features and custom applications.

Oracle Modules

• Enterprise Asset Management, Order Management, Purchasing, Install Base, Inventory, in Oracle E-Business Suite R12.2

Requirements

• Deep knowledge of OAF components including View Objects, Application Modules, Entity Objects and Controller Updates
• Proficient in PL/SQL, SQL, Java, Oracle Forms, Reports, Workflow Builder, JDeveloper
• Experience with Oracle Database and related tools for performance tuning.
• Knowledge of different versions of Oracle EBS (R12 and beyond) and their specific features.

Soft Skills

• Strong analytical skills to diagnose and solve issues.
• Ability to collaborate with functional teams and stakeholders to gather requirements and communicate technical concepts.
• Guide junior developers and provide knowledge transfer sessions on best practices in Oracle development tools.
• Excellent written and oral communication, Interpersonal and Analytical skills