Role & responsibilities
1. Oracle APEX Development :
- Design, develop, and maintain Oracle APEX applications
- Optimize application performance
- Creating configurable reports and reusable components
2. PL / SQL Development :
Design, develop, and maintain PL / SQL scripts, stored procedures, packages, triggers etc.Write complex SQL queries and optimize them for maximum performanceCreating reusable components3. Oracle LDAP :
Candidates should be familiar with Oracle LDAP structure; on reading / updating the LDAP directoriesIntegrate Oracle APEX applications with Oracle LDAP for authentication and authorizationManage and troubleshoot LDAP-related issues and configurations.4. Unix & Shell Scripting :
Develop and maintain Unix shell scripts for automation of database tasks, data loading, and processesPerform regular maintenance and monitoring and transferring of feed filesKnowledge in SSH, SFTP and file encryption protocols5. ETL Processes & Data Loading : -
Design and implement ETL processes for data extraction, transformation, and loadingEnsure data integrity and accuracy during the ETL processDevelop scripts and tools for data loading and migration6. REST & Web Service API : - Develop and consume REST and Web Service APIs in Oracle APEX applications
Skills Required
Oracle Apex, Unix, Pl / sql, Shell Scripting, Plsql, Unix Shell Scripting