Oracle Aex Developer & Lead

Role & responsibilities

1.OracleAPEXDevelopment:

• Design, develop, and maintainOracleAPEXapplications
• 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 performance
• Creating reusable components

3.OracleLDAP:

• Candidates should be familiar withOracleLDAP structure;on reading/updating the LDAP directories
• Integrate Oracle APEX applications withOracleLDAPfor authentication and authorization
• Manage and troubleshootLDAP-related issues and configurations.

4. Unix & Shell Scripting:

• Develop and maintainUnix shell scriptsfor 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

5. 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