Database Engineer

Tata Consultancy Services; Brussel Hoofdstad; Sur place; EUR 42 000 - 65 000; Plein temps

Résumé du poste

Tata Consultancy Services (TCS) Belgium is seeking a junior database specialist to develop and maintain data models, schemas, and SQL components. You will ensure data integrity, performance, and security across relational and non-relational databases, with opportunities to work in a multi-cultural environment.

Responsibilities include writing optimized DDL, procedures, and queries, plus prototyping solutions and supporting deployment. A focus on testing and documentation completes the role.

Qualifications

• Junior level with database development experience.
• Knowledge of relational DBMS (PostgreSQL, Oracle) required.
• Proficiency in SQL and procedural SQL extensions (PL/SQL/PLpgSQL).
• Familiarity with data modeling concepts (conceptual, logical, physical).
• Experience with Agile practices in database delivery.

Responsabilités

• Develop and maintain data models (conceptual, logical, physical).
• Design scalable database schemas, tables, views, indexes, and relationships.
• Write and optimize DDL scripts for multiple DBMS.
• Develop, maintain and integrate database components.
• Translate requirements into efficient database structures, stored procedures, and functions.
• Prototype database solutions for stakeholder validation before production.
• Develop and execute comprehensive test plans for database components.
• Write and maintain technical documentation.
• Assist with deployment and configuration of the system.
• Troubleshoot performance issues, optimize queries, and implement indexing strategies.
• Write and optimize complex SQL queries, stored procedures, functions, and triggers.
• Enforce database security policies and encryption.
• Design data migration, backup, and recovery strategies.

Connaissances

Data modeling

SQL

Database design

Performance tuning

Security & compliance

Backup & recovery

Agile in database delivery

Unit testing

PL/SQL/PLpgSQL

Outils

Oracle SQL Developer Data Modeler

Hackolade

NoSQL Workbench

Oracle SQL Developer

DBeaver

pgAdmin

SQL Workbench/J

Description du poste

Location: Brussels, Belgium

Company: Tata Consultancy Services (TCS) Belgium

Employment Type: Full-time

Nature of the 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 (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.

Specific Expertise and Technologies

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

Minimum Level of Expertise

• Junior

Certification and/or Standards (Optional)

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

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.