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.
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
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
Bilingualism (French and English) is required for this position due to the nature of the role requiring interaction with national and global clients.
Skills: Oracle GoldenGateOracle GoldenGateOracle SQL ServerPowerShellPowerShellPythonUnix 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 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 team—one of the largest IT and business consulting services firms in the world.