DB2 IMS Database Administrator (Canada)

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 worlds most complex technology estates. Learn more on

• Remote in Canada
• The person needs to reside in Canada

Core Responsibilities

• Minimum 10 years of hands-on Db2 for z/OS and IMS DB/DC experience

• Experience supporting business-critical production and data-sharing environments

• Knowledge of IBM utility restart and recovery behavior
• Knowledge of DB2 Platinum utilities
• Familiarity with ITIL incident problem and change practices
• Ability to participate in a formal on-call rotation
• Strong written communication and ability to produce technical runbooks
• Experience 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 environments

DB2 & IMS Database Administration

• 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 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 Management

• Monitor 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 Recovery

• Maintain 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 Support

• Troubleshoot 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 Support

• Work closely with application development teams on DB2/IMS database requirements.
• Provide technical recommendations for database-related application issues.

Required Technical Expertise

Primary skills

• Strong 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 Skills

Experience with several of the following would be beneficial:

• IMS/DC and IMS/TM
• VSAM / OSAM
• REXX
• COBOL
• DFSORT
• IDCAMS
• SMP/E
• OMEGAMON
• BMC MainView for DB2/IMS
• CA/BMC database administration and performance tools
• DB2 Query Monitor / performance-monitoring tools

Work Environment:

• Remote in Canada

Note: 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.

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. Were 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 information on employment scams is availablehere.