Movojobs
Back to results

Added

J&M Group

DB2 DBA Lead

  • Toronto, ON, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type
Contract
Apply by
Posting language
English
Posted

Original job description

Key Responsibilities

  • Administer and tune 300TB+ DB2 LUW DPF clusters and OLTP databases.
  • Handle performance monitoring, troubleshooting, purging, reorganization, and space reclamation.
  • Manage backup, recovery, upgrades, and DR activities.
  • Perform DB2/Greenplum Snowflake data migration and archival.
  • Support SparkSQL-based archival pipelines with a 30-minute data availability target.
  • Automate DBA operations using Python and Shell scripting.
  • Manage/schedule jobs using Autosys and work with JIRA, Git, and Bitbucket.
  • Provide production support and participate in periodic on-call rotation.
  • Perform basic Sybase monitoring during on-call.
  • Independently troubleshoot issues and prioritize work in a Kanban-based environment.

Must-Have Skills

DB2 LUW/DPF, Performance Tuning, Production DBA, Python, Shell Scripting, Data Purging/Reorg, Snowflake, Data Migration, Autosys, Git/Bitbucket, JIRA.

Good To Have

SparkSQL, Sybase, VS Code, GitHub Copilot/AI-assisted development.
Apply About employer
More about this job

Responsibilities

Administer and tune large-scale DB2 LUW DPF clusters and OLTP databases, including performance monitoring and space reclamation. Manage data migrations to Snowflake, automate DBA operations via scripting, and provide production support through on-call rotations.

Requirements

Requires expertise in DB2 LUW/DPF, performance tuning, and automation using Python and Shell scripting. Proficiency with Snowflake, Autosys, and version control tools like Git and Bitbucket is essential.

Skills

  • Db2 Luw/Dpf
  • Performance Tuning
  • Production Dba
  • Python
  • Shell Scripting
  • Data Purging
  • Reorganization
  • Snowflake
  • Data Migration
  • Autosys
  • Git
  • Bitbucket
  • Jira
  • Sparksql
  • Sybase

Visa sponsorship

Not detected in the job text

Categories

  • Technology
  • Data & Analytics
  • Software
  • Consulting
  • Engineering

Keywords

  • Db2 Luw
  • Dpf
  • Oltp
  • Performance Tuning
  • Snowflake
  • Data Migration
  • Python
  • Shell Scripting
  • Autosys
  • Jira
  • Git
  • Bitbucket
  • Sparksql
  • Sybase
  • Kanban
  • Data Archival
  • Production Support
  • Db2 Greenplum
  • Vs Code
  • Github Copilot

Report this job