DB2 DBA/ DB2DBA LUW

Quess IT Solutions; Bengaluru; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Quess IT Solutions seeks an experienced DB2 LUW DBA to join our team in Bengaluru. You will install and configure DB2 across versions on Red Hat Linux, tune performance, and manage high-volume data movement with IMPORT/LOAD/EXPORT. You will leverage DB2LOOK to generate DDL, and tune using RUNSTATS, REORG and db2explain/db2advisor.

HADR configuration and monitoring, including Purescale considerations, are expected. The role combines architecture and administration responsibilities.

Qualifications

• Experience on installation of different versions of DB2 on Redhat Linux Environment.
• Good knowledge of Linux.
• Scheduling shell scripts on LINUX environments.
• Good experience in generating DDL's using DB2LOOK command on existing database and its objects.
• Use RUNSTATS, REORGCHK and REORG to enhance application performance.
• Good knowledge on data movement utilities like IMPORT, LOAD, and EXPORT under high volume conditions.
• Tuning using db2advisor and db2explain tools.
• Database performance tuning by configuring database and DBM Parameters.
• Configuring the HADR and monitoring the HADR databases. Purescale implementation desired
• DB2 architecture and Administrator, solutioning of Architecture. LUW, pacemaker setup(HADR) 6 to 12 both Designer and Administrator.

Responsibilities

• Install and configure DB2 LUW on Red Hat Linux environments.
• Tune DB2 performance using RUNSTATS, REORG, REORGCHK, and db2explain/db2advisor.
• Manage data movement via IMPORT, LOAD and EXPORT for high-volume workloads.
• Monitor HADR environments and configure HADR/Purescale setups where required.
• Generate DDL and manage objects using DB2LOOK and related tools.

Skills

DB2 LUW

Linux

Shell scripting

Performance tuning

HADR monitoring

Tools

DB2LOOK

RUNSTATS

REORG

IMPORT

LOAD

EXPORT

db2advisor

db2explain

Job description

IBB DB2 LUW- i.e Database administrator of DB2.Experience on installation of different versions of DB2 on Redhat Linux Environment

Good knowledge of Linux

Scheduling shell scripts on LINUX environments

Good experience in generating DDL's using DB2LOOK command on existing database and its objects.

Use RUNSTATS, REORGCHK and REORG to enhance application performance.

Good knowledge on data movement utilities like IMPORT, LOAD, and EXPORT under high volume conditions.

Tuning using db2advisor and db2explain tools.

Database performance tuning by configuring database and DBM Parameters.

Configuring the HADR and monitoring the HADR databases. Purescale implementation desired

DB2 architecture and Administrator, solutioning of Arctitecture. LUW, pacemaker setup(HADR) 6 to 12 both Designer and Administrator.