13 Nov
|
Envision Technology Solutions
|
Montreal
13 Nov
Envision Technology Solutions
Montreal
Location : Montreal, QC - 3 days a week onsite.Client Interview will be F2F in MontrealContract RoleNOTEThis was initially a Db2 dev position, since we didn't find resources for Db2 dev role, Manager relaxed a bit and changed the req to PL/SQL dev role with some experience in Db2 or willingness to learn Db2.Job SummaryWe 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 quick-paced environment.Required SkillsStored ProceduresPackagesFunctionsTriggersViewsPerformance Tuning and Query OptimizationStrong experience with DB2 UDB, including:Data analysis and retrievalStored proceduresDatabase performance tuningHands-on experience with Unix/Linux environmentsExpertise in Shell Scripting (Bash, Korn Shell, etc.)Experience with Python or Perl scripting for automation and data processingExperience with scheduling tools such as Autosys, Control-M,
or similar platformsGood understanding of Object-Oriented Programming conceptsStrong analytical and problem-solving skillsAbility to gather business requirements and translate them into technical solutionsExcellent troubleshooting and debugging skillsStrong communication and documentation skillsAbility to manage multiple priorities and deliver high-quality solutions within deadlinesDesired SkillsExperience with Informatica ETLExperience with Greenplum or other data warehouse platformsExperience working in Banking, Financial Services, or Capital Markets environmentsKnowledge of data integration and batch processing frameworksExposure to Agile/Scrum development methodologiesResponsibilitiesDesign, develop, test, and maintain Oracle PL/SQL applications and database objectsDevelop and optimize DB2 SQL queries, stored procedures, and data processing routinesCreate and maintain Unix/Linux shell scripts for automation and batch processingSupport production systems and troubleshoot application and database issuesPerform performance tuning of SQL queries, PL/SQL code, and database processesCollaborate with business analysts, developers, and stakeholders to understand requirementsPrepare technical design documents and implementation plansEnsure compliance with development standards and best practicesParticipate in code reviews, testing, deployment, and production support activities
📌 Pl/Sql Developer (Montreal)
🏢 Envision Technology Solutions
📍 Montreal