Senior DB2 Administrator - RHEL/HADR (5-11 yrs)

Position : DB2 Admin

Company : 30 Yrs old IT MNC Co.

Job Location : Bangalore

Notice Period : 15 days max.

Exp. : 6+ in DB2 Admin

Job Description :

- Mandatory DB2 DBA as primary Skills:

- Minimum of 6-10 years for experience with db2 database design, Installation, Upgrade, Patching, administration and maintenance in distributed environments.

- Strong hands-on exp on most of the DB2 database versions and its features.

- Strong DB2 Database Administration and troubleshooting skills.

- Experience in upgrading Various db2 version to the latest.

- Experience in migrations and upgrade of database in heterogeneous platform.

- Strong hands-on exp on of DB2 Utilities like Load/ Explain/ Reorg/ Runstats/ db2top/ db2advis/ db2icrt/etc.

- Strong hands-on exp on upgrading in place and out of place upgrades.

- Exp upgrading from db2 8.0 to latest 11.5 pure scale and non-pure scale.

- Exp upgrading from db2 10.5 to 11.5 pure scale and non-pure scale.

- Experience on upgrading db2 9.7.400.501 to 11.5 on windows 2008R2Enterprise

- Experience rollback, downgrade in case of upgrade and patch failures,

- Strong experience in SQL Performance tuning as per application requirement.

- Experience in DB2 Database Administration on various OS including LUW like RHEL, AIX,Z/os, Windows(2008/2012),Linux etc.

- Candidate should be well versed with recent new db2 features and suggesting client accordingly.

- Very strong experience in applying install fixpacks, interim fixpacks.

- Hands on exp in HACMP/HADR backup/restore, replication and Import/Export and ingest utility and cloning.

- Extensive experience in TSM Infrastructure. Knowledge on Storage and Network configuration.

- Experience in setting up monitoring as per best practice for databases.

- Exp in unix scripting, to fix or automate repeative activities

- Additional databases experience like oracle, postgres, mysql more advantage.

- Exp in dev-ops- tooling would be handy, some experience of git, Jenkins, Docker