Title: Lead Admin-EA Admin
Job Description
Key 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 performance
- Creating reusable components
3. 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.
4. 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
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
- Ensure secure and efficient communication between systems through API calls
- Familiarised in various authentications in webservice calls