Oracle Database Administrator

Permanent contract|Montreal|Information Technology

Oracle Database Administrator

Montreal, Canada Permanent contract Information Technology

Responsibilities

 

Societe Generale is one of the leading European financial services groups. Based on a diversified and integrated banking model, the Group combines financial strength and proven expertise in innovation with a strategy of sustainable growth, aiming to be the trusted partner for its clients, committed to the positive transformations of society and the economy.


Active in the real economy for over 150 years, with a solid position in Europe and connected to the rest of the world, Societe Generale has over 147,000 members of staff in 67 countries and supports on a daily basis 32 million individual clients, businesses and institutional investors around the world by offering a wide range of advisory services and tailored financial solutions.

Societe Generale opened its Canadian headquarters in Montreal in 1974 to offer its financial services to corporations, financial institutions and governments. The Toronto and Calgary offices were opened in 1978 and 2006 respectively.

We now employ over four hundred people, both in the traditional banking sector (investment banking, funds and trading activities) and in the field of information technology, with the opening of our SG Montreal Solutions Centre subsidiary which, thanks to its geographical location and its cultural diversity, provides computer support and development for the New York and Paris teams.

Societe Generale in the US values and remains committed to providing a diverse and inclusive work environment. Our mission is to recruit, develop, retain and advance a diverse workforce that is united in our efforts to enhance our competitive position and deliver innovative solutions to our clients.

 

 

Department Summary:

Global Technical Services (GTS) is the infrastructure organization supporting all entities in the Americas for all infrastructure technology requirements including:

  • Workstations including computers, telephones and email
  • Data centers hosting
  • Networks/telecommunications
  • End user computing services
  • Market Data administration infrastructure
  • Data services

GTS various fields of expertize enable the organization to:

  • Work as part of the team responsible for the Group's Digital Transition,
  • Ensure the 24/7 quality and continuity of our infrastructures and their resilience to incidents,
  • Advise/accompany business lines and functional divisions through their own transformation,
  • Provide diversified/innovative service offer that is customized to the requirements of our internal/external partners

Our goal is to deliver quality/cost-effective IT infrastructure services aligned to our customer needs while effectively managing operational risks and providing value added/innovative solutions.

 

Day-to-Day Responsibilities:

 

  • Installation, configuration, management and maintenance of databases
  • Responsible for database health, resiliency, performance tuning and optimization, operational control procedures, support and inventory.
  • Work closely with developers and application production support to provide technical help
  • Participate in On-call, handle alerts and escalations during business hours and off-hours, including weekends and Holidays on rotational basis.
  • Setup and maintain Database backup and recovery procedures
  • Provide technical documentation.
  • Support and implement database changes, ensure quality of the changes.
  • Perform capacity planning for the databases
  • Implement and help other team members with group/team strategy
  • Participate in Feature teams to build tools and develop APIs to automate daily tasks
  • Adopt the DevOps way of working to provide support for the automation
  • Participate in Agile ceremonies to promote teamwork

 

 

Profile required

Technical Skills:         

 

Oracle:

 

  • Oracle 11g, 12C, 19C
  • RAC, ASM, DataGuard, RMAN, Oracle Enterprise Manager
  • Linux Operating system
  • Windows server operating systems basics
  • EMC-SAN technologies.  

 

Development :

 

  • Advanced Python Knowledge
  • Unix shell scripting
  • Knowledge in Agile Methodology

 

Desired / Plus:

 

  • Oracle EXADATA management
  • Golden Gate
  • Knowledge in other RDBMS (PostgreSQL, MSSQL, Sybase, Cassandra)
  • UC4/Autosys scheduling tool

 

Competencies:

 

  • Experience working in a large, 24x7, Investment Bank.
  • Must be organized, detail-oriented, self-motivated, disciplined, professional, and a team player to multiple tasks at one time, in a fast paced environment handling multiple demands
  • Excellent written and verbal communications skills, ability to present and explain technical information
  • Database management experience, including installation, maintenance and migration/upgrades and database refreshes.
  • Database architectural knowledge

 

Experience Needed:

 

  • 4+ years hands-on experience On Oracle (12c, 11g, 10g) databases on Sun Unix or Linux
  • PL/SQL development experience, using Oracle Packages, Stored Procedure, and Functions
  • Experience handling large databases
  • Experience with the Oracle Optimizer plans and hints.
  • Experience with optimizing physical data models (table definition, indexes, range and hash partitioning)
  • Experience with building automation tools or APIs using Python
  • Experience with shell scripting and Linux scripts development

 

Educational Requirements:

 

  • Bachelor's Degree in Computer Science or equivalent work experience

 

Desired / Plus:

 

  • Certification in Database adminstration

 

Languages: English, French

Why join us

A career within the Societe Generale Group is an opportunity to participate in a team effort to build the bank of tomorrow.

Together, let's be the future:

  • Commitment to putting integrity at the heart of our businesses
  • Commitment to Diversity and Inclusion
  • Climate commitment
  • Citizen engagement

 

You're not convinced yet? Meet our employees.

Are you interested in knowing more? Click here to find out.

Business insight

Societe Generale opened its Canadian headquarters in Montreal in 1974 to offer its financial services to corporations, financial institutions and governments. The Toronto and Calgary offices were opened in 1978 and 2006 respectively.


We now employ over four hundred people, both in the traditional banking sector (investment banking, funds and trading activities) and in the field of information technology, with the opening of our SG Montreal Solutions Centre subsidiary which, thanks to its geographical location and its cultural diversity, provides computer support and development for the New York and Paris teams.
 
Get on board and get involved! We are here to support you !

We are an equal opportunities employer and we are proud to make diversity a strength for our company. Societe Generale is committed to recognizing and promoting all talents, regardless of their beliefs, age, disability, parental status, ethnic origin, nationality, sexual or gender identity, sexual orientation, membership of a political, religious, trade union or minority organisation, or any other characteristic that could be subject to discrimination.

Reference: 210003HT
Entity: SG CIB
Starting date: immediate
Publication date: 2021/03/03
Share