Top Benefits
About the role
This role is hybrid and requires you to be at our downtown Toronto\and/or Client office at a minimum 1 days per week - subject to change at any time.
Your future duties and responsibilities
- Design and develop database structures and procedures to facilitate SQL Server Integration Services (SSIS)
- Modify and optimize SQL queries for integration with other applications
- Ensure database performance by identifying and resolving production and application development problems
- Produce SQL reports to assist the management team in business decision making
- Test databases to ensure the accuracy and efficiency of the data output
- Implement data security measures to protect sensitive information
- Manage and maintain database backup and recovery processes
- Create complex functions, scripts, stored procedures and triggers to support application development
- Collaborate with developers to provide data services to applications
- Document database processes as a reference for future troubleshooting and maintenance
Required qualifications to be successful in this role
Must have:
-
SQL expert in understanding complex Stored procedures and problem triage writing queries on the fly to get to the root cause of the issues.
-
Shell scripting and experience working in Linux environments.
-
Incident management & change process.
-
Good problem-solving skills to identify, analyze and effectively address the challenges.
-
Good communication, talking to business leaders explaining the problem.
-
Creating, managing documents & record management
Nice to have:
-
Node JS experience
-
Experience in understanding Azure data bricks.
#LI-AV1
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.
About CGI
Insights you can act on to achieve trusted outcomes.
We are insights-driven and outcomes-focused to help accelerate returns on your investments. Across 21 industry sectors and 400 locations worldwide, we provide comprehensive, scalable and sustainable IT and business consulting services that are informed globally and delivered locally.
We value your opinions and welcome your comments and questions on our posts here on LinkedIn. Please keep a polite, professional and constructive tone. We remove comments containing objectionable language and derogatory views. We do not allow content that is unrelated to the subject, and we remove discriminatory and racist comments as well as spam and advertising.
Note that content on this page contains general information regarding CGI’s services and initiatives and should not be considered direct business advice. To engage in a discussion with one of our experts, please make a request through https://www.cgi.com/en/contact-us
Top Benefits
About the role
This role is hybrid and requires you to be at our downtown Toronto\and/or Client office at a minimum 1 days per week - subject to change at any time.
Your future duties and responsibilities
- Design and develop database structures and procedures to facilitate SQL Server Integration Services (SSIS)
- Modify and optimize SQL queries for integration with other applications
- Ensure database performance by identifying and resolving production and application development problems
- Produce SQL reports to assist the management team in business decision making
- Test databases to ensure the accuracy and efficiency of the data output
- Implement data security measures to protect sensitive information
- Manage and maintain database backup and recovery processes
- Create complex functions, scripts, stored procedures and triggers to support application development
- Collaborate with developers to provide data services to applications
- Document database processes as a reference for future troubleshooting and maintenance
Required qualifications to be successful in this role
Must have:
-
SQL expert in understanding complex Stored procedures and problem triage writing queries on the fly to get to the root cause of the issues.
-
Shell scripting and experience working in Linux environments.
-
Incident management & change process.
-
Good problem-solving skills to identify, analyze and effectively address the challenges.
-
Good communication, talking to business leaders explaining the problem.
-
Creating, managing documents & record management
Nice to have:
-
Node JS experience
-
Experience in understanding Azure data bricks.
#LI-AV1
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.
About CGI
Insights you can act on to achieve trusted outcomes.
We are insights-driven and outcomes-focused to help accelerate returns on your investments. Across 21 industry sectors and 400 locations worldwide, we provide comprehensive, scalable and sustainable IT and business consulting services that are informed globally and delivered locally.
We value your opinions and welcome your comments and questions on our posts here on LinkedIn. Please keep a polite, professional and constructive tone. We remove comments containing objectionable language and derogatory views. We do not allow content that is unrelated to the subject, and we remove discriminatory and racist comments as well as spam and advertising.
Note that content on this page contains general information regarding CGI’s services and initiatives and should not be considered direct business advice. To engage in a discussion with one of our experts, please make a request through https://www.cgi.com/en/contact-us