Senior Oracle DBA

Position Description:

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 CGIs 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.

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 primarystandby 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:

Bachelors 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 18c19c & Oracle Cloud
Familiarity with ZFS

#LI-AV1

Skills:

• Capacity Management
• Database Administration
• Infrastructure architecture
• Linux
• Oracle Exadata
• Postgre SQL
• Systems Engineering
• Unix

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI we recognize the richness that diversity brings. We strive to create a work culture where all belong and collaborate with clients in building more inclusive communities. As an equal-opportunity employer we want to empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process please let us know. We will be happy to assist.

Come join our teamone of the largest IT and business consulting services firms in the world.