Database Administrator – SQL Server & Oracle (Senior)

Position Description :

At CGI we are passionate about technology and innovation. We are looking to strengthen our team with a talented and motivated Senior Programmer Analyst to participate in challenging projects and contribute to our collective success.

Being an Associate at CGI will not only allow you to broaden your expertise across multiple technologies but will also give you the opportunity to advise our major clients on the technologies and methodologies best suited to their needs.

Our team is dynamic and encourages collaboration discussion and initiative. Respect and fun are the foundation of our work environment.

CGI places a special emphasis on each of us offering a personalized training program highly competitive financial benefits and flexible schedules that allow us to balance our personal and professional lives

Our team is the infrastructure organization supporting all entities in the Americas for all infrastructure technology requirements including workstations including computers telephones and email Data centers hosting networks / telecommunications end user computing services market Data administration infrastructure and data services

Our goal is to deliver quality cost-effective IT infrastructure services aligned to customer needs while effectively managing operational risks and providing value-added innovative solutions.

Your future duties and responsibilities :

Experience working in a large 7x24 Investment Bank

Must be organized detail-oriented self-motivated disciplined professional and a team player able to handle multiple tasks in a fast-paced environment

Excellent written and verbal communication skills ability to present and explain technical information

Database management experience including installation maintenance migration / upgrades and database refreshes

Database architectural knowledge

Required qualifications to be successful in this role :

Experience Needed

6 years hands-on experience on MSSQL (2016-2022)

2 years hands-on experience on Postgres

3 years hands-on experience on Oracle (19c 12c) databases on Unix / Linux

1 years of development experience

Good knowledge of languages English French required

Experience handling large databases

Experience with the Oracle Optimizer plans and hints

Experience with MSSQL performance tuning

Experience with building automation tools or APIs using Python

Experience with shell scripting and Linux script development

Educational Requirements

Bachelors degree in computer science or equivalent work experience

Desired / Plus :

Certification in Database administration

Technical Skills

SQL Server / Oracle :

MSSQL Cluster AlwaysOn

Postgres Oracle 19C

RAC ASM DataGuard RMAN Oracle Enterprise Manager

Unix shell scripting Linux Operating system

Windows server operating system / cluster

EMC-SAN technologies

Experience in Agile Methodology

Development : PowerShell knowledge

Python knowledge

Unix shell scripting

Knowledge in Agile Methodology

Desired / Plus : MSSQL in Azure Oracle management GoldenGate

Experience in other RDBMS (Cassandra MongoDB )

• Ability to communicate effectively in English both orally and in writing is required as this role involves regular collaboration with colleagues and partners in North America.

Localisation : Montreal

Work mode : on site

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 $70000$135000. This role is an existing vacancy / a future opportunity.

#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 : English

French

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 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 teamone of the largest IT and business consulting services firms in the world.

Required Experience :

Unclear Seniority

Key Skills

Anti Money Laundering,Baan,Bootstrap,Internet Marketing,IT Project Management,Analysis

Employment Type : Full-Time

Experience : years

Vacancy : 1

Monthly Salary Salary : 70000 - 135000