Principle Oracle Systems Architect

Trillium Staffing; Novi (MI); On-site; USD 110,000 - 160,000; Full time

Job summary

Trillium Professional seeks a Principal Oracle Systems Architect in Novi, MI for direct-hire. The senior role leads architecture, design, development, and ongoing support of Oracle EBS solutions, requiring hands-on Oracle EBS technical expertise, including PL/SQL, Oracle Forms & Reports, OA Framework, and BI Publisher.

This position requires at least three days of onsite work per week and offers a salary range of $110,000 to $160,000 per year.

Qualifications

• Bachelor's degree in Computer Science, Software Engineering, or related field (or equivalent experience)
• Minimum 5+ years of Oracle E-Business Suite technical development experience

Responsibilities

• Lead the design, development, and support of Oracle EBS RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows)
• Provide advanced technical support in a production environment and resolve complex system issues
• Design and implement integrations, EDI solutions, and interfaces using Oracle APIs, open interfaces, and web services
• Develop and support reports, data conversions, and batch processes aligned with business requirements
• Optimize system performance through SQL/PLSQL tuning and indexing strategies
• Collaborate with stakeholders, DBAs, and IT teams to translate requirements into technical solutions
• Serve as a senior technical contributor, guiding design standards and deployment practices
• Maintain knowledge of Oracle EBS modules (Order Management, Inventory, AR/AP, GL, HRMS, Service/Depot Repair)
• Participate in design reviews, code reviews, and improvement initiatives
• Ensure compliance with internal controls including JSOX
• Document solutions, support testing, and ensure production readiness

Skills

Oracle EBS (technical)

PL/SQL

Oracle Forms & Reports

OA Framework (OAF)

Oracle Workflow

BI Publisher

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Loader

APIs & Open Interfaces

Job description

Trillium Professional is now seeking a Principal Oracle Systems Architect for direct-hire!

Principal Oracle Systems Architectis a senior technical role responsible for the architecture, design, development, enhancement, and ongoing support of complex Oracle E-Business Suite (EBS) solutions. Annual salary is $110-160k/year!

This role requires deep, hands-on expertise in Oracle EBS technical development, including PL/SQL, Oracle Forms & Reports, OA Framework, Oracle Workflow, BI Publisher, and integrations. The position plays a key role in delivering scalable, secure, and maintainable enterprise solutions and supporting critical business operations across multiple functional areas.

This position requires at least three days of onsite work each week.

Key Responsibilities:

• -Lead the design, development, and support of complex Oracle EBS RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows)
• -Provide advanced technical support in a production environment, including root cause analysis and resolution of complex system and data issues
• -Design and implement integrations, EDI solutions, and interfaces using Oracle APIs, open interfaces, and web services
• -Develop and support reports, data conversions, and batch processes aligned with business requirements
• -Optimize system performance through SQL/PLSQL tuning, indexing strategies, and execution plan analysis
• -Collaborate with business stakeholders, functional teams, DBAs, and IT teams to translate requirements into technical solutions
• -Serve as a senior technical contributor, guiding design standards, code quality, and deployment practices
• -Maintain deep knowledge of Oracle EBS modules such as Order Management, Inventory, AR/AP, General Ledger, HRMS, and Service/Depot Repair
• -Participate in technical design reviews, code reviews, and continuous improvement initiatives
• -Ensure compliance with internal control standards, including JSOX requirements
• -Document solutions, support testing, and ensure production readiness and stability

Qualifications & Experience

• -Bachelor's degree in Computer Science, Software Engineering, or a related field (or equivalent experience)
• -Minimum 5+ years of Oracle E-Business Suite technical development experience

Technical Skills:

• -SQL & PL/SQL
• -Oracle Forms & Reports
• -OA Framework (OAF)
• -Oracle Workflow
• -BI Publisher
• -SQL Loader

Strong knowledge of:

• -Oracle EBS R12/R12.2 architecture
• -Standard APIs and open interfaces
• -Data conversions and system integrations
• -Experience supporting Oracle EBS in a live production environment

Preferred:

• -Knowledge of Oracle e-Commerce Gateway
• -Experience with EDI standards (ANSI X12, EDIFACT)

Trillium has been recruiting and placing professionals for over 30 years. From Fortune 100 companies to small businesses, our philosophy remains the same: to achieve excellence by providing quality employees and an uncompromising level of service. We believe in honesty, integrity, and a simple philosophy of providing value to our customers and our employees. We strive to be unsurpassed in the recruitment and placement of quality and skilled professionals. Trillium is an Equal Opportunity Employer.