DB2 DBA
DB2 DBA
DB2 DBA
Requirements: -
- DB2 UDB V 9.1, 9.5, 9.7, 10.1 Installations, Configurations and Administration and production support.
- Good experience on High availability (HA) and disaster recovery (DR) experience with DB2 HADR with TSA (Tivoli system automation)
- Experience in implementing backup and recovery strategies, replication, and database performance tuning on LINUX/UNIX platform
- Database migration experience including various upgrades
- Experience in automating database maintenance and database monitoring including operational 24x7 support in troubleshooting.
- Experience in staging the new DB2 servers builds
- Knowledge of refresh activities at table level and other DB refreshes in prod/non-prod environments.
- Experience in performing database loads and unloads, tablespace containers and resize on tablespaces
- Good 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.1 and DB2V10.5 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
Apply For This Job