Role: DB2 LUW DBA

Primary Skills : DB2 LUW DBA, HADR, Migration

Location: Pune, Mumbai, Chennai & Bangalore

Notice Period: Immediate to 30 days

Shift : 24X7 Rotational Shift

Responsible for ensuring all database system operational processes are managed according to established service level agreements. Specifically.
DB2 UDB V 9 , 10, 11 Installations, Configurations and Administration .
Should have strong experience on High availability (HA) and disaster recovery (DR) experience with DB2 HADR with TSA (tivoli system automation )
Should have strong experience in Database restores including Redirected restores and backup concepts
Good understanding in performance monitoring techniques and conduct performance checks to ensure the databases, and their associated applications, are continuing to support the existing Service Levels
Hands on experience in Table range partition , Multi dimension clustering , Materialized query tables
data movement utilities like IMPORT, LOAD, and EXPORT under high volume conditions.
SQL Tuning using db2advisor and db2explain tools.
Troubleshooting database issues using db2diag, db2pd, db2dart, db2support, db2top.
Database performance tuning by configuring database and instance Parameters.
Should have good knowledge on DB2 V10 and DB2 V11 new features
Administration of database objects such as indexes, tables, views, constraints, stored procedures
Administration of database users
Capacity Management and storage management
Design, test, and optimize/tune RDBMS components
Contribute to design, maintenance, and documentation of integrated database security and components in relation to SOX and SAS70 compliance
Review and assess new features or upgrades to existing RDBMS components as well as application database changes
For databases that may be supported in the future, reviews product literature to assess RDBMS differences and unique features. When possible, test new technologies and report results
Good knowledge of ITIL processes with special attention to – incident, change, problem management, Database growth & capacity management for shared environment
Troubleshooting hardware using tools like Netbackup, Avamar, Arago, Ansible