Summary
✨ AI‑Generated
Join a forward-thinking tech organization in Montreal as a Senior Database Developer. You will design and optimize complex data retrieval systems using DB2 UDB and PL/SQL, automate data processing pipelines with Python and Perl, and ensure high-performance database operations through query tuning and execution plan analysis. This role offers a hybrid work model with strong emphasis on innovation and technical excellence.
Highlights
Work with enterprise-grade databases and complex data pipelines in a hybrid environment. Opportunity to tune high-volume applications and contribute to Agile development cycles.
Description
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.
