Application Architect (Oracle)

View full description

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