Mainframe Database Administrator, Information Management Systems -
Duration: Contract until December 28, (possible extension or conversion)
Location: 1 day a week in Toronto or Waterloo (Will consider fully remote)
Site Reliability Clearance Required
Overview
In this role, you will provide hands-on support for Db2 and IMS environments, with a strong focus on CDC Connect and Imperva to ensure reliable data movement, strong security posture, and audit-ready compliance.
Beyond day-to-day activities, you will be involved with operational tasks, helping our team succeed through data-driven monitoring and automated workflows.
This role shapes how traditional mainframe operations evolve, combining deep technical expertise with forward-looking engineering to improve resilience, reduce risk, and accelerate delivery.
Key Responsibilities
CDC Connect Product Support
1. Modify objects for addition/removal in CDC Connect Publisher configurations
2. Execute and schedule refresh data jobs within Zeke scheduling system
3. Investigate and troubleshoot incidents related to CDC operations
4. Collect and provide diagnostic logs for product support escalations
5. Monitor CDC agent performance and maintain operational stability
Imperva Security Management
6. Review mainframe Db2/IMS schema change reports for security implications
7. Collect and validate change tickets with appropriate justification documentation
8. Identify anomalies and suspicious changes in database schema modifications
9. Analyze failed Vulnerability Assessment (VA) scan results across mainframe production environments
10. Determine remediation actions or document legitimate exclusions for failed scan objects
Required Qualifications
11. Experience with mainframe systems (z/OS environment)
12. Knowledge of Db2 and IMS database systems
13. Understanding of CDC technologies and data replication concepts
14. Familiarity with security vulnerability assessment tools (Imperva preferred)
15. Strong analytical and troubleshooting skills
16. Excellent documentation and communication abilities
17. Experience with mainframe job scheduling systems
What you need to succeed:
18. 5+ years knowledge of IMS and/or Db2 for z/OS (administration, performance, security etc.). Strong experience with Db2 utilities and IMS utilities
19. 5+ years of JCL skills
20. Proven experience with SQL query tuning and performance optimization
21. Proficient in IMS application DBA tasks including DBD maintenance
22. Experience with peripheral tools and technologies (IBM HP IMS utilities, Broadcom Db2 tools, CA-7, ZEKE, REXX etc.)
23. Knowledge of Mainframe programming languages and MQ and/or Db2 Connect
24. Scripting experience with REXX (Python scripting highly preferred)
Preferred Qualifications:
25. 5+ years of Experience with RACF or ACF2
26. Experience with Optim data masking and data archive tools
27. Familiarity with insurance industry applications
28. Experience with data warehouse environments
29. Experience with mainframe modernization initiatives
30. Proficiency with zDevOps tools including:
31. Zowe
32. IBM Db2 Admin Foundation
33. Ansible
34. Experience with database automation and scripting and Python scripting
Education: Degree in Computer Science or Technology degree/diploma
Interview Process
1-2 interview – Virtual