Database Engineer

ulli– Develop and maintain conceptual, logical, and physical data models to represent business requirements and ensure data integrity. /lili– Design performant, secure, and scalable database schemas, tables, views, indexes, and relationships based on approved data models. /lili– Implement database designs by writing and optimizing Data Definition Language (DDL) scripts (such as CREATE, ALTER or equivalent) for various database management systems (DBMS). /lili– Develop, maintain and integrate database components. /lili– Translate user and application requirements into efficient and effective database structures, stored procedures, and functions. /lili– Prototype database solutions (schemas, queries, test datasets) for validation with stakeholders before production rollout. /lili– Develop and execute comprehensive test plans for database components, including unit tests for stored procedures and data integrity tests. /lili– Write technical documentation. /lili– Assistance with deployment and configuration of the system. /lili– Troubleshoot and resolve database performance issues, conduct query optimization, and implement indexing strategies. /lili– Write and optimize complex SQL queries, stored procedures, functions, and triggers to support application functionality. /lili– Implement and enforce database security policies, access controls, and data encryption in line with organizational standards. /lili– Design and implement robust data migration, backup, and recovery strategies to ensure business continuity. /li /ulh32.6.2. Level of education /h3ulli– Bachelor’s degree (EQF Level 6) in Computer Science, Engineering, Business Management or equivalent. /li /ulh32.6.2.2.
Other skills and expertise /h3ulli– Not applicable. /li /ulh32.6.3. Professional experience /h3ulli– As defined in section 1.1 Seniority level. /li /ulh32.6.3.2.
Other skills and expertise /h3ulli– 10 years of experience working in international/intergovernmental organisations or central national administrations. /lili– 5 years of experience working in the pharma, health or agrifood sectors /li /ulh32.6.4. Specific expertise and technologies /h3ulli– 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). /lili– 15 years of experience of relational database systems (such as PostgreSQL, Oracle or equivalent) including database release management. /lili– 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 /lili– 10 years of experience of unit testing frameworks (such as utPLSQL, SQLTest or equivalent) and experience designing repeatable tests for database logic. /lili– 10 years of experience on database performance optimization (query tuning, indexing, execution plans). /lili– 5 years of experience of non-relational database systems (such as MongoDB, Dynamo DB, Cassandra, CosmosDb or equivalent). /lili– 5 years of experience managing backup, recovery, and ensuring high availability (replication, clustering) of databases. /li /ulh32.6.4.2.
Other skills and expertise /h3ulli– 10 years of experience wit business intelligence report design and analytics using such as Business Objects, Qlik, PowerBI or equivalent. /lili– 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. /lili– 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. /lili– 3 years of experience of EU rules on data protection. /li /ulh32.6.5. Certificates and/or Standards /h3ulli– Not applicable. /li /ulh32.6.5.2.
Other skills and expertise /h3ulli– One of the following or an equivalent certification: /li /ulh32.6.6. Skills /h3ulli– 10 years of experience in writing structured technical documents. /lili– 10 years of experience in delivering technical presentations for varied type of stakeholders. /lili– 10 years of experience in adopting evolving database technologies and integrating them into existing architectures. /li /ulh32.6.6.2.
Other skills and expertise /h3ulli– Not applicable. /li /ulh32.6.7. Languages /h3ulli– English: level C1 (speaking, writing, reading, listening) of the Common European Framework of Reference for Languages (CEFR). /li /ul