Job details – Audax Labs

Back to Career

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