Database Engineer

2.6.1. Nature of tasks – Develop and maintain conceptual, logical, and physical data models to represent business requirements and ensure data integrity. – 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 (such as CREATE, ALTER or equivalent) for various database management systems (DBMS). – Develop, maintain and integrate 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. – Write 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. 2.6.2. Level of education 2.6.2.1.
Minimum Requirement – Bachelor’s degree (EQF Level 6) in Computer Science, Engineering, Business Management or equivalent. 2.6.2.2.
Other skills and expertise – Not applicable. 2.6.3. Professional experience 2.6.3.1.
Minimum Requirement – As defined in section 1.1 Seniority level. 2.6.3.2.
Other skills and expertise – 10 years of experience working in international/intergovernmental organisations or central national administrations. – 5 years of experience working in the pharma, health or agrifood sectors 2.6.4. Specific expertise and technologies 2.6.4.1.
Minimum Requirement – 15 years of experience in data modelling (conceptual, logical, physical) and schema management using database IDEs (such as Oracle SQL Developer, SQL Workbench or equivalent). – 15 years of experience of relational database systems (such as PostgreSQL, Oracle or equivalent) including database release management. – 15 years of experience of working with SQL to develop complex queries, procedures and other extensions, using e.g. PL/SQL for Oracle, PL/pgSQL for PostgreSQL or equivalent – 10 years of experience of unit testing frameworks (such as utPLSQL, SQLTest or equivalent) and experience designing repeatable tests for database logic. – 10 years of experience on database performance optimization (query tuning, indexing, execution plans). – 5 years of experience of non-relational database systems (such as MongoDB, Dynamo DB, Cassandra, CosmosDb or equivalent). – 5 years of experience managing backup, recovery, and ensuring high availability (replication, clustering) of databases. 2.6.4.2.
Other skills and expertise – 10 years of experience wit business intelligence report design and analytics using such as Business Objects, Qlik, PowerBI or equivalent. – 10 years of experience using issue tracking tools (such as JIRA or equivalent) and collaboration tools (such as Confluence, SharePoint or equivalent) to support planning and delivery. – 10 years of experience using case management systems or similar, i.e. systems managing documents and / or files with workflow, business rules, database management and back-office functionality for querying, analysis or reporting. – 3 years of experience of EU rules on data protection. 2.6.5. Certificates and/or Standards 2.6.5.1.
Minimum Requirement – Not applicable. 2.6.5.2.
Other skills and expertise – One of the following or an equivalent certification:
• Oracle Database SQL Certified Associate
• Oracle Certified DBA Professional
• Microsoft Fabric Analytics Certificate
• Microsoft Azure Database Administrator Associate
• MongoDB Certified DBA
• AWS Certified Database
- Specialty 2.6.6. Skills 2.6.6.1.
Minimum Requirement – 10 years of experience in writing structured technical documents. – 10 years of experience in delivering technical presentations for varied type of stakeholders. – 10 years of experience in adopting evolving database technologies and integrating them into existing architectures. 2.6.6.2.
Other skills and expertise Not applicable. 2.6.7. Languages 2.6.7.1.
Minimum Requirement – English: level C1 (speaking, writing, reading, listening) of the Common European Framework of Reference for Languages (CEFR). 2.6.7.2.
Other skills and expertise – Not applicable.