PL-SQL/Apex Developer

The Preferred Supplier; Arnhem; On-site; EUR 50,000 - 70,000; Full time

Job summary

A leading logistics solutions provider in Arnhem is seeking an Oracle Developer with expertise in Oracle PL/SQL and Apex. In this role, you will develop and maintain database solutions, provide production support, and optimize performance. Ideal candidates will have a Bachelor's or Master's degree in IT and 3-5 years of relevant experience. Strong communication skills in English are required to manage projects effectively.

Qualifications

• 3-5 years direct work experience coding in Oracle PL/SQL and Oracle Apex.
• Knowledge of Oracle performance tuning.
• Has experience as an Oracle DBA.

Responsibilities

• Develop SQL queries and create PL/SQL functions, procedures and packages.
• Create and maintain Apex pages, forms, and reports.
• Provide production support for Oracle Apex applications.

Skills

Oracle PL/SQL

Oracle Apex

SQL tuning

Communication in English

Agile mindset

Analytical skills

Education

Bachelor’s or Master’s Degree in IT field

Tools

Oracle SQL Developer

Toad

Jira

Job description

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 make the global transportation of furniture, fixtures & equipment (FF&E) easier, faster and more efficient. We are truly independent 4PL, finding the best carriers and rates while controlling all PO’s and shipments in our cloud based IT platform. To this ‘Control Tower platform’ we connect customers, suppliers, carriers and general contractors. All parties gain access to the same relevant (live) data, with up to date and accurate information & milestones on the entire inbound flow for each project.

The ‘connected environment’ ensures individual silos start acting as an integrated network. Having visibility across the entire network allows us to manage orders and the transportation to project job site(s) with unparalleled levels of control, coordination and (cost) efficiency. With each milestone and data point captured 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.

Responsibilities and Essential Job Functions

• 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 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 –
• 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

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

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‑task effectively
• 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

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.