Database Engineer

• – 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

• – 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

• – 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

• – 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

• – Not applicable.

2.6.5.2.Other skills and expertise

• – One of the following or an equivalent certification:

2.6.6. Skills

• – 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

• – English: level C1 (speaking, writing, reading, listening) of the Common European Framework of Reference for Languages (CEFR).