* nyb - senior database architecture (remote)
location: remote, mx (must be able to work ny working hours)
duration: 3 months initially, with possibility to extend
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, ...
candidate 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