Db2 Database Administrator
- Lauren Information
- 3 - 6 years
- Mumbai
- 5 months ago
- Email to a friend
- Report this job
Job Description
Role & responsibilities
We are seeking a highly skilled and experienced DB2 Database Administrator to manage the full lifecycle of DB2 environments across distributed platforms. The ideal candidate will have deep technical expertise in DB2 database administration, including installation, configuration, upgrades, performance tuning, troubleshooting, and migration. Proficiency across multiple operating systems and DB2 versions is essential, as is experience with HA/DR setups and infrastructure optimization.
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.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: Lauren InformationLocation(s): Mumbai
Keyskills: Db Administration Installation Configuration Hadr Migration Performance Tuning Troubleshooting Upgrade Aix HACMP Replication RHEL IBM DB2 Mq Series
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in