Oracle PL/SQL Developer

ABOUT THE JOB:

The aim of Global Banking Technology & Operations (GBTO) Canada is to deliver day-to-day services to Société Générale 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 RIS Dev chapter and fulfill the following responsibilities:

• Participate risk portfolio related projects
• Enhance and maintain RIS platform and RIS applications
• Provide L2-L3 Production support

We heavily rely on Agile framework (Scrum):

• To build a solid and trustful relationship with our functional partners thanks to a continuous and transparent communication.
• To maintain a strong team dynamic that focuses on the delivery of value for the users and maintaining the application with a long-term view.

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
  • Monitor and maintain RIS platform infrastructure
• DevOps
  • CI/CD Pipeline: Follow RIS CI/CD pipeline for development and change release
  • Standardize Sonarqube use: Ensure sonar plugin and resolve identified issue

TECHNICAL Stack

Oracle v.19 | PL/SQL | UNIX/LINUX | PostgreSQL | GITHub |LIQUBASE | JENKINS | Microsoft Azure | Kubernetes | Docker |

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 RIS platform, transform legacy systems, and contribute to software craftsmanship and Agile framework implementation.

Skills and Qualifications:

Must Have:

• Bachelor’s degree in computer science or information management
• 5+ years of experience in developing and maintaining large Oracle database with writing complex PL/SQL queries, views, stored procedures, functions and packages
• Working experience and skills on database performance tuning, experience in building a CI & CD pipeline
• Good knowledge and experience with file transmission and network (SFTP, DNS, TCP/IP)
• Independent strategic and analytical thinking skills with an ability to solve problems and make decisions

Nice to Have:

• 2-3 years’ experience in cloud computing and Microsoft Azure cloud platform
• Extensive knowledge of software development life cycle and accepted practices
• Experience with API design in Python or Java in UNIX or Linux OS
• Experience in Agile development working environment
• Excellent communication and presentation skills

Languages: English

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.

OUR BENEFITS:

WHAT WE DO DIFFERENTLY AT SOCIÉTÉ GÉNÉRALE

Competitive compensation & benefits offering, including but not limited to:

• Minimum of 20 Vacation days + 4 personal days 
  • Supportive Maternity, paternity, parental and adoption leave policy 
  • Health spending ($2,000/year) and personal spending ($1,000/year) accounts with 75+ eligible reimbursement categories (health, training, electronics etc.)
  • Fully sponsored virtual healthcare assistance and Employee Assistance Program to you and your immediate family
• Various Employee Resource Groups (ERG) to engage with such as Pride and Allies, American Women Network, Black Leadership Network, One planet, etc. 
• A culture of continuous development by encouraging our employees various training programs (online training and coaching platform such as Coursera, GoFluent, Pluralsight, First Finance, and others)

Societe Generale is committed to offering an inclusive recruitment experience to all candidates. If you require any reasonable accommodations during the recruitment process, please do not hesitate to let our Recruiters know.

OUR CULTURE: 
At Societe Generale, we live by our 4 core values of commitment, responsibility, team spirit and innovation. We are engaged and demonstrate consideration for others. We act ethically and with courage. We focus our talent and energy on collective success. We experiment and propose new ideas. This way, we maximize our ability to serve client needs and anticipate market changes. Societe Generale is committed to strengthening bonds with colleagues, communities, and the world in which we live, because relationships are at the heart of how we operate. For more information about our Culture and Conduct initiatives, please visit this link (https://americas.societegenerale.com/en/careers/get-know-culture/)

D&I: 
Our Diversity & Inclusion Mission: Recruit, develop, advance, and retain a diverse workforce that is united in our efforts to enhance our competitive position and deliver innovative solutions to our clients.
Our Diversity & Inclusion Vision:

• Engaged workforce that is demographically diverse in a way that reflects the communities in which we operate
• Inclusive culture and workplace that recognizes employees' unique needs and utilizes their diverse talents
• Engage our community and marketplace, and position the organization to meet the needs of all its clients

For more information about our D&I initiatives, please visit this link (https://americas.societegenerale.com/en/societe-generale-about/diversity-and-inclusion/)

HYBRID WORK ENVIRONMENT:
Societe Generale offers a hybrid work arrangement that offers employees the flexibility to work remotely, as well as on-site, in order to promote interaction and collaboration with colleagues while adhering to all SG standard protocols.  Hybrid work arrangements vary based on business area.  The applicable business lines will determine and communicate the work arrangements that best meet their business needs.