Talent.com
Acestack
Database Administrator (DB2 DBA)Acestack • Toronto, Ontario, Canada
Database Administrator (DB2 DBA)

Database Administrator (DB2 DBA)

Acestack • Toronto, Ontario, Canada
30+ days ago
Job type
  • Full-time
Job description
Role: Database Administrator (DB2 DBA)
Location: Toronto Canada (Hybrid) DB2 DBA (LUW) Administrator
Role Summary
A DB2 LUW Administrator is responsible for managing IBM DB2 databases on distributed platforms (Linux Unix Windows). The role focuses on database installation maintenance performance optimization and ensuring high availability and security of database systems.

Required Skills
Technical Skills
Strong experience with IBM DB2 LUW (KUW)
Hands-on experience with:
HADR configuration
Backup & recovery strategies
Performance tuning
Strong SQL knowledge
Experience with Linux/Unix environments
Familiarity with DB2 tools (db2pd db2top EXPLAIN)

Preferred Skills
DB2 certifications (IBM Certified DBA)
Experience with cloud environments (AWS/Azure)
Exposure to other RDBMS (Oracle SQL Server)
Knowledge of automation and DevOps tool
Experience
8 years of DB2 LUW administration experience

Key Competencies
Problem-solving and troubleshooting skills
Strong analytical thinking
Ability to work in production support environments
Good communication and teamwork


Key Responsibilities
Database Administration
Install configure and maintain DB2 LUW databases
Create and manage instances databases tablespaces and schemas
Perform database upgrades patches and migrations
Manage storage space allocation and capacity planning

Performance Management
Monitor and analyze database performance
Tune SQL queries indexing strategies and database configurations
Optimize memory usage buffer pools and workload management
Troubleshoot locking deadlocks and slow queries

Backup & Recovery
Configure and manage backup strategies (offline/online backups)
Perform restores and point-in-time recovery (PITR)
Ensure proper archival logging and recoverability
Regularly validate backup integrity

High Availability (HA) & DR
Implement and manage HADR (High Availability Disaster Recovery)
Configure failover replication and standby databases
Support disaster recovery drills and testing

Security & Access Management
Manage users roles and permissions
Implement DB security policies and encryption
Ensure compliance with organizational and regulatory requirements

Monitoring & Troubleshooting
Monitor database health and system logs
Resolve incidents outages and performance issues
Perform root cause analysis and preventive actions

Automation & Scripting
Develop automation scripts (Shell Python Perl)
Automate routine DBA tasks such as backups and monitoring
Use scheduling tools like cron for maintenance jobs
Employment Type : Full Time
Experience: years
Vacancy: 1
Create a job alert for this search

Database Administrator (DB2 DBA) • Toronto, Ontario, Canada

Similar jobs

Database Administrator

Rivago Infotech IncToronto, ON, CA
Full-time

Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Rivago Infotech Inc.Location : Remote, (Open for Canada only).The DBA position will be responsible f... Show more

 • Promoted

Senior Database Administrator - Hybrid (Azure/Oracle)

Yoush ConsultingToronto, ON, CA
Full-time

A consulting firm in Toronto is seeking four Senior Database Administrators for a 1-year hybrid contract.Responsibilities include preparing and configuring mainframe systems, maintaining large-scal... Show more

 • Promoted

Database Administrator (MS SQL/Azure)

HRbrain Inc.Toronto, ON, CA
Full-time

Start/End Dates: 2026-04-27 – 2026-10-26.The Candidate will be working with: Solution Design, DB Engineering, Information Security teams and external vendors.Taking ownership of and leading technic... Show more

 • Promoted

Database Administrator

The Citco Group LimitedToronto, ON, CA
Full-time

Citco provides specialist financial services to alternative investment funds, investors, multinationals and private clients worldwide.With over 13,000 employees in 45 countries we pioneer innovativ... Show more

 • Promoted

Database Administrator

Northwest Employment WorksToronto, ON, CA
Full-time

Nuclear Waste Management Organization (NWMO).Canada’s intermediate- and high-level radioactive waste, in a manner that protects people and the environment for generations to come.Indigenous Knowled... Show more

 • Promoted

