Role The candidate will be a member of the Mainframe Database Services team within the Data Management Services department. The primary goal of the team is to provide DB2 and IMS database administration support to various Canadian and US applications. The role will also provide the opportunity to work on infrastructure projects and other peripheral technologies (Optim data masking/archiving etc). We are looking for a dynamic and motivated individual to play an integral part in our team's mission to provide high quality database administration support to our clients. Our clients depend on mainframe databases for a number of their key applications and this dependency is expected to continue well into the foreseeable future What will you do • Create new database objects or modify existing ones as requested by the client • Take appropriate steps to ensure that databases are available as per service level agreements • Take appropriate steps to ensure database integrity • Take appropriate steps to ensure proper database recoverability (onsite and offsite) • Take appropriate steps to ensure that database performance meets client demands (proactive and reactive monitoring) • Pursue opportunities to reduce processing costs as appropriate • Take appropriate steps to ensure proper capacity planning • Assist with security setup and audit requirements • Assist with data archiving, data masking and test data creation • Review database design and make recommendations regarding logical to physical model implementations • Provide support to developers with regards to database topics (SQL-queries, IMS DLI calls, tools usage etc) • Review new database or related tool features and make recommendations for exploitation • Assume an active role in improving current processes or finding innovative new solutions to known problems • Maintain up-to-date documentation of all supported applications and standard procedures • Ensure proper adherence to standards and change management policies • Participate in on-call support rotation • Participate in after-hours or weekend support of production implementations, infrastructure testing activities and various disaster recovery exercises as required • Candidate will need to go through the government security clearance process What You Need To Succeed • Degree in Computer Science or related technology degree/diploma, or equivalent experience • Knowledge of IMS and/or DB2 for Z/OS (administration, performance, security etc) • Experience with RACF or ACF2 • Experience with JCL • Experience with peripheral tools and technologies (IBM HP IMS utilities, CA DB2 tools, File Aid, CA-7, ZEKE, REXX etc) • Windows office (Outlook, Word, Excel, Powerpoint) • Additional useful assets • Experience with Optim data masking and date archive tools • Experience with mainframe programming languages • Experience with MQ and/or DB2-connect • Bilingualism (French and English, written and spoken) - For the Montreal office. Asset for the Waterloo and Toronto offices Preferred Skills • Excellent communication skills (verbal and written) and experience in assisting clients with various issues related to connectivity, permissions, access • Analytical and problem solving skills with a keen attention to detail and the ability to consistently produce high-quality deliverables • Strong organizational skills and monitoring skills with the ability to handle several tasks efficiently and escalate to manager when issues arise • Ability to work and lead projects with minimal direction and to successfully juggle multiple tasks and priorities simultaneously • Good judgement in knowing when to escalate issues including seeking guidance when managing competing priorities and peak workload situations • Work closely and effectively with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services • Ability to evaluate functionality and features with newer versions of the IMS and DB2 DBMS as part of a readiness program , This job is provided by Shine.