DATABASE ENGINEER

Ayesa Digital; Brussel Hoofdstad; Sur place; EUR 65 000 - 90 000; Plein temps

Résumé du poste

Ayesa Digital is seeking a DataBase Engineer to join our international team in Belgium. You will design, implement and optimize database schemas and objects, ensuring data integrity across Oracle, PostgreSQL and NoSQL systems.

Responsibilities include writing efficient DDL and DML, developing procedures, prototyping solutions, and ensuring security, backups, and high availability while aligning with Agile DB delivery practices.

Qualifications

• Knowledge of conceptual, logical and physical data modelling.
• Experience with Oracle, PostgreSQL and non-relational databases.

Responsabilités

• Design and implement database schemas and objects.
• Write and optimize DDL scripts for multiple DBMS.
• Develop, maintain and integrate database components.
• Translate requirements into efficient database structures and procedures.
• Prototype database solutions for validation with stakeholders.
• Test database components and data integrity.
• Write technical documentation.
• Assist with deployment and configuration.
• Troubleshoot performance issues and implement indexing strategies.
• Write and optimize complex SQL, stored procedures, functions and triggers.
• Enforce data security policies and encryption.
• Design data migration, backup and recovery strategies.

Connaissances

Data modelling

SQL

PL/SQL

PL/pgSQL

Performance tuning

Security concepts

Data migration

Database release management

Agile practices

Query optimization

Formation

Bachelor's degree in a related field

Outils

Oracle SQL Developer Data Modeler

Hackolade

NoSQL Workbench

Oracle SQL Developer

DBeaver

pgAdmin

SQL Workbench/J

Description du poste

At Ayesa Digital, we grow with you.

Every professional in our company is essential. Thanks to their talent, we continue to expand: today, we are a global team of more than 11,000 people working toward a shared mission.

Ayesa Digital is currently participating in high-impact European Union projects designed to address major European challenges and drive science and innovation. These strategic technological initiatives stand out for their international scope and strong commitment to socially oriented results.

We are looking for a DataBase Engineer to join our international team and contribute to the develop and maintain conceptual, logical, ans physical data models to represent business requeriments and ensure data integrity.

Key Responsibilities

• Design performant, secure, and scalable database schemas, tables, views, indexes, and relationships based on approved data models.
• Implement database designs by writing and optimizing Data Definition Language (DDL) scripts (e.g., CREATE, ALTER) for various database management systems (DBMS).
• Development, maintenance and integration of database components.
• Translate user and application requirements into efficient and effective database structures, stored procedures, and functions.
• Prototype database solutions (schemas, queries, test datasets) for validation with stakeholders before production rollout.
• Develop and execute comprehensive test plans for database components, including unit tests for stored procedures and data integrity tests.
• Writing of technical documentation.
• Assistance with deployment and configuration of the system.
• Troubleshoot and resolve database performance issues, conduct query optimization, and implement indexing strategies.
• Write and optimize complex SQL queries, stored procedures, functions, and triggers to support application functionality.
• Implement and enforce database security policies, access controls, and data encryption in line with organizational standards.
• Design and implement robust data migration, backup, and recovery strategies to ensure business continuity.

What We Are Looking For (Requirements):

• Knowledge of data modelling (conceptual, logical, physical) and experience with tools like Oracle SQL Developer Data Modeler, Hackolade, or NoSQL Workbench.
• Experience with database IDEs (Oracle SQL Developer, DBeaver, pgAdmin, SQL Workbench/J) for schema management and queries.
• Good knowledge of relational database systems (e.g. PostgreSQL, Oracle).
• Good knowledge of non-relational database systems (e.g. MongoDB, Dynamo DB, Cassandra, CosmosDb).
• Good knowledge of SQL.
• Good knowledge of procedural SQL extensions, such as PL/SQL for Oracle or PL/pgSQL for PostgreSQL.
• Good knowledge of procedural SQL extensions, such as PL/SQL for Oracle or PL/pgSQL for PostgreSQL.
• Good experience of database release management.
• Understanding of Agile practices (Scrum, Kanban) and experience with applying Agile in database delivery (iterative schema changes, continuous integration).
• Knowledge of performance optimization (query tuning, indexing, execution plans).
• Experience with backup, recovery, and high-availability (replication, clustering).
• Knowledge of data security and compliance practices.

One of the following or an equivalent certification:

• Oracle Database SQL Certified Associate.
• Microsoft Azure Database Administrator Associate.
• MongoDB Certified DBA.
• AWS Certified Database - Specialty.

What We Offer:

• Prestigious projects within European institutions.
• International, innovative, and multicultural environments.
• Continuous support from a team of experts in EU projects.

If you are ambitious, enthusiastic, and seeking a new professional challenge in international projects with real-world impact, this is the place for you!

In accordance with Organic Law 3/2007 of March 22, the company is committed to promoting the defense and effective application of the principle of equality between men and women, preventing any type of labor discrimination based on sex, and guaranteeing equal entry opportunities. Furthermore, we promote diversity and reject any discrimination based on race, gender, functional diversity, religion, sexual orientation, gender identity, or any other personal or social condition, striving to build an inclusive and enriching environment.