Principal Oracle Systems Architect

DENSO TEN AMERICA Limited
McAllen, TX, United States
about 2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Working hours
Regular working hours
Job source

Tech stack

Application Programming Interfaces (APIs) ASC X12 Standards Unit Testing Business Software Code Review Concurrent Computing Data Conversion Database Schema Software Debugging UN Electronic Data Interchange for Administration Commerce and Transport Human Resources Information System (HRIS) Information Sciences
+18 more
Oracle (Applications) Oracle Forms Performance Tuning Systems Development Life Cycle Software Engineering Software Requirements Analysis PL-SQL SQL Databases Systems Integration Software Technical Review Web Services Sql Loader Transaction Processing (Computing) Sql Optimization Bi Publisher Database Optimization Oracle Reports Oracle Ebusiness

Job description

Position Summary: The E-Business Suite Developer is a senior technical role responsible for the architecture, design, development, enhancement, and support of complex Oracle E-Business Suite solutions. This position requires advanced hands-on expertise in Oracle EBS technical development, including PL/SQL, Oracle Forms and Reports, OA Framework, Oracle Workflow, BI Publisher, concurrent processing, data conversions, interfaces, and EDI integrations. The role also requires deep knowledge of Oracle EBS architecture, underlying data models, standard APIs, and cross-functional integration patterns to deliver scalable, maintainable, and secure enterprise solutions, Lead the technical design, development, enhancement, and support of complex Oracle EBS RICEW components, including advanced packages, procedures, functions, Forms, Reports, BI Publisher reports, workflows, interfaces, and extensions aligned to business and system requirements. Provide advanced Oracle EBS technical support in a live production environment, performing root cause analysis, debugging complex application and data issues, and delivering durable resolutions across custom and standard components. Design, build, and support complex reports, conversions, interfaces, EDI solutions, and extensions using Oracle EBS standards, open interfaces, APIs, web services, and integration patterns with internal and external enterprise systems. Demonstrate deep technical knowledge of Oracle EBS architecture, Oracle Application Object Library, concurrent processing, multi-org concepts, database objects, and core development toolsets including SQL, Oracle Forms and Reports, Oracle Workflow Builder. Familiarity or preferably working knowledge of Oracle e-commerce gateway architecture, EDI standards as ANSI X12 and EDIFACT, along with other basic EDI concepts.

Identify, analyze, and resolve performance bottlenecks through advanced SQL and PL/SQL tuning, execution plan analysis, indexing strategies, batch performance optimization, and efficient design for high-volume transaction processing. Partner with business process owners, functional analysts, DBAs, and other technical teams to translate business requirements into robust technical designs, detailed specifications, test scenarios, and production- ready Oracle EBS solutions. Lead or serve as the primary technical contributor on Oracle development initiatives, driving solution design decisions, development standards, deployment readiness, and support for process improvements across EBS- enabled business functions. Maintain advanced knowledge of Oracle EBS module data models, transaction flows, APIs, open interfaces, and underlying table structures across modules such as Order Management, Inventory, Accounts Receivable, Accounts Payable, Depot Repair/Service, General Ledger, and HRMS. Operate independently with minimal supervision, exercise strong technical judgment, and assume accountability for the quality, stability, maintainability, and timely delivery of assigned Oracle EBS solutions. Lead or participate in technical design reviews, code reviews, and solution walkthroughs, and provide guidance on development standards, supportability, and quality improvements for Oracle EBS technical components. Apply strong software engineering discipline throughout the full system development life cycle, including technical documentation, unit testing, migration support, defect resolution, release readiness, and production validation to deliver efficient and maintainable Oracle EBS solutions. Abides by the prescribed standards and procedures designed to guarantee compliance with key control objectives like JSOX. Question existing processes and procedures (both administrative and technical), offer suggestions and opinions for continuous improvement. Serve as a senior technical resource within the Oracle EBS team, collaborating effectively across functional and technical teams and providing knowledge sharing and technical guidance as needed to support project and operational objectives.

Requirements

Do you have experience in Systems integration?, Do you have a Bachelor’s degree?, Experience: Bachelor of Science (BS) in Computer & Information Science, Software Engineering, or a related field minimum of 5 years of progressively responsible Oracle E-Business Suite technical development experience, or an equivalent combination of education and experience. Required experience includes advanced hands-on development with Oracle Forms, Oracle Reports, OA Framework, Oracle Workflow, BI Publisher, SQL Loader, SQL, and PL/SQL, along with strong knowledge of Oracle EBS R12/R12.2 architecture, standard APIs, open interfaces, data conversions, and technical support in a production environment.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:39 min

Addressing code review surrender and process exploitation

Laura Tacho Laura Tacho · WWC Europe 2026

1:06 min

Developer experience and project variety at scale

Alexandra Petri · WWC 2023

56 sec

The hidden costs of delayed peer code reviews

Tim Gilboy Tim Gilboy

1:37 min

Adopting systems engineering across a large enterprise

Daniel Siegl +1 · LIVE

4:21 min

Upcoming features and major Oracle enhancement projects

Michael Inden · LIVE

2:12 min

The purpose and benefits of manual code reviews

Julien Delange · LIVE

Videos

See all

Related articles

See all