Database Administrator

DB2 UDB DBA experience between 6 to 15 years
• Should have strong working knowledge and experience on Database Upgrade (V 10.5 to 11.5 & 11.1 to 11.5)
• Should have strong working knowledge on DB2 UDB Database Administration with IBM MQ Replication
• Should have strong knowledge and experience on installation DB2 UDB and MQ S/w and Patch Management
• Should have strong knowledge and hands on experience in IBM MQ Replication and troubleshooting
• Should have strong knowledge and experience on HADR configuration and troubleshooting
• Should have strong knowledge and experience database diagnostics tools, inbuilt, DMC
• Should have strong knowledge and experience in backup, restore and recovery strategies
• Experience in Performance Tuning, Query Optimization, index creation, partition creation and management and other related monitoring, troubleshooting tools
• Creation of DB objects, logical and physical storage, storage groups etc.
• Replication Monitoring
• Granting and Revoking Users / Groups authorizations
• Data movement utilities
• Restore and Recovery strategies
• Capacity planning
• Ability to troubleshoot the issue and handle the situation whenever required
• Should have good knowledge on ITIL (Problem, Change and Incident Management process)
• Knowledge on Backup strategy and Disaster recovery is strongly recommended
• Should have Scripting knowledge and experience to automate routine tasks.
• Knowledge in Performance Tuning, Query Optimization, index, partition addition, deletion etc.