Database Engineer

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

Résumé du poste

Tata Consultancy Services is seeking a Junior Database/Data Architect to develop and maintain data models, design scalable database schemas, and implement robust data structures. The role requires strong SQL skills, knowledge of both relational and non-relational databases, and a commitment to data security.

You will join a global team to translate business requirements into efficient database designs, write DDL scripts, and contribute to deployment and documentation efforts.

Qualifications

• Experience with data modeling (conceptual, logical, physical).
• Knowledge of relational and non-relational databases (PostgreSQL, Oracle, MongoDB, DynamoDB, Cassandra, CosmosDB).
• Ability to write and optimize SQL, PL/SQL or PL/pgSQL.
• Understanding of data security, encryption, and compliance practices.

Responsabilités

• Develop and maintain data models to represent business requirements and ensure data integrity.
• Design scalable database schemas, indexes, and relationships based on data models.
• Implement database designs with DDL scripts across DBMS.
• Develop, maintain, and integrate database components.
• Translate requirements into efficient database structures and procedures.

Connaissances

Data modeling

SQL proficiency

Query optimization

Security & encryption

Documentation

Multilingual collaboration

Outils

Oracle SQL Developer Data Modeler

Hackolade

NoSQL Workbench

Oracle SQL Developer

DBeaver

pgAdmin

SQL Workbench/J

Description du poste

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