Senior DB2 UDB Database Administrator – Cognizant

Title of the Job: Senior DB2 UDB Database Administrator

Location: Mississauga, ON

Job Description: Senior DB2 UDB Database AdministratorAt Cognizant, our global community sets us apart—an energetic, collaborative and inclusive workplace where everyone can thrive. And with projects at the forefront of innovation, you can build a varied, rewarding career and draw inspiration from dedicated colleagues and leaders. Cognizant is right where you belong.What you’ll do

• Perform database upgrades, particularly from DB2 UDB versions 10.5 and 11.1 to 11.5, ensuring smooth transitions and minimal downtime
• Manage DB2 UDB databases, including installation, patch management, and MQ software configuration.
• Coordinate and solve IBM MQ Replication, ensuring data consistency and availability.
• Configure and handle High Availability Disaster Recovery (HADR) environments, ensuring data protection and quick recovery.
• Apply database diagnostic tools (inbuilt and DMC) for performance tuning, query optimization, and monitoring.
• Implement and lead backup, restore, and recovery strategies to ensure data integrity and availability.
• Build and manage database objects, logical and physical storage, storage groups, and handle capacity planning.
• Monitor replication, run user authorizations, and automate routine tasks using scripting.
• Collaborate with IT teams on problem, change, and incident management processes (ITIL framework).

What you bring to the role

• 8 to 12 years of experience with solid grasp in DB2 UDB database administration, upgrades, and IBM MQ Replication.
• Demonstrable experience in installation, patch management, backup/restore, and disaster recovery strategies.
• Hands-on experience with performance tuning, query optimization, index and partition creation, and related tools.
• Solid grasp of High Availability Disaster Recovery (HADR) configuration and troubleshooting.
• Proficient in using database diagnostic tools and experience scripting to automate routine DBA tasks.
• Familiarity with ITIL processes, including problem, change, and incident management.
• Ability to lead and tackle IBM MQ replication optimally.

Working arrangementsWe believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role’s business requirements, this is a hybrid position requiring 3 days a week in a client or Cognizant office in Mississauga, ON. Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.Note: The working arrangements for this role are accurate as of the date of posting. This may change based on the project you’re engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.

Company Name: Cognizant

Salary:

Apply for the job!