Oracle APEX Developer

- Development experience with Oracle 19c database and Oracle APEX 24.2 or above - Experience in Oracle with SQL, PL/SQL, Performance Views, Data Dictionary, external tables, indexing, Cursors, Constraints, Job Scheduling, Materialized Views, etc - Write SQL queries and create PL/SQL functions, procedures, and packages that are optimized - Create and maintain APEX pages, Master/Detail Forms, APEX Collections, Interactive reports etc. - Create processes and scripts to load data from external file sources into Oracle Database - Provide production support for Oracle APEX Applications - Performance tuning of SQL, PL/SQL code - Follow best practices to document and track changes, synchronize development-UAT-Production environment - Troubleshoot operational issue - Trace Data, logic, and report back on root cause - Develop and provide support to all system interfaces and coordinate with stakeholders to provide specifications for all core modules - Analyze and ensure an efficient transition of all technical design documents and develop various SQL packages to provide support to all applications - Monitor and recommend changes if required to all PL/SQL packages and provide stored procedures, design, and develop various relational databases - Used PL/SQL Tables, Cursors to process vast volumes of data, and used bulk collect for a mass update as a performance improvement process