Location : Montreal, QC - 3 days a week onsite.

Job Summary

We are seeking an experienced PL/SQL Developer with robust 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
Stored Procedures
Packages
Functions
Triggers
Views
Performance Tuning and Query Optimization
Strong experience with DB2 UDB, including:
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
Positive understanding of Object-Oriented Programming concepts
Robust 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

📌 Pl/sql Developer Montreal
🏢 Siri Infosolutions
📍 Montreal