Database Administrator (HABS-Next-Gen)

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 Migration

Database Administration

English

Postgre SQL

• 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

Databases,Disaster Recovery,SQL,High Availability,Microsoft SQL Server,ssrs,Database Design,Performance Tuning,SSIS,Database Administration,Sybase,Oracle

Employment Type : Full-Time

Experience : years

Vacancy : 1

Monthly Salary Salary : 60000 - 110000