Senior Db2 z/os DBA

What is the opportunity?

We are looking for a DB2 z/OS Application DBA for the Enterprise DBA group to provide DBA support to a list of critical applications that use DB2 z/OS technology:

• Create databases/tables/indexes, backup/recovery strategies, tune performance of application queries, create and enhance database maintenance/utility jobs.

• Work on projects and initiatives together with experienced DB2 z/OS and IMS DBAs.

• Partner with DB2 z/OS System Programmers on DB2 z/OS and tools upgrades.

• Ensure that databases are optimally designed, so that applications meet their defined SLAs, maximize reuse of existing database structures, and minimize operational costs.

• 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.

• Provide database-related technical support for development and production environment including required level of 7X24 on call support for production systems.

What will you do?

• Help application teams with database changes/new releases. Partner with application teams on database design, changes, new application releases.

• Partner with RBC infrastructure teams with DB2 z/OS version upgrades, maintenance and enhancement of database products, etc.

• Create and maintain DB2 z/OS databases for application testing, pre-production verification, and production operation.

• Provide technical support for transaction processing, data access, utilities, performance tuning, security, and database recovery.

• Help application teams with the best use of DB2 technology and new features.

• Perform analysis required to resolve complex technical issues/problems.

• 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 z/OS operating system. 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 with 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.

• Customer/service oriented and teamwork mindset.

• 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.

What's 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

Job Skills

Additional Job Details

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.