Build, integrate, optimise, and support enterprise business applications using Oracle E-Business Suite R12 and Oracle Database 19c.
- Develop PL/SQL procedures, packages, functions, and database solutions.
- Design ERP integrations using Oracle EBS Public APIs, Interface Tables, and PL/SQL.
- Develop and optimise SQL and PL/SQL for large-volume data processing.
- Develop Oracle EBS Concurrent Programs and automated processing workflows.
- Build staging-to-interface and interface-to-base table processes with validation and error handling.
- Support ERP data migration, production troubleshooting, Linux servers, Oracle databases, and daily database backup monitoring.
- Administer Oracle EBS R12 application and database servers, including Linux server administration and monitoring.
- Manage daily NFS backup processes and perform the weekly Oracle EBS application and database server bounce.
- Maintain Oracle EBS technical and process documentation, and identify improvements to existing integrations.