PL/SQL Developer (Unix & DB2)

Montreal, QC, CA • Posted 59 minutes ago • Updated 59 minutes ago
Contract Corp To Corp
Contract Independent
Contract W2
On-site
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • PL/SQL

Summary

Position Title: PL/SQL Developer (Unix & DB2)

Location: Montreal QC - Hybrid

Duration: 6+ months

Job Description:

We are seeking an experienced PL/SQL Developer with strong Unix/Linux and DB2 database skills to join our team. The ideal candidate will be responsible for designing, developing, maintaining, and optimizing database solutions, batch processes, and automation scripts that support critical business applications. The role requires strong analytical skills, attention to detail, and the ability to work effectively in a fast-paced environment.

Required Skills:

Strong expertise in Oracle PL/SQL development, including:

Stored Procedures

Packages

Functions

Triggers

Views

Performance Tuning and Query Optimization

Strong experience with DB2 UDB, including:

Complex SQL query development

Data analysis and retrieval

Stored procedures

Database performance tuning

Hands-on experience with Unix/Linux environments

Expertise in Shell Scripting (Bash, Korn Shell, etc.)

Experience with Python or Perl scripting for automation and data processing

Experience with scheduling tools such as Autosys, Control-M, or similar platforms

Good understanding of Object-Oriented Programming concepts

Strong analytical and problem-solving skills

Ability to gather business requirements and translate them into technical solutions

Excellent troubleshooting and debugging skills

Strong communication and documentation skills

Ability to manage multiple priorities and deliver high-quality solutions within deadlines

Desired Skills:

Experience with Informatica ETL

Experience with Greenplum or other data warehouse platforms

Experience working in Banking, Financial Services, or Capital Markets environments

Knowledge of data integration and batch processing frameworks

Exposure to Agile/Scrum development methodologies

Responsibilities:

Design, develop, test, and maintain Oracle PL/SQL applications and database objects

Develop and optimize 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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10121915
  • Position Id: 2026-4792
  • Posted 59 minutes ago
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.