IBM DB2 Administrator (DB2 LUW)

Title: DB2 LUW Administrator

Location: Montreal

Hybrid: 3 days in office

Key words to search in resume: DB2 LUW DBA, LINUX/UNIX, Scripting, DB2, HADR, Replications

Technical/Functional Skills:

Detail knowledge of IBM DB2 Administration of version 10.5 ,11.1,11.5 and above.

Detailed knowledge of DB2 Replication Server Administration.

Expertise in performance and tuning.

Having experience in handling PMR with IBM and troubleshooting with vendors.

Experience Required Experience:

8+ years of experience as a DB2 LUW DBA or in a similar role, with hands-on experience in supporting DB2 Databases/replication, upgrades & performance tuning knowledge.

Roles & Responsibilities

Detailed knowledge of DB2 server installations on standalone/DPF/HADR .

Install, upgrade, and manage database.

Manage database access. Adhere to best practices regarding access to and management of databases.

Perform Database Migrations using Dump/Load , Inplace Upgrade.

Improve database performance and operational excellence.

Troubleshoot database-related application performance issues and recommend solutions.

Perform Replication setup including table level/Warm Standby/MSA and tuning.

Handling Replication operation issues.

Having knowledge on Database Maintence task such as Dbcc, Reorg.

Collaborate with cross-functional teams to troubleshoot live issues, internally or externally reported.

Create / Modify automation for repeating database tasks.

Communicate with and update management on systems health.

Participate in on-call rotation and 24x7 supporting and troubleshooting database issues during Weekday and Weekends.

Duties include maintenance of Database Servers in a development/testing environment.

Generic Managerial Skills:

Co-ordination with various stakeholders is required. On time report preparation/submission. Excellent written and verbal communication skills

Education Bachelor’s degree