Application Architect, Oracle

Role Overview

• Review of the architecture of existing systems;
• Analysis of the integration of different information systems;
• Design, review and development of datawarehouse architecture components;
• Production of datawarehouse architecture documents, design and analysis models, implementation models;
• Follow up of the data analysis and data modelling;
• Documentation of the technical implementations;
• Provide assistance or support in the resolution of production issues and data quality issues;
• Assistance in the testing, the technical documentation, the deployment, the evaluation and the reporting.

Requirements

• University degree in IT or relevant discipline, combined with minimum 13 years of relevant working experience in IT;
• More than 12 years of experience with ORACLE, ORACLE advanced PL/SQL(advanced cursors, advanced exception handling, advanced database triggers, dynamic SQL/PL/SQL), PL/SQL procedures and packages, performance tuning and Microsoft SQL server DB, and demonstrable experience with ORACLE external procedures, Flashback features, Publish-Subscribe Model, Microservices Architecture, Sagas APIs, Lock-Free Reservation, Sessionless Transactions, Edition-Based Redefinition, Transaction Guard, DDL Change Notification;
• Excellent knowledge of Relational DBMS and DB applications;
• Very good working experience of Java;
• Good knowledge of UML and modelling tools;
• Good knowledge of RDBMS microservices architecture and database architecture in the cloud;
• Good knowledge of data warehouse applications design;
• Good knowledge of Enterprise Data Warehouse Architecture;
• Good knowledge of ETL tools and complex file transformation and processing;
• Good knowledge of Wiki and collaborative sites;
• Knowledge of software development methodologies (e.g. RUP, Agile);
• Excellent command of the English language.

Tech Stack

• Cloud
• ETL
• Java
• Microservices
• MS SQL Server
• Oracle
• RDBMS
• SQL

Benefits

• If you are seeking a career in an exciting, dynamic and multicultural international environment with exciting opportunities that will boost your career, please send us your detailed CV in English, quoting reference (18283/02/2025).
• We offer a competitive remuneration (either on contract basis or remuneration with full benefits package), based on qualifications and experience.
• All applications will be treated as confidential.
• You may also consider all our other open vacancies by visiting the career section of our web site (www.eurodyn.com) and follow us on Twitter (@EURODYN_Careers) and LinkedIn.
• **EUROPEAN DYNAMICS **(www.eurodyn.com) is a leading European Software, Information and Communication Technologies company, operating internationally (Athens, Brussels, Luxembourg, Copenhagen, Berlin, Stockholm, London, Nicosia, Valetta, Vienna, Den Haag, Hong Kong, etc.) The company employs over 1000 engineers, IT experts and consultants (around 3% PhD, 36% MSc and 53% BSc). We design and develop software applications using integrated, state-of-the-art technology. Our current IT projects have a value exceeding 300 million EURO. EUROPEAN DYNAMICS is a renowned supplier of IT services to European Union Institutions, international organizations, European Agencies and national government Administrations in 40 countries and 4 continents.
• As part of our dedication to the diversity of our workforce, we are committed to Equal Employment Opportunity without regard for race, color, age, national origin, ethnicity, gender, disability, sexual orientation, gender identity or religion.
• EUROPEAN DYNAMICS (ED) adheres to the General Data Protection Regulation principles by applying its Privacy Policy as published in www.eurodyn.com/privacy. By submitting an application to this position and by sharing your personal data with ED, you acknowledge and accept its Policy and authorise ED to process your personal data for the purposes of the company's recruitment opportunities, in line to the Policy.