Oracle Aex Developer & Lead

Role & responsibilities

• Oracle APEX Development:
• Design, develop, and maintain Oracle APEX applications
• Optimize application performance 
• Creating configurable reports and reusable components
• PL/SQL Development:
• Design, develop, and maintain PL/SQL scripts, stored procedures, packages, triggers etc.
• Write complex SQL queries and optimize them for maximum performance
• Creating reusable components 
• Oracle LDAP:
• Candidates should be familiar with Oracle LDAP structure; on reading/updating the LDAP directories
• Integrate Oracle APEX applications with Oracle LDAP for authentication and authorization
• Manage and troubleshoot LDAP-related issues and configurations.
• Unix & Shell Scripting:
• Develop and maintain Unix shell scripts for automation of database tasks, data loading, and processes
• Perform regular maintenance and monitoring and transferring of feed files
• Knowledge in SSH, SFTP and file encryption protocols
• ETL Processes & Data Loading:  - Design and implement ETL processes for data extraction, transformation, and loading  - Ensure data integrity and accuracy during the ETL process  - Develop scripts and tools for data loading and migration 6. REST & Web Service API:  - Develop and consume REST and Web Service APIs in Oracle APEX applications 
• Ensure secure and efficient communication between systems through API calls
• Familiarised in various authentications in webservice calls