Database Engineer

Tata Consultancy Services

Brussel, Belgium

1 day ago

Apply on www.adzuna.be

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Starter

Working hours

Regular working hours

Job source

www.adzuna.be

Tech stack

Agile Methodology Amazon Web Services Unit Testing Microsoft Azure Databases Continuous Integration Data Definition Language Data Integrity Data Migration Data Security Relational Databases Database Design

+26 more

Database Security Database Storage Structures Amazon DynamoDB PostgreSQL MongoDB NoSQL Oracle Databases Oracle (Applications) Oracle SQL Developer Performance Tuning Scrum Methodology Query Optimization Release Management SQL Stored Procedures PL-SQL SQL Databases Freeform SQL System Availability Database Optimization Database Performance Indexer Cassandra Non-relational Database Cosmos DB Physical Data Models Database Tools and Utilities

Job description

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., * Oracle Database SQL Certified Associate
Microsoft Azure Database Administrator Associate
MongoDB Certified DBA
AWS Certified Database - Specialty

Requirements

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., * 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.