Oracle 19c applications DBA/Developer – EBS
Role: Oracle 19c applications DBA/Developer – EBS
Location: Alpharetta, GA (Locals)
Position Type: Contract
Mandatory Skill:
Job Description:
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
Skill/Experience/Education
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).
To apply for this job email your details to pankaj.singh@allegisit.com