Senior DB2 LUW Application DBA
Manage large-scale DB2 LUW DPF clusters, focusing on performance tuning, data purging, and backup recovery. Lead data migrations from DB2 and Greenplum to Snowflake and support archival pipelines using SparkSQL.
- On-site
- ON
- Posted Sep 8, 2026
- Apply by Oct 8, 2026
- 1 position
Opens an external site
More jobs you can apply to directly
Similar opportunities posted by employers hiring on Jobs.ca, with no external application form.
Job summary
Hiring: Senior DB2 LUW Application DBA Location: Ontario, Canada (Onsite) We are looking for a Senior DB2 LUW Application DBA with strong experience in large-scale database operations, performance tuning, automation, and data migration. Environment: • 5 very large 300TB+ DB2 LUW DPF clusters per environment • Multiple OLTP databases • Fully on-premises environment Key Responsibilities: • DB2 database operations, monitoring, and performance tuning • Performance optimization across DPF clusters • Data purging strategy and execution • Space reclamation for very large tables after purge • Backup, recovery, upgrades, and DR planning • Snowflake database administration • On-premises to Snowflake data migration • DB2 → Snowflake and Greenplum → Snowflake migrations • Support continuous DB2 LUW → Snowflake archival pipelines using SparkSQL-based tooling • Work with JIRA, Bitbucket, Git, and Autosys • Manage and support environments with 700+ scheduled jobs Required Skills: ✅ Strong DB2 LUW / DPF experience ✅ Strong Python and Shell scripting – automation is core to the role ✅ Snowflake administration and large-scale data migration ✅ DB2 performance tuning and database operations ✅ JIRA, Bitbucket, Git, and Autosys ✅ Experience with large OLTP environments ✅ Strong troubleshooting and problem-solving skills ✅ Ability to work independently in a Kanban-based environment ➕ AI-assisted development tools such as VS Code and GitHub Copilot are a plus ➕ Basic Sybase database monitoring knowledge for on-call support 🔹 Work & Support Model • Kanban-based work management with no fixed daily/weekly schedule • Work driven by purge requests, migrations, incidents, performance issues, and regulatory requirements • No 24x7 support • On-call rotation approximately one week every 2–3 months The ideal candidate should be self-directed, comfortable with ambiguity, and capable of making independent technical decisions and taking ownership. 📩 Interested candidates can share their updated resume. please share your resume - [email protected] / [email protected] Contact No - 817 330 7081
What you’ll do
Manage large-scale DB2 LUW DPF clusters, focusing on performance tuning, data purging, and backup recovery. Lead data migrations from DB2 and Greenplum to Snowflake and support archival pipelines using SparkSQL.
Requirements
Requires strong expertise in DB2 LUW/DPF, Snowflake administration, and automation using Python and Shell scripting. Candidates must be experienced with large OLTP environments and tools like Git, Bitbucket, and Autosys.
Listed skills
- JiraPreferred
- KanbanPreferred
- GitPreferred
- PythonPreferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- DB2 LUW
- DB2 DPF
- Python
- Shell Scripting
- Snowflake Administration
- Data Migration
- Performance Tuning
- Database Operations
- JIRA
- Bitbucket
- Git
- Autosys
- OLTP
- SparkSQL
- Sybase
- Kanban
Job areas
- Technology
- Data & Analytics
- Software
- Engineering
- Consulting
Additional details
- Minimum experience
- 10+ years
- Apply by
- Oct 8, 2026
- Posting language
- English
- Working hours
- 40 hours per week
- Seniority
- Mid-Senior level
- Application method
- Direct apply is available