PL/SQL Developer: Unix/DB2, Automation (Onsite Montreal)

GALA SOLUTIONS Co.; Montreal; On-site; CAD 90,000 - 120,000; Full time

Job summary

GALA SOLUTIONS Co. in Montreal, QC seeks an experienced PL/SQL Developer with strong Unix/Linux and DB2 skills to design, develop, maintain, and optimise database solutions, batch processes, and automation scripts for critical business applications.

The role requires strong analytical abilities, attention to detail, and the ability to work well in a fast-paced environment, delivering high-quality solutions within deadlines.

Qualifications

• Experience with PL/SQL development and database objects.
• Strong DB2 UDB skills including performance tuning.
• Unix/Linux shell scripting and automation experience.

Responsibilities

• Design, develop, test, and maintain PL/SQL applications and database objects.
• Develop and optimise DB2 SQL queries, stored procedures, and data processing routines.
• Create and maintain Unix/Linux shell scripts for automation and batch processing.
• Support production systems and troubleshoot application and database issues.
• Perform performance tuning of SQL queries, PL/SQL code, and database processes.
• Collaborate with business analysts, developers, and stakeholders to understand requirements.
• Prepare technical design documents and implementation plans.
• Ensure compliance with development standards and best practices.
• Participate in code reviews, testing, deployment, and production support activities.

Skills

Stored Procedures

Packages

Functions

Triggers

Views

DB2 UDB

Unix/Linux

Shell Scripting

Python/Perl scripting

Autosys/Control-M

OOP concepts

Requirements gathering

Troubleshooting

Documentation

Communication

Job description

GALA SOLUTIONS Co. in Montreal, QC seeks an experienced PL/SQL Developer with strong Unix/Linux and DB2 skills to design, develop, maintain, and optimise database solutions, batch processes, and automation scripts for critical business applications.

The role requires strong analytical abilities, attention to detail, and the ability to work well in a fast-paced environment, delivering high-quality solutions within deadlines.