Oracle Retail Sales Audit (ReSA) Developer PL/SQL / Pro*C / UNIX Integration (RMS v16+)
Posted 1 day ago by 1762352432
Negotiable
Outside
Remote
USA
Summary: The Oracle Retail Sales Audit (ReSA) Developer role focuses on designing, developing, and supporting integrations between ReSA, RMS, and other Oracle Retail applications. The position requires extensive experience in PL/SQL, Pro*C, and UNIX scripting, specifically within an enterprise retail environment. The ideal candidate will be responsible for enhancing ReSA functionality and ensuring data consistency across systems. This is a contract position that allows for remote work.
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
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.