Core Database Skills
- Experience Oracle ERP/EBS on Modules Inventory Management and Purchase Order
- Capable to support customed instance of ERP (data and forms).
- Oracle Database 19c Administration
- Installation, configuration, and maintenance of Oracle 19c
- Performance tuning and optimization specific to Oracle 19c
- Purging and Archiving
- Data Lifecycle Management in Oracle EBS
- Developing and implementing data retention, purging, and archiving policies
- Identifying and analyzing data to be purged or archived
- Ensuring minimal disruption to business operations during purging and archiving processes
PL/SQL Programming
- Writing and optimizing PL/SQL scripts for data manipulation in Oracle EBS
- Developing stored procedures, functions, and triggers for purging and archiving
Data Migration and Archiving Tools
- Using Oracle Data Pump for data export and import
- Implementing Oracle Advanced Compression for efficient storage management
- Utilizing Oracle Partitioning to manage large tables and improve performance
Soft Skills
- Analytical Thinking
- Problem-Solving
- Attention to Detail
- Communication and Collaboration
Mandatory Skills: Solid experience working with archiving and purge processes in Oracle ERP, being able to support custom processes built exclusive for the supported business. Professional is expected to design and implement changes (with internal jobs setups and coding if required).