Oracle DBA

Category: Software Development/ Engineering
Main location: Canada, Nova Scotia, Halifax
Position ID: J0622-1312
Employment Type: Full Time

Position Description:

- Create, review, execute Database script as per the request in production and non- production environments.
- Database monitoring and enhance database alerting
- Troubleshoot any database related issues in production and non-production environments.
- Support client application development and releases
- Support database automations activities
- Understand and analyze instance performance, investigate performance issues, wait events, able to read and understand AWRs

Skills required
 Minimum 3-5 years experience in a similar role.
 Strong experience with performance tuning of Oracle databases, highly available transactional systems, data replication, and database clusters.
 Strong SQL and PL/SQL experience, understand and be able to write complex SQL queries, able to improve performance of queries
 Unix/Linux experience and good knowledge of Shell scripting.
 Knowledge of highly available, distributed, multi-master databases.
 Solid knowledge end experience using Oracle replication (Golden Gate)/Oracle RAC implementations.
 Strong knowledge of different types of Oracle database objects including indexes, partitioning, materialized views, keys etc.
 Security: auditing, role separation
 Proficient in data structures, indexes, partitioning concepts, LOBS, compression
 Familiarity with Oracle Exadata is an asset
 Understand oracle infrastructure, RAC, dataguard, backup and recovery, HA concepts, Exadata knowledge is nice to have
 Goldengate and other databases proficiency is a good addition, but not a must

Your future duties and responsibilities:



  • Database Administration
  • Oracle
  • Performance Tuning
  • Shell Script

What you can expect from us:

Insights you can act on

While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success.

When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our employees "members" because they are CGI shareholders and owners and owners who enjoy working and growing together to build a company we are proud of. This has been our Dream since 1976, and it has brought us to where we are today — one of the world’s largest independent providers of IT and business consulting services.

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.

Ready to become part of our success story? Join CGI — where your ideas and actions make a difference.