Position Description:

• Secret clearance required (must reside in Canada 7-10+ years to be eligible)
• Hybrid - Ottawa or Calgary office.
• Work must be done in EST time.

Your future duties and responsibilities:

The Consultant will be responsible for providing the following Services to the Bank:

Under the direction of the Assistant Director of Database and Storage Services:

• Install, configure and maintain all supported database software (Oracle Database and Microsoft SQL Server) in Azure cloud-based High Availability environments.
• Carry out database performance tuning and analysis.
• Implement and review backup and recovery strategy to ensure that business service-level agreements are met.
• Conduct database security administration to ensure that data is only available to authorized users.
• Ensure data consistency by adhering to data model standards and best practices.
• Maintain schema objects and perform production migrations.
• Resolve database related technical issues.
• Analyze and monitor system performance to identify major performance bottlenecks in the system and identify the impact of administration tasks on core business scenarios.
• Participate in the resolution of complex database issues by applying advanced level knowledge.
• Provide operational support to database administrators.
• Other related activities and deliverables, as required

Required qualifications to be successful in this role:

The Consultant should have the following qualifications and skills:

A minimum of five (5) years demonstrated experience with Database Administration (as a DBA or similar role) with experience in the following:

• MS Azure SQL and Azure SQL Managed Instance (MI) database and Oracle Exadata database deployed in Azure cloud environments
• Oracle 19c and SQL Server 2019 or higher
• Cloud SQL PaaS Services, specifically Azure
• Oracle Cloud, specifically Oracle Exadata Database Service
• PostgreSQL on Azure
• Oracle Exadata, Data Guard, RAC
• Database Recovery Manager (RMAN) with backup/restore and point in time recovery.
• Data Pump tool for database/data migration
• Concept of Oracle Advanced Security Transparent Data Encryption (TDE)



Additional Qualifications
The following will also be considered:

• Demonstrated ability to organize effectively
• Demonstrated experience with Oracle Autonomous Database
• Demonstrated knowledge of Commvault
• Demonstrated knowledge of Dynatrace
• Any relevant designations/certifications (OCP, Azure, etc.) including:
• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified: Azure Administrator Associate
• Oracle cloud certifications


CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $60000–$110000. This role is an existing vacancy.

#LI-RD12

Skills: Data MigrationDatabase AdministrationEnglishPostgre SQLFrench What you can expect from us:

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll 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. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll 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.

You’ll shape your career by joining a company built to grow and last. You’ll 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 value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.

To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our team—one of the largest IT and business consulting services firms in the world.