DB2 Database Admin

Roles and Responsibilities: Set up and support HA/DR solutions/ replication Lead efforts related to system and SQL performance tuning, index/ partition creation and management Set up log shipping, Mirroring/log forwarding, analyzing traces Architect, Design, Implement, Administer database consolidation platforms Perform duties including monitoring, software installs and upgrades, scripting, automation, incident response and documentation Perform DB restores and point-in-time recovery If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you! IBM DB2 experience, with advanced knowledge in the following: o Bufferpool/ memory management o DB2 internal structures o Tablespace/Page structures o Backup/recovery/logging facilities and strategies o DB2 locking o DB2 tracing o Database diagnostic tools Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. Hands on experience in Performance Tuning, Query Optimization, monitoring and troubleshooting tools. Solid understanding of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively