Database Administrator DB2 DBA

December 5, 2022
Application ends: February 4, 2023
Apply Now

Job Description

Location: Chennai

Experience: 1-3 Years

Interview: F2F either in Chennai or Bangalore

Notice Period: 15-30 Days

Salary: 4- 7.5 LPA

Job Requirements:

  • Expert knowledge of IBM DB2 V11.5 installations, configurations & administration in Linux systems.
  • Expert-level knowledge in Database restores including redirected restore & backup concepts.
  • Excellent understanding of database performance monitoring techniques, fine-tuning, and ability to perform performance checks & query optimization
  • Good knowledge of utilities like import, load & export under high-volume conditions.
  • Ability to tune SQLs using db2advisor & db2explain.
  • Ability to troubleshoot database issues using db2diag, db2pd, db2dart, db2top, etc.
  • Administration of database objects
  • Capability to review & assess features or upgrades to existing components.
  • Experience in validating security aspects of a confidential database.
  • Hands-on experience in SSL communication setup, strong access control, and database hardening.
  • Experience in performing productive DB recovery and validating crash recovery.
  • Experience in handling incidents & opening DB2 support tickets.
  • Experience in deploying a special build DB2 version from DB2 support.
  • Worked in environments such as 12×5 support of production database services.
  • Excellent problem-solving skills, and analytical skills.
  • Validate security aspects of a confidential database
  • SSL communication setup, strong access control; database hardening
  • Validate Crash recovery
  • perform productive DB recovery
  • On incidents open db2 support tickets
  • Deploy a special build DB2 version from db2 support

Good to have:

  • Experience in handling application servers (WebSphere, WebLogic, Jboss, etc.) is highly available Production environments.
  • Experience in maintenance, patching, and installing updates on WebSphere Servers in the Production environment.
  • Able to handle installation/deployment of the product (JAR/EAR/WAR) independently.
  • Knowledge of ITIL concepts (Service operation & transition)