#29 - Senior Database Architecture

About the role Lead a 3-month assessment of a PostgreSQL (PSI) database environment (Impact and Qlikview/Qliksense scope), define the target architecture, and drive the migration strategy toward the SCIB Data Lake aligning with the bank data governance standards. Main responsibilities AS IS assessment - Comprehensive analysis of the existing PostgreSQL environment - Document schemas, tables, relationships, constraints, triggers, and stored proceduresIdentify data producers, ETL processes, and upstream source systems Target architecture (TO BE) & migration strategy - Work with global CTO to define the target structure on SCIB Data Lake Align design with the Bank data governance standards -Define migration roadmap, rollback plan, phases, and timelin Requirements+7 years of experience with DataExperience as a Data ArchitectAdvaced SQLData base migrationStrong architecture + hands-on backend development profileBackend focus — no frontend-only profileCTE, query tuning, indexing, execution plansEnglish fully fluent requiredWhat we offer:100% Remote opportunityPayment in USDModality of contract: ContractorOriginally posted on Himalayas