Skills

Communication Teamwork Java SQL Test Customer Service Presentation Skills Linux Programming Software Development Recruitment

Job Specifications

This is an exciting time for CGI, and we want you to be part of it.

We are Canada's largest independent information technology services firm, and we're still growing! We're expanding in Regina, Saskatchewan and we need your skills, enthusiasm, and dedication as part of our team.

As a Junior SQL Developer you will apply your SQL experience to support the maintenance and enhancement of the critical systems we support for our clients ensuring they achieve and maintain excellent performance and end-user response times.

Key Deliverables and Responsibilities:

Maintain the operations of production applications, and their production operating environments
Ensure that all production applications are available and fully functional
Maintain documentation related to the production environments, including configuration and setup information, operations procedures and logs of related events
Synchronize test/QA and production environments
Manage production cutover processes, including but not limited to Change Control and Release Management
Analyze and resolve complex performance, user/system problems and outages
Participate in planning tasks and supporting team leaders in coordination of activities and estimation development effort
Perform root cause analysis of application and data issues and implement fixes
Design and implement data correction queries and scripts
Perform SQL development according to team best practices
Optimize and tune SQL queries
Perform unit and system tests on developed components
Perform production implementations
On-Call support

Minimum Qualifications:

Completion of a Computer Systems Degree/ Diploma

Must have:

Proven experience in the development of performant SQL queries, and stored procedures
Knowledge of system design and analysis concepts and practices
Ability to understand and interpret object oriented programming languages, such as Java from the performance perspective.
SQL skills
Knowledge of application software development tools, configuration and release management processes and standards
Good analytical, troubleshooting, and presentation skills
Good customer service and communication skills (verbal and written)
Demonstrated ability to act in a responsive and sensitive manner to all client inquiries

Nice to have:

An understanding of ITIL practices and processes, i.e., ITIL Foundation certified.
Linux command line experience
Java developer experience

Level & Scope Criteria

Works under minimal guidance; may receive detailed instructions on new assignments; works independently on details of assignments
Makes decisions on work priorities and methods; decisions may impact project/work timelines of team and/or client
Works on problems where resolution requires review and analysis of several known or identifiable factors
Builds internal relationships outside own work group; begins to initiate information and reports independently; initiates external contacts and builds relationships; proactively provides valued information to client/external contacts.

Technical Knowledge

SQL (Must have)
Batch scheduling system

Your future duties and responsibilities

Required Qualifications To Be Successful In This Role

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.

About the Company

Insights you can act on. Founded in 1976, CGI is among the largest IT and business consulting services firms in the world. We are insights-driven and outcomes-based to help accelerate returns on your investments. Across 21 industries in 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 ... Know more