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
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.