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.

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

Job Skills

Additional Job Details

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