Technical Product Owner | Oracle EBS | SQL | Order Management | Hybrid | Long Term

TMS LLC•Irving, TX

5d•Hybrid

About The Position

The Technical Product Owner (TPO) is responsible for supporting and enhancing systems built on Oracle E-Business Suite (EBS), with a primary focus on deep technical analysis, troubleshooting, feature testing, and translation of system behavior into actionable product requirements. This role requires an individual who is already proficient in Oracle EBS internals — including data structures, transaction flows, application logic, and customization frameworks — and can independently diagnose issues by working directly within the database and application layers. The TPO will leverage strong SQL, PL/SQL, and Oracle function knowledge to perform root cause analysis and convert findings into well-defined product deliverables. The ideal candidate will also have a background in developing and executing test cases, particularly involving Oracle APIs. This position serves as a critical bridge between business operations and engineering, ensuring that issues are understood at the data and logic level and are translated into clear, executable work.

Requirements

5–8 years of experience in one or more of the following: Oracle EBS Technical Analyst, Business Systems Analyst (EBS-focused), Technical Product Owner supporting Oracle EBS
Strong, hands-on SQL expertise in Oracle
Must be comfortable writing complex queries for troubleshooting production issues
Proven experience reading and interpreting PL/SQL stored procedures, packages, triggers, and Oracle functions
Demonstrated experience working with core Oracle EBS data structures, transaction flows, and backend processing logic
Practical experience with customization of Oracle functions and EBS application behavior
Proven ability to perform independent root cause analysis using data and system logic
Proven ability to translate technical findings into actionable product requirements

Nice To Haves

Experience working in heavily customized Oracle EBS environments
Familiarity with Oracle APEX or mobile vs. desktop form behavior within EBS ecosystems
Familiarity with differences in how users interact with EBS across UI frameworks
Experience in supply chain, order management, inventory, or fulfillment modules
Familiarity with integration patterns between EBS and external systems (APIs, event-driven platforms)

Responsibilities

Own and manage backlog items related to Oracle EBS-driven systems and integrations
Conduct independent, deep-dive troubleshooting by writing and executing complex SQL queries against Oracle EBS (including extensive custom table structures), tracing transaction lifecycles across multiple modules and integrations, and performing root cause analysis directly from EBS data, logic, and execution paths, without reliance on engineering teams for initial diagnosis.
Read and interpret PL/SQL stored procedures, packages, triggers, and Oracle functions, Oracle EBS application logic and customization layers, and JSON requests and responses for integrations and business events.
Translate findings into well-defined user stories, defect tickets, and enhancement requests, with clear acceptance criteria based on actual system behavior.
Engage in QA testing by developing clearly documented test cases, generating test data, executing test cases, documenting findings, troubleshooting defects, and providing feedback to engineers and/or integration partners.
Partner with engineering teams to validate solutions and ensure alignment with system constraints.
Reconcile differences between business expectations and actual EBS system behavior.
Trace and validate end-to-end transaction flows across EBS and integrated systems.
Support testing and validation by confirming that fixes resolve underlying data and logic issues.
Use SQL as a primary tool to diagnose production issues, validate data integrity, and reconcile discrepancies across systems.
Analyze and interpret PL/SQL code, Oracle functions, and EBS backend processing logic.
Demonstrate deep familiarity with Oracle EBS base tables, relationships, and transaction models, and custom extensions and client-specific configurations.
Understand how Oracle functions and application logic are customized within EBS environments.
Play a lead role in functional feature, enhancement, integration, and bugfix QA, including working with warehouse operators to validate functionality post-deployment.
Navigate multiple EBS environments (Model, Pre-Prod, Prod) to identify inconsistencies and root causes.
Use database-level and application-level analysis as the primary mechanisms for understanding system behavior.
Possess strong working knowledge of Oracle EBS functionality “under the hood”, including order management, inventory and fulfillment processing, and transaction lifecycle and state transitions.
Understand how transactions are created, updated, and persisted within EBS, and how upstream and downstream systems interact with EBS processing logic.
Identify data anomalies, configuration gaps, and breakdown points in system workflows.