Senior PostgreSQL Engineer

Our client: Montrose Software has an ongoing relationship with one of the largest North American banks to enhance and maintain its production libraries and applications. The bank serves 17 million clients worldwide and provides personal and commercial banking, wealth management, insurance, investor services, and capital markets products and services globally. We work mainly with their capital markets teams, focusing on derivatives and fixed income systems.

Project description: The bank made a strategic decision to migrate the rates trading platform from a legacy system to Murex. As the new system passes data in a new format, our team is to implement and enhance the system capabilities to transform between Murex format and FpML, as well as create a new bridge that will allow booking of trades in FpML form into Murex. The system supports a wide variety of financial products, starting from simple FRAs and Swaptions to complex products. As part of this project will be migrating DataServices and related trade store functionality from the current .NET/SQL Server/windows stack to a new Java-based architecture running on Linux  which uses PostgreSQL as storage.

Industry: Finance

Location: Kraków / Hybrid/ Remote from Poland

Your daily work will include:

• Designing new trade-specific tables and data models, fine-tuning PostgreSQL models, 

• Develop services based on existing .NET solution into reactive Java using Spring Boot,

• Configuring and working with database cluster and others like docker, kubernetes.

Team & Collaboration

• 3 developers and 2 managers

• Regular meetings:

  • Daily Stand-Up in afternoon hours.

• Communication via email and Webex chat

• Working hours: usually 9:00–17:00 CET 

Qualifications:

• 5+ years of experience in database technologies, including 2+ years with PostgreSQL

• Extensive experience with database schema modeling, bi-temporal models experience would be a big plus

• Extensive experience with performance optimization, including indexing, partitioning, distributed setup, data maintenance

• Experience in Java 17+ with Spring, Spring-Boot, would be a big plus.      

• Experience with version control systems like GitHub

• Experience with CD/CI pipeline tools like Jenkins, Maven, Ansible, GitHub Actions, etc.

Nice to have:

•       Experience with .NET / C#

•       Experience with XML and XSLT transformations

•       Experience with Java reactive programming

•       Experience in the Capital Markets domain