CGI is a global business and technology service provider with $11.5B in revenues. CGI is on a mission to help financial services organizations focus on servicing their clients. CGI supports 15 of the top 20 banks worldwide and our top 10 banking clients have worked with us for 26 years on average. Our clients have seen the value and commitment we bring through our products. This is why nearly $1.6 trillion in assets managed through CGI’s portfolio management, investment fund and asset management solutions.
This role is hybrid and requires you to be in our downtown Toronto office 2-3 times per week - subject to change at any time.

Soft Skills:

• Good communication, teamwork, and interpersonal skills.
• Able to professionally represent the DBA activities of our product within our organization.
• Capable of formulating policies and procedures for DBA activities.
• Continuously look to improve data management processes.
• Work with minimal supervision

YOUR FUTURE DUTIES AND RESPONSIBILITIES

• Seeking a talented Senior Oracle DBA. The ideal candidate must have 7+ years of Oracle DBA and some PL/SQL experience along with good communication, teamwork, and interpersonal skills.
• Responsible for ensuring maximum up-time with maximum throughput to meet established service-level agreements (SLAs), ensuring backup integrity, and providing support to development and application support groups as needed.
• Installation, upgrades, daily support, performance tuning (Oracle 12c, 19C), rman backup/recovery/duplication, monitoring primary+standby databases
• Monitor database and server performance and identify current and future potential bottle-necks
• You will assist in the development of processes, procedures, and jobs to monitor and/or automate tasks required to maintain databases. Your duties will also include gathering and communicating database performance metrics for internal and external audiences.

REQUIRED QUALIFICATIONS TO BE SUCCESSFUL IN THIS ROLE

• Bachelor’s degree in computer science, Information Technology, or closely related minimum seven years related experience in the following areas
• Minimum of 7 years of work experience as a DBA in a team setting, providing 24/7 support to mission-critical applications and databases ,Korn shell scripting essential (for DBA-related monitoring)
• Experience supporting Oracle, Postgress and Mongo DB in a production environment
• Experience/ Working Knowledge of Oracle Exadata and Exadata Resource Management (IORM)
• Experience/Working Knowledge about Oracle Encryption Offerings ( at Rest, in Transit, Vault Server)
• Extensive performance Tuning using OEM/AWR/ADDM/ASHRPT
• Backup and recovery and RMAN (Must Have)
• Oracle ASM, Grid Infrastructure, RAC (preferred skills)
• Upgrades and Patches
• Oracle Enterprise Manager Grid Control (OEM 13c)
• Strong familiarity with Unix/Linux command line interface
• Significant experience with shell scripting on Unix/Linux
• Tune database code (packages, procedures, functions, triggers, etc) for the application as required
• Provide support to the customers/developers to resolve their technical problems with the data and/or database
• Extensive experience in database administration, and performance tuning for the following products: Oracle, Postgress, MongoDB
• Oracle certified Professional Oracle 10 or 11 OCP (preferred)

Soft Skills:

• Good communication, teamwork, and interpersonal skills.
• Able to professionally represent the DBA activities of our product within our organization.
• Capable of formulating policies and procedures for DBA activities.
• Continuously look to improve data management processes.
• Work with minimal supervision.

Other Requirements (e.g. travel, shift work, on-call duty, overtime):
Evening and weekend work is occasionally needed to support the client environments.

Good to Have –

• Knowledge of 18c,19c & Oracle Cloud
• Familiarity with ZFS

LI-AV1