AWS IBM DB2 Database Administrator

About the client

A confidential client in technology. The company is named to you once you and the recruiter have spoken.

The role

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.

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.

You

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

On offer

• Full-time role
• Notice period ≤ 90 days

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.