Sql Jobs in Quebec (NOW HIRING)

The aim of Global Banking Technology & Operations (GBTO) Canada is to deliver day-to-day services to Societe Generale investment and corporate bank units and their clients to accelerate their transformation. GBTO differentiates itself from competitors with the pace of the agile transformation delivered, spreading the technology and data culture, shortening the decision-making process, and adopting a true industrial approach, leveraging on different teams either transversal or aligned to the different sub business units.

The Risk Information System (RIS) team belongs to the XRM (Cross Risk Metrics) department that aims at providing global agency risk management tools, calculating risk values, and generating variety of risk portfolio basis reports for risk management and client service departments. RIS team has RISKFEEDS, IRIS-PORTAL, IMAGINE and PRELUD 4 applications. You will join RIS Risk Integration feature team and take the following responsibilities:

• Participate risk portfolio related projects

• Enhance and maintain RIS platform and RIS applications

• Provide L2-L3 Production support

Autonomous on your developments, you will always have the support of the team to continuously improve functionally and technically. You will be encouraged to also share your point of view and approaches in software craftmanship. Continuous improvement is key for us!

YOUR MISSION

• Functional improvement: Participate and contribute to RIS projects and Ad-Hoc requests

• Technical improvements

  • Contribute to Azure migration

  • Tune RIS databases and applications performance

  • Involve risk models Python transformation

  • Design workflow for SQL extract excel/cvs based reporting 

• DevOps

  • CI/CD Pipeline: Follow RIS CI/CD pipeline for development and change release

  • Standardize Sonarqube use: Ensure sonar plugin and resolve identified issue

  • L2/L3 Support for RIS platform infrastructure

TECHNICAL Stack

• Software Craftsmanship best practices: DDD, BDD, TDD, Design Patterns, Clean code

• Language: Java 8 or above, PL/SQL

  • Multithreading, concurrent programming

• Framework: Spring Boot, Spring Framework core features

• Database: Oracle v19 or above, Postgres. 

• Build Tool: Maven

• Testing: JUnit 5,

• API Documentation: Springdoc OpenAPI (Swagger UI)

• DevOps: Github Actions, Jenkins, Linux

• Network: DNS, TCP/IP

Nice to have:

• Kafka (Event Hub)

• Security: Spring Security with JWT or OAuth2

• Tests: Mockito for unit and integration tests

• Big Data: Spark, Azure Data lake, Sok8s

• Monitoring: Elastic, ITRS

• Cloud: Azure, Docker, Kubernetes

• Angular

What will be your DAY-TO-DAY?

How you will contribute to the day-to-day activities of the team:

• Interact with stakeholders to decompose customer requests into detailed stories and develop code using Software Craftsmanship best practices across diverse technology ecosystems.

• Deliver working code meeting acceptance criteria and the definition of done, while ensuring product quality and consistency through testing, deployment, and production activities.

• Document technical design and specifications, maintain test cases, and support inquiries, issues, and major events to identify root cause and resolution.

• Manage release processes, including drafting release notes, developing release scripts, and leading deployments with contingency and rollback plans.

• Maintain C/c team specific modules, transform legacy systems, and contribute to software craftsmanship and Agile framework implementation.

SKILLS AND QUALIFICATIONS:
Must Have: 

1. Ability to Code, test, document and L3 support the application (MPT)
2. Cloud skills (security, infrastructure, architecture design, design patterns...)
3. Experience with Spring Boot for building RESTful APIs and microservices.
4. Agile methodology (scrum)
5. Bachelor's degree in computer science or equivalent.

Nice to Have:

• Banking knowledge
• 2 years of experience with Spark 4.0
• 2 Python development
• Extensive knowledge of SDLC
• Understanding of financial services industry and associated products
• Strong organizational and communication skills.
• Strategic and analytical thinking skills with an ability to solve problems and make decisions.
   

LANGUAGE: 

Ability to communicate in English, both orally and in writing, is a requirement as the person in this position will need to collaborate regularly with colleagues and partners in the United States.