ProductJobs.io
← Back to all jobs
TMS LLC

Technical Product Owner | Oracle EBS | SQL | Order Management

TMS LLC
Irving, TX Full time Posted 1h ago
Application Support Data Analysis Data Analytics Data Processing Database Databases Enterprise Operations & Technology Oracle APEX Oracle Database Oracle EBS Oracle Pl/sql Product Management Product Operations Product Owner Reporting and Analytics SQL
Apply Now

Job Description

TMS LLC is seeking a Technical Product Owner to support and enhance Oracle E-Business Suite (EBS) across order management and integrated system workflows.

Responsibilities

  • Own and manage backlog items for Oracle EBS-driven systems and integrations
  • Perform independent deep-dive troubleshooting by writing and executing complex Oracle SQL queries (including custom table structures)
  • Trace transaction lifecycles across multiple EBS modules and integrations
  • Drive root cause analysis using EBS data, logic, and execution paths without waiting on engineering for initial diagnosis
  • Read and interpret PL/SQL objects including stored procedures, packages, triggers, and Oracle functions
  • Read and interpret Oracle EBS application logic and customization layers
  • Review and interpret JSON requests and responses for integrations and business events
  • Translate findings into user stories, defect tickets, and enhancement requests
  • Define acceptance criteria grounded in actual system behavior
  • Lead QA testing activities:
    • Develop documented test cases
    • Create test data
    • Execute test cases and document results
    • Troubleshoot defects
    • Provide 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 behavior
  • Trace and validate end-to-end transaction flows across EBS and integrated systems
  • Confirm fixes resolve underlying data and logic issues
  • Use SQL to:
    • Diagnose production issues
    • Validate data integrity
    • 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
    • Custom extensions and client-specific configurations
    • How EBS logic and functions are customized in the environment
  • Take a lead role in functional QA for features, enhancements, integrations, and bugfixes, including validation with warehouse operators post-deployment
  • Navigate multiple EBS environments (Model, Pre-Prod, Prod) to identify inconsistencies and root causes
  • Use both database-level and application-level analysis to understand system behavior
  • Apply Oracle EBS functional knowledge under the hood for:
    • Order management
    • Inventory and fulfillment processing
    • Transaction lifecycle and state transitions
  • Understand how transactions are created, updated, and persisted within EBS
  • Understand upstream and downstream interaction patterns with EBS processing logic
  • Identify data anomalies, configuration gaps, and workflow breakdown points

Requirements

  • 5–8 years of experience in one or more of:
    • Oracle EBS Technical Analyst
    • Business Systems Analyst (EBS-focused)
    • Technical Product Owner supporting Oracle EBS
  • Strong hands-on SQL expertise for Oracle
  • Comfort writing complex queries for troubleshooting production issues
  • Experience reading and interpreting PL/SQL stored procedures, packages, triggers, and Oracle functions
  • 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 EBS data and system logic
  • Proven ability to translate technical findings into actionable product requirements

Technologies

  • Oracle E-Business Suite (EBS)
  • SQL
  • PL/SQL
  • JSON
  • Oracle APEX

Preferred Qualifications

  • Experience working in heavily customized Oracle EBS environments
  • Familiarity with Oracle APEX, including 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)

Location: Irving, TX (hybrid)

Minimum experience: 5 years

EEO: All information kept confidential according to EEO guidelines.

Similar Jobs