We strive to provide reliable IT services by providing offers, services levels and optimized costs that meet the needs of their internal clients; such as hosting business applications, workstations, collaborative services, network and telephony.
The Databases Administration Department (DBA) provide hosting services and expertise to all main databases technologies (Oracle, MSSQL, Sybase, PostGre, Bigdata …). The DBA team in Canada works to maintain a great level of services on highly critical environnements in AMER,Europe and Asia, and accompagny business partners on their needs.
In that context, we are looking for an Oracle Database Administrator with DevOps skills to integrate in to our team to provide support of our existing infrastructure, assist our clients in their database related projects and partipcate in building automation tools and APIs.

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 trasformation,
• 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.

Technical Skills:

• Oracle / SQL Server:
• Oracle 12C, 19C
• RAC, ASM, DataGuard, RMAN, Oracle Enterprise Manager
• MSSQL 2016 – 2022, Cluster, AlwaysOn
• Unix shell scripting
• Linux Operating system
• Windows server operating systems basics
• EMC-SAN technologies

Experience Needed:

• 8+ years hands-on experience On Oracle (19c, 12c) databases on Unix/Linux
• 2+ years of development experience
• Experience handling large databases
• Experience with the Oracle Optimizer plans and hints.
• Experience with building automation tools or APIs using Python
• Experience with shell scripting and Linux scripts developmen

Educational Requirements:

• Bachelor’s degree in computer science or equivalent work experienc

YOUR FUTURE DUTIES AND RESPONSIBILITIES

What will be your DAY-TO-DAY?

• Installation, configuration, management and maintenance of database
• 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

REQUIRED QUALIFICATIONS TO BE SUCCESSFUL IN THIS ROLE

Technical Skills:

• Oracle / SQL Server:
• Oracle 12C, 19C
• RAC, ASM, DataGuard, RMAN, Oracle Enterprise Manager
• MSSQL 2016 – 2022, Cluster, AlwaysOn
• Unix shell scripting
• Linux Operating system
• Windows server operating systems basics
• EMC-SAN technologies.

Development:

• Python Knowledge
• PowerShell knowledge
• Unix shell scripting
• Knowledge in Agile Methodology

Desired / Plus:

• Oracle Exa@CC management
• Golden Gate
• Knowledge in other RDBMS PostgreSQL, Cassandra, Sybase)
• UC4/Autosys scheduling tool

Competencies:

• Experience working in a large, 7x24, 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:

• 8+ years hands-on experience On Oracle (19c, 12c) databases on Unix/Linux
• 2+ years of development experience
• Experience handling large databases
• Experience with the Oracle Optimizer plans and hints.
• 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 administration
• LANGUAGE: French and 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.

LI-AR1