Oracle Pl/sql Product Jobs

1 job found

Today

Technical Product Owner | Oracle EBS | SQL | Order Management

TMS LLC Irving, TX

Irving, TX

Today

Full time Application Support Data Analysis Data Analytics

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.

View full job page →

Get Oracle Pl/sql Product Jobs alerts

New Oracle Pl/sql Product Jobs, daily.