Job Purpose

Intercontinental Exchange (ICE) is seeking a London based Senior Oracle PL/SQL Developer to join the Clearing Risk Technology Department. The Department is focused on the development and maintenance of various database applications supporting Risk Management for all the Intercontinental Exchange Clearing Houses. The successful candidate will have considerable and proven experience in database design, PL/SQL development, a good working knowledge of end-user and server-side data processing techniques, a good understanding of SDLC and agile development methodologies. At ICE you will play a key role in developing systems which provide clearing services to global banks and commodity traders vital to the support of economies around the world.

The successful candidate will be a self-starter and conscientious programmer capable of building reusable software components. You will have a strong desire to understand, support and improve our business of derivatives clearing.

Excellent communication and presentation skills are necessary as the position will require authoring of data models, system designs and diagrams as well as user and technical documentation.

Responsibilities
*90% PL/SQL development work and 10% Database Administration work
*Develop business requirements into implementable architecture and designs
*Take ownership of key systems and build reusable components and frameworks
*Work closely with Business units and support QA with test procedures and environments
*Assist in writing functional specifications, operations and technical documentation
*Maintain awareness of new Oracle features and techniques and develop an innate understanding of their application to develop robust, reliable and high-performance solutions
*Willing to take on-call Production rotation and occasional weekend work

Knowledge and Experience
*Detailed experience developing PL/SQL Oracle Technologies (e.g. complex views/joins, analytical functions, regular expressions, table partitioning, materialised views, distributed transactions, transactional & analytical systems) and Oracle SQL Performance/Tuning
*Advanced proficiency with PL/SQL Packages/Functions/Procedures programming and debugging, Oracle Collection and Object Types
*Strong working knowledge of, algorithms, design patterns, data structures and application to large data-sets
*Building of business applications from design to live production systems
*Ability to work independently, productively under pressure, and multi-task effectively
*Strong interpersonal skills and ability to contribute well in a team environment-a team player
*Understanding of SDLC process, agile program management concepts and version control
*Bachelor’s degree or equivalent in Computer Science or related fields; or equivalent experience required

Preferred:
*Oracle 12c, 19c and RAC experience
*Understanding of Version control using Git (Bitbucket)
*Experience working in Unix/Linux environment
*Tableau and Oracle Application Express (APEX)
*Understanding of messaging middleware
*Exposure to financial markets - particularly in futures and options
*Exposure to job scheduling tool (such as Tidal, Autosys, etc)

Schedule

This role offers work from home flexibility of one day per week.