DB2 LUW DBA

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

Skills Required

Db2 Luw Dba, Migration, Hadr, Sql Tuning