Sr SQL PLSQL Developer
Sr SQL PLSQL Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Position Description:
This role is hybrid and requires you to be at our downtown Toronto office 250 Yonge Street) and/or Client office.
We are Canadas largest independent information technology services firm and after 40 years were 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 longterm data architecture solutions.
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 crossfunctional 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
10 years experience in Oracle 12c/19c
10 years experience with Oracle database SQL and PL/SQL programming.
Expert in SQL performance tuning.
Expert in Data migration technique.
Strong data modeling skills including designing and refactoring data models.
Experience in rewriting and optimizing complex stored procedures.
Strong analytical and problemsolving skills with the ability to handle complex database issues.
Strong troubleshooting skills
Excellent verbal and written communication shills
Ability to work in a fastpaced environment
High attention to detail and a commitment to delivering highquality 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
#LIGS!
Skills:
- Application Development
- Data Analysis
- Data Migration
- Data Modeling
- erwin Data Modeler
- Financial Services
- Jira
- Object Oriented Programming
- Oracle
- Postgre SQL
- SQL
- Wealth Management
- Web Application Development
- Oracle Advanced PL/SQL Dev Pro
- Oracle Certified Professional
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 wellbeing 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 equalopportunity 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 teamone of the largest IT and business consulting services firms in the world.
Required Experience:
Senior IC
Employment Type
Full-Time
