Closed listing
Senior PL/SQL / DB2 Database Developer
- Montreal, QC, Canada
Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Contract
- Closing date
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Position: PL/SQL / DB2 Database Developer
Location: Montreal, QC (Hybrid - 3 days/week onsite)
Experience Level: 7+ Years
Role Overview & Key Responsibilities:
- Design, construct, and optimize complex data retrieval queries, stored procedures, functions, and database packages in DB2 UDB / PL/SQL environments.
- Write, maintain, and debug production-grade Linux/Unix shell scripts alongside Python or Perl scripts for data processing and pipeline automation.
- Manage automated batch job orchestration, monitoring, and dependency management using Autosys or similar job scheduling tools.
- Interpret business requirements and produce comprehensive technical design documents, data models, and flow diagrams.
- Perform database performance tuning, execution plan analysis, and query optimization for high-volume enterprise applications.
- Support system integration testing, defect resolution, and release deployment activities in an Agile environment.
Required Qualifications & Skills:
- Bachelor's degree in Computer Science, Software Engineering, or equivalent practical experience.
- 7+ years of hands-on experience developing complex queries, scripts, and stored procedures in DB2 UDB or PL/SQL database platforms.
- Expert proficiency in Linux/Unix shell scripting.
- Solid hands-on experience programming in Python and/or Perl.
- Practical understanding of Autosys or enterprise job scheduling software.
- Strong analytical, problem-solving, time-management, and technical documentation skills.
- Must be available to work hybrid (3 days per week onsite) in Montreal, QC.
Nice to Have:
- Experience with Greenplum data warehouse platforms.
- Practical knowledge of Informatica PowerCenter ETL workflows.
- Domain experience in Banking or Financial Services.
More about this job
Responsibilities
Develop and optimize DB2 UDB and PL/SQL queries, stored procedures, and database packages, while automating data processing and batch workflows with shell scripts, Python or Perl, and Autosys. Create technical designs and data models, tune database performance, and support integration testing, defect resolution, and releases in an Agile environment.
Requirements
Requires a bachelor's degree in Computer Science, Software Engineering, or equivalent practical experience, plus at least seven years of hands-on database development experience. Candidates should have strong Linux/Unix shell scripting skills, Python and/or Perl experience, familiarity with enterprise job scheduling, and availability to work onsite in Montreal three days per week.
Skills
- DB2 UDB
- PL/SQL
- SQL Query Optimization
- Stored Procedures
- Linux/Unix Shell Scripting
- Python
- Perl
- Autosys
- Batch Job Scheduling
- Database Performance Tuning
- Execution Plan Analysis
- Data Modeling
- Technical Documentation
- System Integration Testing
- Agile
- Informatica PowerCenter
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Finance & Accounting
Keywords
- DB2 UDB
- PL/SQL
- Stored Procedures
- Database Packages
- Linux
- Unix
- Shell Scripting
- Python
- Perl
- Autosys
- Batch Job Orchestration
- Database Performance Tuning
- Execution Plan Analysis
- Query Optimization
- Technical Design Documents
- Data Modeling
- Flow Diagrams
- System Integration Testing
- Defect Resolution
- Release Deployment
- Agile
- Greenplum
- Informatica PowerCenter
- ETL
- Banking
- Financial Services