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

Summary: We are looking for an experienced Oracle Retail Sales Audit (ReSA) Developer proficient in PL/SQL, Pro*C, and UNIX scripting to design and support integrations between ReSA, RMS, and other Oracle Retail applications. The ideal candidate will have extensive experience in implementing and customizing Oracle Retail v16 or higher in a retail environment. This role requires strong technical skills and the ability to analyze and resolve discrepancies in sales and inventory data. The position is remote and classified as outside IR35.

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.

Key Skills:

• Strong knowledge of ReSA v16+, RMS v16+, and above with related financial integration flows.
• Expert in Oracle PL/SQL, triggers, cursors, indexes, and performance tuning.
• Experience in developing and optimizing ReSA and RMS batch components written in Pro*C.
• Skilled in writing and maintaining shell scripts for batch processing, automation, and file handling.
• Experience with RIB, XML, flat-file, and API-based integrations.
• Ability to develop conversion programs for historical and transactional data migration.
• Query tuning and optimization in large data volume retail environments.
• 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.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT