Project description
We've been engaged by a large European financial institution to provide resources for their migration project.
By joining this program, you will have the opportunity to work with an established client team and be fully involved from project initiation through implementation, not only for the PostgreSQL but also for upstream systems, including the managed market data service provider.
Responsibilities
- You will be a techno-functional Murex developer focusing on
- Working 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.
- The bank has an advanced Murex implementation leveraging Murex CI/CD setup to fully automate releases and version control.
- 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.
Mandatory skills
- 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 skills
- 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
