Lead DB2 z/OS Database Specialist

Job Summary Job Description What is the opportunity? To lead DB2 z/OS projects and initiatives, working together with experienced DB2 z/OS and IMS DBAs. To work closely with DB2 z/OS System Programmers on DB2 z/OS and tools upgrades. To provide DBA support to a list of critical applications that use DB2 z/OS and IMS databases/transactions. To provide support of Host database and transaction management technology teams, including deployment and usage standards. To lead application development and support teams in optimal use of database and transaction management technology through creation and communication of standards and walkthrough of critical application components. To ensure that databases are optimally designed, so that applications meet their defined SLAs, maximize reuse of existing database structures, and minimize operational costs. To ensure that all database and environmental changes are appropriately tested and implemented in such a manner that there is no impact to RBC systems and clients. To provide database related technical support for development and production environment including required level of 7X24 on call support. What will you do? Assist RBC infrastructure teams with DB2 z/OS version upgrades, maintenance and enhancement of database products, etc. Create and maintain Host (DB2 z/OS and IMS) database & transaction processing environments for application testing, pre-production verification, and production operation. Provide technical support for transaction processing, data access, utilities, performance tuning, security, and database recovery. Coach Application staff, as appropriate. Perform analysis required to resolve complex technical issues/problems. Provide skilled counsel in the technical design of applications. Research, analyze and make recommendations on software/utility usage. Serve as the technical lead for projects. What do you need to succeed? Must Have Excellent technical knowledge of database and transaction management technologies and operating systems. Experience supporting critical applications that use DB2 z/OS databases. High level of proven competence with data manipulation languages, data definition languages, physical database design, and application performance analysis & tuning. Experience leading DB2 z/OS and Tools upgrade projects Strong interpersonal and communication skills; ability to communicate with people in a wide variety of areas and at various levels from technical specialists to project managers. Ability to learn and absorb quickly new concepts (in DBMS technology and infrastructure), apply new knowledge as appropriate and transfer knowledge to others. Good coaching/mentoring skills. Nice to Have REXX/CLIST programming Experience supporting applications that use IMS databases. Additional training/learning might be required at RBC. Whats in it for you? A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable. Leaders who support your development through coaching and managing opportunities Ability to make a difference and lasting impact. Work in a dynamic, collaborative, progressive, and high-performing team. Flexible work/life balance options. Opportunities to do challenging work. Opportunities to take on progressively greater accountabilities. #LI-Hybrid #LI-Post #LI-PK #TechPJ Job Skills CLIST (Programming Language), Critical Thinking, Database Backup, Databasing, Decision Making, Detail-Oriented, IBM z/OS, IMS Databases, Information Security, Rexx Additional Job Details Address: RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO City: TORONTO Country: Canada Work hours/week: 37.5 Employment Type: Full time Platform: TECHNOLOGY AND OPERATIONS Job Type: Regular Pay Type: Salaried Posted Date: 2024-08-07 Application Deadline: 2024-10-01 I nclusion and Equal Opportunity Employment At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities. We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process. Join our Talent Community Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you. Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.