Db2 Database Administrator

Lauren Information Technologies

3 - 6 years

3 - 7 Lacs

mumbai

Posted:None| Platform:

Apply

Skills Required

db administration installation configuration hadr migration performance tuning troubleshooting upgrade aix hacmp replication rhel ibm db2 mq series

Work Mode

Work from Office

Job Type

Full Time

Job Description

Role & responsibilities

DB2 Database Administrator

Key Responsibilities:

Design, installation, upgrade, patching, administration, and maintenance of DB2 databases in distributed environments.
Strong hands-on experience with most DB2 database versions and their features.
Solid DB2 database administration and troubleshooting skills.
Experience in upgrading various DB2 versions to the latest releases.
Experience in database migrations and upgrades across heterogeneous platforms.
Strong hands-on experience with DB2 utilities such as LOAD, EXPLAIN, REORG, RUNSTATS, db2top, db2advis, db2icrt, etc.
Proficient in both in-place and out-of-place DB2 upgrades.
Experience upgrading from DB2 8.0 to the latest 11.5 (PureScale and non-PureScale).
Experience upgrading from DB2 10.5 to 11.5 (PureScale and non-PureScale).
Experience upgrading DB2 9.7.400.501 to 11.5 on Windows 2008 R2 Enterprise.
Experience in rollback and downgrade procedures in case of upgrade or patch failures.
Strong expertise in SQL performance tuning based on application requirements.
DB2 database administration experience on various operating systems including RHEL, AIX, z/OS, Windows (2008/2012), and Linux.
Well-versed in recent DB2 features with the ability to advise clients accordingly.
Extensive experience applying fix packs and interim fix packs.
Hands-on experience with HACMP, HADR, backup/restore, replication, import/export, ingest utility, and database cloning.
Extensive experience with TSM infrastructure; knowledge of storage and network configuration.
Ability to resolve high availability issues related to HADR, MQ Series, and replication methods.
Experience setting up monitoring in accordance with database best practices.

More Jobs at Lauren Information Technologies

Desktop Support Engineer 1

Gandhinagar, Ahmedabad, Vadodara

1.0 - 3.0 yrs

INR 1 - 2 Lacs

Sr. VIP Support Engineer

mumbai, mumbai suburban, mumbai (all areas)

4.0 - 8.0 yrs

INR 1 - 6 Lacs

Google Workspace Support Engineer

mumbai, mumbai suburban, mumbai (all areas)

10.0 - 17.0 yrs

INR 5 - 15 Lacs

Db2 Database Administrator

mumbai

3.0 - 6.0 yrs

INR 3 - 7 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.