Job Description

This role is hybrid and requires you to be at our downtown Toronto office (250 Yonge Street) and/or Client office at a minimum 2 days per week - subject to change at any time.

We are Canada's largest independent information technology services firm, and after 40 years, we're still growing! We have a challenging career opportunity for a Sr. SQL PLSQL Developer to work for our clients across our Banking and Wealth 360 Digital Wealth Product.

Your future duties and responsibilities

. Database Development: Develop, optimize, and maintain Oracle SQL and PL/SQL code, including stored procedures, functions, and packages. Translates business needs into long-term data architecture solutions.

. Migration: Experience in Migration of data as part of product upgrades & across Applications. Experience onboarding new clients from a data migration perspective.

. Performance Tuning: Identify and resolve performance bottlenecks, optimize query performance, and implement best practices for database tuning.

. Complex Problem Solving: Analyze, troubleshoot, and resolve complex database issues, ensuring minimal downtime and optimal performance.

. Data Modeling: Design and refactor data models to support business requirements and improve system efficiency.

. Documentation: Create and maintain detailed documentation for database structures, processes, and best practices. Analyze and document existing PL/SQL code

. Mentorship: Guide and mentor junior developers, providing technical leadership and support in analyzing complex problems and refactoring data models.

. Collaboration: Work closely with cross-functional teams, including developers, analysts, and project managers, to ensure seamless integration and efficient operation of database systems.

. Optimization : Evaluates reusability of current data for separate analyses. Conducts data sheering to rid the system of old, unused or duplicate data. Reviews object and data models and the metadata repository to structure the data for better management and quicker access.

Required qualifications to be successful in this role

. Bachelors of Science in Computer Science or similar discipline

. Strong Data Analysis skills

. 8-10 years' experience in Oracle 12c/19c

. 8-10 years' experience with Oracle database, SQL and PL/SQL programming.

. Expert in SQL performance tuning.

. Expert in Data migration techniques; Migration of data for product upgrades & across Applications

. Experience in onboarding of new clients from a data migration perspective

. Strong data modeling skills, including designing and refactoring data models.

. Experience in rewriting and optimizing complex stored procedures.

. Strong analytical and problem-solving skills, with the ability to handle complex database issues.

. Strong troubleshooting skills

. Excellent verbal and written communication shills

. Ability to work in a fast-paced environment

. High attention to detail and a commitment to delivering high-quality work.



Other Requirements:



. Knowledgeable in the Wealth Management domain, with experience in Wealth 360 Digitial Wealth Platform preferred

. Knowledge of Postgres - 3 to 4 years of experience preferred

. Demonstrated ability to learn new technologies, applications, and systems

. Strong verbal and written communication skills

. Strong organizational and leadership skills with the ability to facilitate technical sessions

. Can communicate in both technical and business terms

. Ability to lead multiple projects simultaneously

. Ability to manage geographically distributed development teams

. Knowledge of Oracle Performance Tuning is an asset

. Working experience in Toad / SQL Developer / Oracle DataModeler / Erwin

. Exposure to containers like liquibase

. Ability to extract matrix/progress/milestones from JIRA or other collaboration tools for stakeholders.

. Familiarity with Oracle development tools and performance tuning utilities.

. Oracle Certified Professional (OCP) or equivalent certifications is an asset

#LI-GS!

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