Senior Db2 z / os DBA
RBC - Royal BankToronto, ON30+ days ago
Job descriptionHelp 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. 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. REXX / CLIST programming Experience supporting applications that use IMS databases. Additional training / learning might be required at RBC. 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.
Job Summary
Job Description
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?
What do you need to succeed?
Must Have
Nice to Have
What's in it for you?
LI-Hybrid
LI-Post
LI-PK
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