Oracle Retail Sales Audit (ReSA) Developer PL/SQL / Pro*C / UNIX Integration (RMS v16+)

Overview

Remote
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

API
Acceptance Testing
Batch Processing
Bitbucket
Continuous Delivery
Continuous Integration
Point Of Sale
Pro*C
RESA
Auditing
Customization
Data Conversion
Data Migration
Data Modeling
Finance
Flat File
GL
Database
Integration Architecture
Interfaces
Inventory
JIRA
Linux
Optimization
Oracle
Oracle Retail
Orchestration
PL/SQL
Performance Tuning
RMS
Sales
Scripting
Shell
System Integration Testing
Retail
RIB
Git
Writing
Unix
Unit Testing
XML

Job Details

Role- Oracle Retail Sales Audit (ReSA) Developer PL/SQL / Pro*C / UNIX Integration (RMS v16+)

Location- Remote

Duration- Contract

Job Summary:

We are seeking an experienced Oracle Retail Sales Audit (ReSA) Developer to design, develop, and support end-to-end integrations between ReSA, RMS, and other Oracle Retail Suite applications.

The ideal candidate will have deep expertise in PL/SQL, Pro*C, and UNIX scripting, with hands-on experience implementing, customizing, and supporting Oracle Retail v16 or higher in an enterprise retail environment.

Key Responsibilities:

  • Design and develop custom PL/SQL packages, procedures, and Pro*C programs to extend or enhance ReSA and RMS functionality.
  • Customize ReSA batch jobs, interfaces, and processing logic per business needs (e.g., sales feeds, tender adjustments, store day automation).
  • Develop custom UNIX shell scripts for job orchestration, file movement, and automation within the Oracle Retail batch framework.
  • Participate in configuration of ReSA foundation data, such as stores, tenders, and system options.
  • Design and implement end-to-end integration between ReSA and other inbound/outbound systems
  • Develop data conversion programs for ReSA
  • Perform unit testing, system integration testing (SIT), and user acceptance testing (UAT) for all ReSA-related components.
  • Validate transactional data consistency between POS, ReSA, and RMS.
  • Analyze and resolve discrepancies between sales totals, tender totals, and inventory adjustments.

Skills:

Oracle Retail Suite

  • Strong knowledge of ReSA v16+, RMS v16+, and above with related financial integration flows.

Database Development

  • Expert in Oracle PL/SQL, triggers, cursors, indexes, and performance tuning.

Pro*C Programming

  • Experience in developing and optimizing ReSA and RMS batch components written in Pro*C.

UNIX Shell Scripting

  • Skilled in writing and maintaining shell scripts for batch processing, automation, and file handling.

Integration & Interfaces

  • Experience with RIB, XML, flat-file, and API-based integrations.

Data Conversion

  • Ability to develop conversion programs for historical and transactional data migration.

Performance Optimization

  • Query tuning and optimization in large data volume retail environments.

Qualifications and Experience

  • Bachelor s degree in computer science, Information Technology, or related field.
  • Min 10 years of IT experience, with at least 5+ years in Oracle Retail (ReSA and RMS).
  • Hands-on experience with Oracle Database 12c/19c, UNIX/Linux, and Oracle Retail integration architecture.
  • Familiarity with ReSA data model and RMS staging and transaction tables.
  • Working knowledge of Oracle Retail Financial Integration and GL posting flows.
  • Experience with Git / Bitbucket, JIRA, and CI/CD processes preferred.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.