HyperWrkan Albireo Recruiters platform
Confidential · Technology

AWS IBM DB2 Database Administrator

  • Bengaluru · Office
  • 6–12 yrs
  • CTC Not disclosed
  • Full-time
  • Notice ≤ 90 days
  • Posted today
Apply Apply Save

By applying you agree that Albireo Recruiters shares your profile with this client for this role and keeps it for its recruiting. Privacy policy.

A technology company in Bengaluru is hiring an IBM DB2 LUW Database Administrator with 6 to 12 years of experience. The role covers DB2 installation on Red Hat Linux, backup and recovery, performance tuning, and HADR. The work is in the office and includes on-call production support.

The role

This is a full-time role for an IBM DB2 LUW Database Administrator in Bengaluru. You will work in the office as part of a database team. The role covers the day-to-day administration of DB2 databases, including security, backup and recovery, capacity planning and performance tuning.

Your day will include monitoring database performance and recommending improvements. You will check databases for locks and failed updates, manage logins and permissions for users, and plan space and data maintenance. You will also run daily and weekly backups, carry out redirected restores when needed, and help implement new features and fixes. You will support production systems on call and work across different time zones.

We are looking for hands-on experience installing DB2 versions on Red Hat Linux. You should know how to schedule shell scripts on Linux and use RUNSTATS, REORGCHK and REORG to improve performance. Experience with IMPORT, LOAD and EXPORT under high volume, DDL generation with db2look, and tuning with db2advis and db2expln is needed. You should also be able to configure and monitor HADR.

Good knowledge of database security standards is required. Knowledge of AWS or other cloud platforms is an added advantage. Experience with DB2 pureScale, Pacemaker setup for HADR, or DB2 architecture and solution design will also help. You should communicate clearly, be a good team player, and be flexible in your approach.

To apply, sign in on hyperwrk.com and apply in one step. A recruiter at Albireo reads every application.

Must have

  • IBM DB2 LUW database administrator
  • Installation of different versions of DB2 on Redhat Linux; good knowledge of Linux
  • Scheduling shell scripts on LINUX environments
  • Use RUNSTATS, REORGCHK and REORG to enhance application performance
  • Data movement utilities like IMPORT, LOAD, and EXPORT under high volume
  • Configuring the HADR and monitoring the HADR databases
  • Tuning using db2advisor and db2explain tools
  • DB restores including Redirected restores on production

Nice to have

  • Purescale implementation desired
  • pacemaker setup (HADR)
  • cloud knowledge is an added advantage
  • Knowledge of applicable Security standards for Databases

What happens after you apply

The recruiter working this role reads your application. If it fits, they call you before anything is shared with the company. You see every stage in your account, in plain words.