Position Description:

‍

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

‍