DB2 / IMS Database Administrator (Canada)

DXC Technology; Toronto; Remote; CAD 92,000 - 142,000; Full time

Benefits offered by this job

Health benefits

Paid time off

Retirement plan

Job summary

DXC Technology in Canada seeks an experienced DB2/IMS DBA to support DB2 for z/OS and IMS environments, focusing on performance tuning, recovery, and DR readiness.

You will work remotely from Canada, participate in on-call rotations, and collaborate with application teams to implement changes while maintaining high availability.

Candidates should have 10+ years of hands-on experience and in-depth knowledge of IBM utilities, JCL, and z/OS technologies.

Qualifications

• 10+ years hands-on IBM DB2 for z/OS DBA experience
• Strong IMS DB administration experience
• SQL and database troubleshooting
• JCL, TSO/ISPF proficiency
• Knowledge of z/OS mainframe environments

Responsibilities

• Provide day-to-day administration and production support for DB2 for z/OS and IMS databases
• Create, modify, maintain, monitor, and tune DB2 and IMS database objects
• Review and implement database changes for applications and infra teams
• Perform database maintenance, upgrades, and recoverability improvements
• Assist application teams with database design and service requests
• Monitor database health, performance, storage utilization, and availability
• Troubleshoot DB2/IMS performance issues and optimize workloads
• Execute DB2 maintenance utilities (REORG, RUNSTATS, LOAD, UNLOAD)
• Manage backup, recovery, and disaster recovery procedures
• Participate in DR exercises and business continuity testing

Job description

Job Description:DXC Technology (NYSE: DXC) is a leading enterprise technology and innovation partner delivering software, services, and solutions to global enterprises and public sector organizations — helping them harness AI to drive outcomes at a time of exponential change with speed. With deep expertise in Managed Infrastructure Services, Application Modernization, and Industry-Specific Software Solutions, DXC modernizes, secures, and operates some of the world’s most complex technology estates. Learn more on dxc.comCore ResponsibilitiesMinimum 10 years of hands-on Db2 for z/OS and IMS DB/DC experienceExperience supporting business-critical production and data-sharing environmentsKnowledge of IBM utility restart and recovery behaviorKnowledge of DB2 Platinum utilitiesFamiliarity with ITIL incident, problem, and change practicesAbility to participate in a formal on-call rotationStrong written communication and ability to produce technical runbooksExperience with IMS DBRC/RECON administration, DBD/PSB/ACB management, IMS recovery and reorganization utilities, Db2 BIND/REBIND and access-path analysis, Db2 backup/recovery utilities, and performance tuning in large-scale z/OS production environmentsDB2 & IMS Database AdministrationProvide day-to-day administration and production support for DB2 for z/OS and IMS databases .Create, modify, maintain, monitor, and tune DB2 and IMS database objects.Review and implement database changes required by application and infrastructure teams.Perform database maintenance, upgrades, and technical changes, ensuring database environments remain stable and recoverable.Assist application teams with database design and database-related service requests.Performance & Capacity ManagementMonitor database health, performance, storage utilization, and availability.Analyze and troubleshoot DB2 and IMS performance issues.Perform SQL and database performance tuning.Identify resource-intensive or poorly performing database workloads and recommend corrective actions.Execute and manage DB2 maintenance utilities such as REORG, RUNSTATS, LOAD, and UNLOAD .Backup, Recovery & Disaster RecoveryMaintain and support DB2 and IMS backup and recovery procedures.Ensure critical databases meet established recoverability requirements.Troubleshoot database recovery issues and support restoration activities.Participate in scheduled Disaster Recovery (DR) exercises and business continuity testing for DB2 and IMS environments.Production & Operational SupportTroubleshoot and resolve database incidents, problems, service requests, and changes.Perform root-cause analysis for database-related production issues.Coordinate with application, infrastructure, operations, and other technical teams during critical incidents.Participate in planned maintenance and production implementations.Maintain appropriate technical and operational documentation.Application DBA SupportWork closely with application development teams on DB2/IMS database requirements.Provide technical recommendations for database-related application issues.Required Technical ExpertisePrimary skillsStrong hands-on IBM DB2 for z/OS DBA experience.Strong hands-on IBM IMS DB administration experience.DB2/IMS performance monitoring and tuning.DB2/IMS backup, recovery, and disaster recovery.Strong understanding of z/OS mainframe environments .SQL and database troubleshooting.JCL.TSO/ISPF.Preferred Mainframe / IMS SkillsExperience with several of the following would be beneficial:IMS/DC and IMS/TMVSAM / OSAMREXXCOBOLDFSORTIDCAMSSMP/EOMEGAMONBMC MainView for DB2/IMSCA/BMC database administration and performance toolsDB2 Query Monitor / performance-monitoring toolsWork Environment:Remote in CanadaNote: Must be legally authorized to work in Canada. The client is in a controlled goods program environment and must comply with the Controlled Goods Program (CGP), which mandates that all applicants hold Canadian Citizenship or Permanent Residency status in Canada.Compensation at DXC is influenced by an array of factors, including but not limited to the experience, job-related knowledge, skills, competencies, as well as contract-specific affordability and organizational requirements. A reasonable estimate of the current compensation range for this position is $92,100 - $142,100.Full-time hires are eligible to participate in the DXC benefit program. DXC offers a comprehensive, flexible, and competitive benefits program which includes, but is not limited to, health, dental, and vision insurance coverage; employee wellness; life and disability insurance; a retirement savings plan, paid holidays, paid time off.DXC is an equal opportunity employer. We welcome the many dimensions of diversity. Accommodation of special needs for qualified candidates may be considered within the framework of the DXC Accommodation Policy.In addition, DXC Technology is committed to working with and providing reasonable accommodation to qualified individuals with physical and mental disabilities. If you need assistance in filling out the employment application or require a reasonable accommodation while seeking employment, please e-mail AODA Canada Requests .Note: This option is reserved for applicants needing a reasonable accommodation related to a disability.At DXC Technology, we believe strong connections and community are key to our success. Our work model prioritizes in-person collaboration while offering flexibility to support wellbeing, productivity, individual work styles, and life circumstances. We’re committed to fostering an inclusive environment where everyone can thrive.Recruitment fraud is a scheme in which fictitious job opportunities are offered to job seekers typically through online services, such as false websites, or through unsolicited emails claiming to be from the company. These emails may request recipients to provide personal information or to make payments as part of their illegitimate recruiting process. DXC does not make offers of employment via social media networks and DXC never asks for any money or payments from applicants at any point in the recruitment process, nor ask a job seeker to purchase IT or other equipment on our behalf.