Mainframe Database Administrator subject matter expertise selection, design, development

Duration: 6 months

Location - Downtown Toronto - Hybrid, every Tuesday (subject to change).

Work Schedule (hours per week, start time): 9am to 5pm Eastern Monday to Friday. Occasional Weekend Support may be required (Early hours Sunday morning).

Position Title:

Senior Consultant Mainframe DBA

Line of Business:
Technology operations - Infrastructure Operations and Networks

What project will this contractor be working on? No specific project work - this is day to day operations.

Team Culture? Very diverse team

Selling points of the positions:
It is not expected that the candidate will be involved in on-call work, although implementations happen only over the weekend and would require a short period of work over a Sunday. 99% of the job will be 9-5 during the regular work week where other DBA's would be required to work on-call or regular after hours.

Who Will the Candidate Be Working with on a Daily Basis?

- Working with the development teams on a regular basis

- Sometimes working with vendors to open tickets

- Liaise with operations support teams

Job Description:

The contractor will be responsible for providing subject matter expertise on the selection, design, development and integration of mainframe databases including IMS, DB2 and CICS. This position requires a solid understanding of mainframe application development and database technology with an emphasis on database administration. The candidate would provide technical guidance on related database and mainframe software updates, in addition to providing database admin support for IMS, DB2 or CICS.

A good understanding of application code development using Cobol is required and knowledge of mainframe assembler is an asset.

This role provides guidance and technical support for mainframe database issues, code development processes and assists other team members in provide technical expertise in investigating functional, application performance and capacity related issues.

Must Have Requirement:

- 3+ years' experience in one or more of IMS, DB2, CICS (Oracle and DB2 together can be total of 3 years')

- 3+ years' experience working in a z/OS TSO/ISPF environment

- 3+ years' experience and knowledge of mainframe tools including: MACRO4, DB2 and IMS administration tools, IBM Application Performance Analyzer (APA) or equivalent

- 3+ years' experience with code/change management process using Service Now, Endevor.

Nice to Have:

- Skills in Easytrieve, SAS, DB2 Connect, TOAD are an asset.

- Knowledge of CA-7 scheduler functionality (awareness of how jobs are scheduled)