Senior Database Architecture

SCI&B LLC
5 days ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Tech stack

Java
Amazon Web Services (AWS)
Databases
Continuous Integration
Data Architecture
Data Governance
ETL
Github
PostgreSQL
Query Optimization
Migration Manager
SQL Stored Procedures
Qliksense
Sql Optimization
Indexer
Backend
Database Migration
Data Lake
QlikView
Front End Software Development
Jenkins

Job description

Senior Database Architecture to lead a 3-month assessment of PostgreSQL (PSI) database environment for Impact and Qlikview/Qliksense scope and define the target architecture and migration strategy toward a the datalake.

Main Responsibilities:

AS IS Assessment:

  • Perform a comprehensive analysis of the existing PostgreSQL database environment

  • Document schemas, tables, relationships, constraints, triggers, and stored procedures

  • Identify data producers, ETL processes, and upstream source systems

Target Architecture Definition (TO BE) and migration strategy

  • Work with global CTO to define the target structe on SCIB Datalake, align with Santander data governance standards, ...

  • Define migration roadmap and phases, rollback plan, timeline, ...

Requirements

7 years' experience; strong architecture + hands-on backend development

Java (Spring) strong backend focus (no frontend-only profiles)

Advanced SQL skills (CTE, query tuning, indexing, execution plans)

Experience with database migration and system modernization

Solid understanding of application & data architecture

Exposure to infrastructure, CI/CD (Jenkins/GitHub Actions), and AWS is a plus

Experience in regulated environments preferred

Apply for this position