Title: DB2 Mainframe Consultant
Location: Mississauga
Job Type: Fulltime
DB2 DBA skills & tasks
Perform daytoday administration of all DB2 environments for client Online/client including DEV i2 i3 IST u2 UAT.
Skills include: security backup/recovery design/development capacity & capability planning conversion of segmented to universal tablespaces plus performance tuning.
Knowledge & Use of DB2 Tools like: DB2 Interactive (Command Level DCLGEN & SPUFI) Omegamon plus Utilities like LOAD/UNLOAD BIND/REBIND/FREE IMAGE COPY REORG RUNSTATS and CA (Platinum) Tools like EXPLAIN.
Mainframe
Knowledge & Use of IBM MVS Tools like: JCL TSO ISPF FILEAID XMIT FTP NDM SAR SDSF ChangeMan InfoMan JobDocs.
Track important batch jobs both for status & performance Daily Weekly Monthly and OnDemand.
Client Workstation
Knowledge & Use of Windows Desktop Client Tools like: IBM DB2 Client DbArtisan Windows MSOffice (Access Excel Word Outlook) ServiceNow.
Other
Work cordially with other areas like Development (PL/I) CICS DCdba OPSS MVS WebSphere Fraud COB Prod Support Customer Service Management
TTS GTS (London for SWIFT) and any new projects.