Architectural Design & Adaptation: Define or adjust the existing architecture to align with the specific requirements of DataHub platform’s, ensuring scalability, reliability, and security.
Data Modelling & Normalisation: Conduct thorough data analysis, create Entity‑Relationship Diagrams (ERDs), and apply Boyce‑Codd Normal Form (BCNF) to guarantee optimal data structure and minimal redundancy.
Technical Support for Integration Teams: Assist the technical teams that use the DataHub platform by providing guidance, troubleshooting, and best‑practice recommendations during system integration activities.
Issue Resolution: Identify, analyse, and resolve technical problems that arise during the operation of the solution, ensuring minimal disruption to services.
Component & Building‑Block Development: Design and develop reusable architecture components and building blocks that can be leveraged across multiple projects and modules.
Collaboration & Communication: Participate actively in technical working groups, progress meetings, and user‑focused sessions to convey architectural decisions, gather feedback, and align expectations.
Requirements
Good knowledge of Git and CI/CD pipelines as applied to relational databases (ex: Liquibase)
Very good knowledge of Relational databases (preferably Oracle 19c or newer)
Very good knowledge of database design
Good knowledge of stored procedures, and deployment packages (PL/SQL)
Very good knowledge of writing complex SQL Queries to manage data across multiple databases and tables
Good knowledge of conducting database troubleshooting including data validations to ensure that the information is intact, correct, and accessible
Good knowledge of UNIX/LINUX and Bash/KornShell Scripts
Good knowledge of software lifecycle development tools like Jira
Basic knowledge of database administration
Basic knowledge of Application Servers (Oracle WebLogic Server, Tomcat, etc.)
Basic knowledge of Agile methodology
Knowledge of modern data engineering techniques (parquet, deltaparquet, Databricks, Synapse or Fabric) would be an asset, as these are planned to be used in the future of the system.
Knowledge of the HR domain will be a bonus
Tech Stack
Linux
Oracle
SQL
Unix
Benefits
Good knowledge of Git and CI/CD pipelines as applied to relational databases (ex: Liquibase)
Very good knowledge of Relational databases (preferably Oracle 19c or newer)
Very good knowledge of database design
Good knowledge of stored procedures, and deployment packages (PL/SQL)
Very good knowledge of writing complex SQL Queries to manage data across multiple databases and tables
Good knowledge of conducting database troubleshooting including data validations to ensure that the information is intact, correct, and accessible
Good knowledge of UNIX/LINUX and Bash/KornShell Scripts
Good knowledge of software lifecycle development tools like Jira
Basic knowledge of database administration
Basic knowledge of Application Servers (Oracle WebLogic Server, Tomcat, etc.)
Basic knowledge of Agile methodology
Knowledge of modern data engineering techniques (parquet, deltaparquet, Databricks, Synapse or Fabric) would be an asset, as these are planned to be used in the future of the system.