Description
Position Description:
This role is hybrid and requires you to be in our downtown Toronto 2-3 times per week – subject to change at any time.
Your future duties and responsibilities:
• Seeking a talented Senior Oracle DBA. The ideal candidate must have 7+ years of Oracle DBA and some PL/SQL experience along with good communication, teamwork, and interpersonal skills.
• Responsible for ensuring maximum up-time with maximum throughput to meet established service-level agreements (SLAs), ensuring backup integrity, and providing support to development and application support groups as needed.
• Installation, upgrades, daily support, performance tuning (Oracle 12c, 19C), rman backup/recovery/duplication, monitoring primary+standby databases
• Monitor database and server performance and identify current and future potential bottle-necks
• You will assist in the development of processes, procedures, and jobs to monitor and/or automate tasks required to maintain databases. Your duties will also include gathering and communicating database performance metrics for internal and external audiences.
• Minimum of 7 years of work experience as a DBA in a team setting, providing 24/7 support to mission-critical applications and databases
-Korn shell scripting essential (for DBA-related monitoring)
• Experience supporting Oracle, Postgress and Mongo DB in a production environment
• Experience/ Working Knowledge of Oracle Exadata and Exadata Resource Management (IORM)
• Experience/Working Knowledge about Oracle Encryption Offerings ( at Rest, in Transit, Vault Server)
• Extensive performance Tuning using OEM/AWR/ADDM/ASHRPT
• Backup and recovery and RMAN (Must Have)
• Oracle ASM, Grid Infrastructure, RAC (preferred skills)
• Upgrades and Patches
• Oracle Enterprise Manager Grid Control (OEM 13c)
• Strong familiarity with Unix/Linux command line interface
• Significant experience with shell scripting on Unix/Linux
• Tune database code (packages, procedures, functions, triggers, etc) for the application as required
• Provide support to the customers/developers to resolve their technical problems with the data and/or database
Good to Have –
• Knowledge of 18c,19c & Oracle Cloud
• Familiarity with ZFS
#LI-GS
Required qualifications to be successful in this role:
• Bachelor’s degree in Computer Science, Information Technology, or closely related
• Oracle certified Professional Oracle 10 or 11 OCP (preferred)
• Extensive experience in database administration, and performance tuning for the following products: Oracle, Postgress, MongoDB
• Oracle certified Professional Oracle 10 or 11 OCP (preferred)
Soft Skills:
• Good communication, teamwork, and interpersonal skills.
• Able to professionally represent the DBA activities of our product within our organization.
• Capable of formulating policies and procedures for DBA activities.
• Continuously look to improve data management processes.
• Work with minimal supervision.
Other Requirements (e.g. travel, shift work, on-call duty, overtime):
Evening and weekend work is occasionally needed to support the client environments.
Skills:
- Database Administration
- Linux
- Oracle Exadata
- Unix
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.
