Application Architect

Summary

Join European Dynamics as an Application Architect (Oracle) and work remotely within the European Union. This role involves collaborating with a major client's IT team and the company's development team. Responsibilities include reviewing existing system architecture, analyzing information system integration, designing data warehouse components, and producing related documentation. The ideal candidate will possess a university degree in IT, 13+ years of relevant experience, extensive Oracle experience, and strong knowledge of relational DBMS and Java. European Dynamics offers competitive remuneration, either on a contract basis or with a full benefits package.

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

Responsibilities

• 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

Benefits

Competitive remuneration (either on contract basis or remuneration with full benefits package)