Role Description: Understand the design and structure of Db2 Data base on Mainframes underlying objects like Database, tables spaces, tables, indexes, stored procedures and to compare to oracle DB for migration and replication.Should have work experience on data base migration projects using different tools or thru ETL processes.Create databases/tables/indexes, backup/recovery strategies, compatibility issues, tune performance of application queries, create and enhance database maintenance/utility jobs.Work on projects and initiatives together with experienced DB2 z/OS and technology 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

Essential Skills: Excellent technical knowledge of database and relational database management technologies on z/OS operating system. Experience in supporting critical Migration projects that uses other databases like Oracle.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 Migration projects. Loading and unloading tables and recover / restore thru FIC or partial ICs.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.

• Desirable Skills: Experience supporting applications that use Seibel on Db2 DB and knowledge in other databases like Oracle DB. Additional training/learning might be required.Knowledge in Migration projects from Mainframe Db2 Dabatase to other databases thru ETL or cloud tools like Dbeaver, Golden gate etcREXX/CLIST programming. Knowledge on replication processes