PL-SQL/Apex Developer

Position Description

Job Title: Oracle Developer (Oracle PL/SQL + Oracle Apex) Location:Arnhem

Reports to: Director Solutions Developer

Summary:

• Our client is focused on finding the best logistics solutions for project(s), anywhere in the world. They makethe global transportation of furniture, fixtures &amp
• equipment (FF&amp
• E) easier, faster and more efficient. We area truly independent 4PL, finding the best carriers and rates while controlling all PO’s and shipments in ourcloud based IT platform. To this ‘Control Tower platform’ we connect customers, suppliers, carriers andgeneral contractors. All parties gain access to the same relevant (live) data, with up to date and accurateinformation &amp
• milestones on the entire inbound flow for each project.

The ‘connected environment’ ensures individual silos start acting as an integrated network. Having visibilityacross the entire network allows us to manage orders and the transportation to project job site(s) withunparalleled levels of control, coordination and (cost) efficiency. With each milestone and data-pointcaptured in our IT system, it is able to detect and highlight important ‘exceptions’ (e.g. missed deadlines,damages, backorders) to our teams for immediate follow up - significantly lowering the risk of disruptions.

The Software Developer is responsible for the technical aspects of their custom platform . He/she isresponsible for developing and implementing interfaces and other components of the platform .

• Responsibilities and essential job functions include, but are not limited to the following:
• �� Development experience with Oracle 12c database and Oracle Apex 4.x/5.x/18.x/19.x

• ��
• Experience in Oracle with SQL, PL/SQL, Performance Views, Data Dictionary, external tables,

indexing, Cursors,

• Constraints, Job Scheduling, Materialized Views

• Experience in Web/UI design involving HTML, JavaScript, jQuery, CSS and AJAX

• Experience in Oracle apex page/application items, processes, form, reports

•

Good communication skills in English

• Self-motivated, fast learner (Agile mindset)

• Write SQL queries and create PL/SQL functions, procedures and packages that are optimized

• Create and maintain Apex pages, Master/Detail Forms, Tabular 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 and 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.

•

All other duties as assigned.

Qualifications:

Educational level/ Experience level:

• �� Bachelors or Master’s Degree or equivalent education in IT field
• �� 3-5 years direct work experience of coding in Oracle PL/SQL and Oracle Apex.• Knowledge of Oracle SQL Developer, Toad, Jira, Oracle performance tuning

• Has experience as an Oracle DBA

The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonableaccommodations may be made to enable individuals with disabilities to perform the essential functions.

Skills:

Ability to document procedure manuals.

• Ability to document functional and technical aspects of software project Clear & consistent communications(both writing & speaking) in English . Must be well organized, efficient, focused , and able to multi-taskeffectively. Has a strong affinity with Supply Chain and construction projects.
• Define problems, collect data, establish facts, and draw valid conclusions.
• This position requires strong analytical/logic, communication and coding skills.
• Must have the ability to develop and understand processes, flowcharts, and IT structures and systems.

Originally posted on Himalayas