Senior PostgreSQL Migration consultant

About the Position

We're seeking a Senior PostgreSQL Migration consultant with 6+ years of experience to join our financial institution in Bengaluru, India for a migration project.

Responsibilities

• Work on FRTB implementation solution design together with the wider team and Murex.
• Set up and run market risk-related processes involving Datamart and CTRL-M. This includes setting up: Datamart extractions, EOD processing in CTRL-M.
• Performance-tuning PostgreSQL post-migration: diagnose query plan regressions using EXPLAIN, tune vacuum/autovacuum, configure WAL and shared buffers.
• Rewriting query logic from PL/SQL to PL/pgSQL, database objects and Murex nested database logic.

Requirements

• 6+ years of experience in a similar role
• Must have hands-on experience in PostgreSQL Migration
• Oracle to PostgreSQL Migration hands-on experience
• Good experience with EOD/CTRL-M or Autosys scheduling
• Advanced SQL - Performance tuning and query rewrites
• Deep understanding of the PostgreSQL engine - query planner, optimizer behavior, vacuum mechanics
• Hands-on experience with AWS: RDS PostgreSQL, IAM, S3, Route53
• Advanced financial market understanding covering different asset classes, especially IRD and rates
• Unix/Linux proficiency: shell scripting, process management

Nice to Have

• MxML Experience
• Datamart Experience
• DevOps on Murex experience (GIT, Jenkins, JIRA, etc.)
• Technical solution design experience and start-to-end solution ownership
• Experience with FXCash, FX Derivatives, Commodities
• Knowledge of PostgreSQL ecosystem tools: pg_stat_statements, pgstattuple, pg_repack

We Offer

• FULL_TIME employment
• Senior experience level
• English: B2 Upper Intermediate proficiency

About the Company

Join our team in Bengaluru, India, and be part of a migration project for a large European financial institution. Work with an established client team and be fully involved from project initiation through implementation.

Apply Now

If you meet the requirements and are excited about this opportunity, apply now!