Siam Makro Public Company Limited

Engineer

• **Role Summary**** We are looking for experienced Oracle Retail Techno-Functional Consultants who can work across key Oracle Retail modules (RMS, ReIM, RPM, ReSA and SIM) with strong hands-on technical skills in PL/SQL, Shell Scripting, Pro*C, Oracle Forms, Java, and related Oracle Retail technologies. The role involves working closely with business and IT stakeholders to analyze requirements, design solutions, implement changes, support production issues, and participate in enhancement/rollout projects.
• ***We are open for remote candidates.***
• **Functional (Oracle Retail – RMS, ReIM, RPM, ReSA, SIM)**
• - Work with business users to gather, analyze, and document requirements across merchandising, pricing, invoice matching, store operations, and sales audit.
• - Provide functional expertise in:
• - RMS – item/sku setup, purchase orders, transfers, inventory management, cost, and deals.
• - ReIM – invoice matching, tolerance setup, discrepancy handling, supplier funding.
• - RPM – price changes, promotions, markdowns, clearance strategies.
• - ReSA – sales audit, store sales data validation, error correction workflows.
• - SIM – store inventory management, stock counts.
• - Perform fit–gap analysis and propose solutions aligned with Oracle Retail best practices.
• - Support UAT, prepare test scenarios, test data, and help business users with functional validation.
• - Analyze and provide root-cause for production issues, recommend fixes and workarounds.
• **Technical (Oracle Retail Core Technologies)**
• - Design and develop customizations, extensions, interfaces, and reports using:
• - Oracle PL/SQL (packages, procedures, functions, views)
• - Shell scripting for batch jobs and integrations
• - Pro*C / batch programs used in Oracle Retail
• - Oracle Forms (where applicable) and Java components
• - Optimize SQL/PLSQL for performance and stability in high-volume retail environments.
• - Support and troubleshoot batch processes, scheduled jobs and EOD/EOM cycles.
• - Prepare and maintain technical design documents, configuration documents, and deployment guides.

Oracle Retail Engineer

Security Engineer

• The Head of Cyber Security is responsible for leading and managing the organization’s cybersecurity strategy, governance, risk management, and operational security functions
• This role ensures the security of IT infrastructure, applications, and data across the wholesale business while aligning cybersecurity initiatives with business objectives
• The role also oversees compliance with regulatory requirements and industry best practices to mitigate cybersecurity risks
• Develop and implement cybersecurity policies, standards, and guidelines to align with business needs and regulatory requirements
• Lead enterprise-wide risk assessment and mitigation strategies to ensure cybersecurity resilience
• Establish a cybersecurity governance framework, ensuring adherence to compliance requirements (e.g., ISO 27001, NIST, GDPR, PDPA)
• Manage third-party security risks, including vendor security assessments and contractual compliance
• Design and implement robust security architectures to protect the organization's IT assets and digital infrastructure
• Work closely with IT teams to integrate security into cloud environments, network systems, and enterprise applications
• Oversee vulnerability management, penetration testing, and secure software development lifecycle (SDLC) practices
• Develop and manage IAM strategies, ensuring appropriate user access controls and authentication mechanisms
• Oversee Privileged Access Management (PAM) and Single Sign-On (SSO) solutions to strengthen security posture
• Ensure role-based access control (RBAC) and least privilege principles are enforced across systems
• Lead the Security Operations Center (SOC) to monitor, detect, and respond to cybersecurity threats in real time
• Oversee incident response, forensic investigations, and cyber threat intelligence initiatives
• Implement advanced security analytics, Security Information and Event Management (SIEM), and threat-hunting capabilities
• Develop and execute cybersecurity awareness training programs for employees

Associate Director – Cyber Security

• Develop and implement the organization’s offensive security strategy.
• Lead red teaming and advanced persistent threat (APT) simulations to assess security defenses.
• Oversee enterprise-wide penetration testing programs and provide risk-based recommendations.
• Manage a team of offensive security professionals and oversee security assessments.
• Perform threat modeling and attack simulations against critical IT assets.
• Collaborate with executive leadership to align offensive security with business objectives.
• Evaluate and integrate advanced security tools and technologies for attack simulation.
• Provide technical leadership in security research, vulnerability analysis, and adversary tactics.
• Deliver strategic insights and reports to C-level executives and security committees.
• Drive internal cybersecurity awareness and training initiatives.
• Keep up with global cybersecurity trends, new attack techniques, and regulatory changes.

Associate Director – Cyber Security Offensive Engineer

• Perform advanced penetration testing on networks, applications, cloud environments, and IT infrastructure.
• Conduct vulnerability assessments and security audits to identify and mitigate risks.
• Develop and execute simulated cyber-attacks to test security defenses.
• Research and utilize latest attack methodologies to assess resilience against real-world cyber threats.
• Perform threat modeling to anticipate potential attack vectors and weaknesses.
• Develop custom security tools and scripts for automation and testing purposes.
• Provide detailed reports on security vulnerabilities, risks, and recommended mitigations.
• Work with the Blue Team to enhance cybersecurity strategies and improve defensive measures.
• Keep up-to-date with emerging security threats, vulnerabilities, and exploits.
• Educate internal teams on offensive security techniques and best practices.

Senior Manager – Cyber Security Offensive Engineer

Data Engineer

• Design, develop, and maintain Oracle Retail Analytics Data Warehouse solutions.
• Build and optimize dimensional models (fact and dimension tables).
• Ensure data accuracy, consistency, and performance.
• Develop and maintain ETL pipelines using Oracle Data Integrator (ODI).
• Integrate data from retail systems such as POS, merchandising, and supply chain.
• Implement data quality checks and optimize ETL performance.
• Develop dashboards using Oracle Business Intelligence Enterprise Edition (OBIEE).
• Create operational and management reports using BI Publisher (BIP).
• Translate business requirements into analytics solutions.
• Strong SQL and PL/SQL for transformation and performance tuning.
• Handle large-scale datasets efficiently.
• Apply best practices in data modeling and query optimization.
• Monitor data loads and reports.
• Troubleshoot production issues and performance bottlenecks

Oracle Retail Engineer

Associate Director – Cyber Security

Associate Director – Cyber Security Offensive Engineer

Senior Manager – Cyber Security Offensive Engineer

Retail Data Warehouse Engineer