Database Engineer

Altia
Madrid, Spain
5 days ago
Apply on www.buscojobs.com.es
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Tech stack

Unit Testing Databases Data Definition Language Data Integrity Data Security Relational Databases Database Design Database Development Database Storage Structures Amazon DynamoDB PostgreSQL MongoDB
+17 more
NoSQL Oracle (Applications) Oracle SQL Developer Performance Tuning Query Optimization Release Management SQL Stored Procedures PL-SQL SQL Databases Database Optimization Database Performance Indexer Cassandra Non-relational Database Cosmos DB Physical Data Models Database Tools and Utilities

Job description

Do you want to start a new professional challenge?Check out our new opportunity!We are looking to incorporate aDatabase Engineerto our team.About usWe are an IT Consultant Group that provides services and creates digital solutions to improve the lives of citizens across Europe.Check out our website: Our project and teamThis is your opportunity to start working on international projects with a highly qualified team and applying the latest technologies.You will join our European team, specifically the one involved in several projects for a significant European Agency.Minimum RequirementsRequired KnowledgeKnowledge 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.Knowledge of unit testing frameworks (utPLSQL, SQLTest) and ability to design repeatable tests for database logic.Good experience of database release management.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.High level of English.Main ResponsibilitieDevelop 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 (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.Skills:Capability to write clear and structured technical documents.Ability to deliver technical presentations for varied type of stakeholders.Ability to apply high quality standards.Capacity to adopt evolving database technologies and integrate them into existing architectures.Ability to participate in multi-lingual meetings, ease of communication.Capability of integration in an international/multi-cultural environment.This job offer has been drafted with impartiality and non-discrimination on the basis of gender, race, ideology or any other grounds in mind.In particular, it complies with current regulations on gender equality between women and men (Royal Decree-Law **)#J-*****-Ljbffr

Requirements

Required Knowledge 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. Knowledge of unit testing frameworks (utPLSQL, SQLTest) and ability to design repeatable tests for database logic. Good experience of database release management. 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. High level of English., Capability to write clear and structured technical documents. Ability to deliver technical presentations for varied type of stakeholders. Ability to apply high quality standards. Capacity to adopt evolving database technologies and integrate them into existing architectures. Ability to participate in multi-lingual meetings, ease of communication. Capability of integration in an international/multi-cultural environment.

About the company

We are an IT Consultant Group that provides services and creates digital solutions to improve the lives of citizens across Europe. Check out our website: Our project and team This is your opportunity to start working on international projects with a highly qualified team and applying the latest technologies.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.buscojobs.com.es
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · World Congress 2021

2:01 min

Migrating existing applications from MongoDB to Postgres

Nikita Shamgunov Nikita Shamgunov · World Congress 2024

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

2:57 min

Core technical practices for robust data engineering

Sandhya Menon Sandhya Menon · World Congress 2026 Europe

1:21 min

Realizing the limitations of MongoDB for live statistics

Josip Stuhli Josip Stuhli · World Congress 2023

3:16 min

Terminology differences between relational and NoSQL databases

Tim Faulkes · LIVE

Videos

See all

Related articles

See all