PLSQL - Oracle Retek (RMS) - s

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
• 5+ years of experience in Oracle Database and PL/SQL development.
• Strong experience with Oracle Retail Merchandising System (RMS/Retek).
• Expertise in writing complex PL/SQL packages, stored procedures, functions, and triggers.
• Experience with Oracle SQL performance tuning and query optimization.
• Strong understanding of retail business processes and merchandising operations.
• Experience in production support, incident management, and issue resolution.
• Familiarity with Unix/Linux environments and shell scripting.
• Experience with source control and release management processes.

Technical Skills

Oracle Technologies

• Oracle Database 11g/12c/19c
• SQL
• PL/SQL
• Performance Tuning
• Query Optimization

Oracle Retail Suite

• Oracle Retail Merchandising System (RMS)
• ReSA (Retail Sales Audit)
• RPM (Retail Price Management)
• RTM (Retail Trade Management) - Preferred
• RIB (Retail Integration Bus)
• Oracle Retail Batch Processing

Development & Integration

• Stored Procedures
• Packages
• Functions
• Triggers
• Data Migration
• Data Conversion
• Interface Development

Scripting & Operating Systems

• Unix/Linux
• Shell Scripting

Tools & Methodologies

• SQL Developer
• TOAD
• Oracle Enterprise Manager
• Git
• Agile/Scrum