This is an exciting time for CGI and we want you to be part of it.
We are Canadas largest independent information technology services firm and were still growing! Were 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 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 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 teamone of the largest IT and business consulting services firms in the world.
The COMPANY is one of the few end-to-end consulting firms with the scale, reach, capabilities and commitment to meet clients’ enterprise digital transformation needs. Our 77,500 consultants and professionals work side-by-side with clients in 10 industries across more than 400 location ... View more