DB2 Mainframe IMS Administrator

CloudVitalToronto, ON, CA
Full-time

We are looking for a highly skilled DB2 Mainframe professional for one of the leading firms.DB2 Mainframe IMS Administrator.Participate in review of project and maintenance release artefacts – Use ... Show more

 • Promoted

Database Administrator (DBA) – Specialist (Oracle GoldenGate / SQL Azure)

Apex SystemsToronto, ON, CA
Temporary

Hybrid – in-office every Tuesday.FTE based on performance and budget).We are looking for a Database Administrator Specialist with expertise in Oracle GoldenGate and SQL Azure, and experience suppor... Show more

 • Promoted

Senior Oracle Database Administrator

TangerineToronto, ON, CA
Full-time

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.The Information Technology (IT) department manages the technology and computer infrastructure t... Show more

 • Promoted

Cloud-Focused Database Administrator

Source CodeToronto, ON, CA
Full-time

Shape the future as a Senior Database Administrator, embracing cloud innovation and SQL advancements.Deliver key support in transforming health system databases into efficient solutions.This role o... Show more

 • Promoted

PostgreSQL Database Administrator (Production DBA)

Centric SoftwareToronto, ON, CA
Full-time

Centric Software® is a global leader, providing an innovative and AI-enabled product-concept-to-commercialization platform for retailers, brands and manufacturers of all sizes.We equip retail, fash... Show more

 • Promoted

Database Administrator (DBA/SQL)

Onico SolutionsRichmond Hill, York Region, CA
Permanent

The Database Administrator (DBA/SQL) will manage and support a corporate SQL database environment in addition to managing and executing software implementations.Responsible for administering SQL se... Show more

 • Promoted

Oracle Database Administrator

Insight GlobalToronto, ON, CA
Full-time +1

This range is provided by Insight Global.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Direct message the job poster from Insight Global.Regio... Show more

 • Promoted

Senior Oracle Database Administrator

Tangerine BankToronto, ON, CA
Full-time

Senior Oracle Database Administrator.The Information Technology (IT) department manages the technology and computer infrastructure that drives Tangerine’s business systems.The IT department support... Show more

 • Promoted

Senior Database Administrator

ScotiabankToronto, ON, CA
Full-time

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.We are looking for an experienced MongoDB DBA who will maintain MongoDB databases while optimiz... Show more

 • Promoted

Database Administrator

LanceSoft, Inc.Toronto, ON, CA
Full-time

Location: 44 King Street W 10th Floor, Toronto, Ontario.Hybrid: 2 days in-office (will increase to 4 days in future).The successful candidate will gain experience with a top 5 Canadian bank on a dy... Show more

 • Promoted

Senior Database Administrator in Cloud

Dayforce US, Inc.Toronto, ON, CA
Full-time

Advance your career with Dayforce as a Senior Database Administrator focused on cloud environments.This role requires exceptional SQL database support and administration skills.You will be integral... Show more

 • Promoted

Expert Database Administrator for Data Optimization

Tata Consultancy ServicesToronto, ON, CA
Full-time

Become an Expert Database Administrator and optimize performance in Oracle, MySQL, and Greenplum environments.Your role will be pivotal in ensuring data security and high retrieval efficiency.This ... Show more

 • Promoted

Senior DB2 DBA – Toronto: Performance & Production

EROS Technologies Inc.Toronto, ON, CA
Full-time

A trusted strategic technology partner in Toronto is seeking a skilled DB2 Database Administrator (DBA) with substantial experience in performance tuning and production database management.The idea... Show more

 • Promoted

Oracle Database Administrator

BuzzClanToronto, ON, CA
Full-time

Position: Database Administrator - Senior.Type: Contract (Initial term of 12+ month with possibility of extension).Provide scripting skills in SQL, VBScript, Python and PowerShell.Provide technical... Show more

 • Promoted

Senior PostgreSQL & MongoDB DBA - Hybrid (Toronto)

DelpathToronto, ON, CA
Full-time +1

A Canadian tech firm is seeking an experienced Database Administrator for a 6-month contract.The role involves managing PostgreSQL and MongoDB installations, ensuring database security, and support... Show more