DB2 Database SME

• act as SME for all matters related to DB2 database for Custody Application, SECORE
• provide in-depth subject matter expertise on DB2 Utilities including backup and recovery using FlashCopy
• perform an advisory role in the design and delivery of various changes from Application development teams located in distributed locations
• adhere to defined standards and best practices for the management and support of the DB2 Databases in development and production subsystem
• work with CTI to manage and implement Application changes through various environments
• ensure that delivered Database changes are fit for purpose and appropriately sized, tested, monitored and managed
• offer expertise to Production Support and Migration Team to resolve DB2 failure and tune application performance
• monitor and perform regular health check of all Custody Application, SECORE Databases
• develop and deliver solutions to support application development and reduce costs

• 8-13 years DB2 experience
• strong IT background within Banking Industry with end-to-end experience of Service Delivery
• good knowledge of JCL, COBOL, REXX, TWS, File Aid and CA Platinum DB2 Tools
• experience with performance tuning of batch and online application
• sound knowledge and understanding of the DB2 database architecture, including schemas, tables, views, packages, stored procedures, functions, triggers, sequences, indexes and constraints
• demonstrable experience of DB2 expertise in a large-scale organization
• highly motivated with good analytical and problem-solving skills
• team player who is strong on collaboration and able to work effectively as part of a distributed team
• self-motivated and able to work on projects independently
• excellent written and verbal English skills

DB2 Certified Professional or comparable qualifications