PL/SQL & DB2 Developer | Unix/Linux Automation | Montreal

Envision Technology Solutions; Montreal; On-site; CAD 55,000 - 83,000; Part time

Job summary

Envision Technology Solutions in Montreal is seeking an experienced PL/SQL Developer with strong Unix/Linux and DB2 skills. The role focuses on designing, developing, and maintaining database solutions, batch processes, and automation scripts in a fast-paced environment.

The ideal candidate will optimize SQL/PLSQL performance, work with scheduling tools like Autosys/Control-M, and collaborate with analysts and developers to deliver high-quality solutions.

Qualifications

• Proficient in PL/SQL development with DB2 UDB experience.
• Strong Unix/Linux and shell scripting abilities.
• Experience in optimizing and tuning SQL/PLSQL.
• Hands-on scripting in Python or Perl for automation.
• Ability to gather requirements and translate to technical solutions.

Responsibilities

• Design, develop, test, and maintain PL/SQL applications and DB objects.
• Create and optimize DB2 SQL queries and data processing routines.
• Develop Unix/Linux shell scripts for automation and batch jobs.
• Support production systems and troubleshoot database issues.
• Participate in code reviews, deployments, and documentation.

Skills

DB2 UDB

Unix/Linux

Shell Scripting

PL/SQL

Oracle SQL

Performance Tuning

Batch Processing

Analytical Thinking

Problem Solving

Documentation

Tools

Autosys

Control-M

Informatica ETL

Job description

Envision Technology Solutions in Montreal is seeking an experienced PL/SQL Developer with strong Unix/Linux and DB2 skills. The role focuses on designing, developing, and maintaining database solutions, batch processes, and automation scripts in a fast-paced environment.

The ideal candidate will optimize SQL/PLSQL performance, work with scheduling tools like Autosys/Control-M, and collaborate with analysts and developers to deliver high-quality solutions.