– IBM DB2 LUW Database Administrator / Architect

Experience: 8–10 Years

Location: Bangalore

Role Overview

We are looking for an experienced IBM DB2 LUW Database Administrator / Architect with strong expertise in DB2 architecture, database administration, performance tuning, and solution architecture. The candidate should have hands-on experience with DB2 on Red Hat Linux, HADR configuration, Pacemaker setup, and database backup and recovery.

Must-Have Technical Skills

- Experience installing and configuring different versions of IBM DB2 LUW on Red Hat Linux.
- Strong knowledge of Linux and shell scripting, including script scheduling.
- Expertise in DB2 architecture, administration, and solution architecture.
- Hands-on experience generating DDLs using the db2look command.
- Experience using RUNSTATS, REORGCHK, and REORG for application performance optimization.
- Knowledge of high-volume data movement utilities: IMPORT, LOAD, and EXPORT.
- Experience with query tuning using db2advis and db2explain.
- Database performance tuning through database and DBM configuration parameters.
- Hands-on experience configuring and monitoring HADR databases.
- Experience with Pacemaker setup for HADR.
- Knowledge of database security, backup and recovery, and capacity planning.
- Experience performing DB2 restores,



including redirected restores in production environments.

Roles and Responsibilities
- Perform day-to-day DB2 database administration, including security, backup/recovery, capacity planning, and performance tuning.
- Conduct feasibility studies for database installation and configuration.
- Monitor database performance and recommend improvements for operational efficiency.
- Manage capacity planning, space utilization, and database maintenance activities.
- Implement database enhancements and modifications based on requirements.
- Perform daily and weekly database backup and recovery tasks.
- Assist with implementing current database features and program fixes.
- Maintain database security and disaster recovery procedures.
- Troubleshoot and maintain multiple databases.
- Monitor databases for errors, locks, failed updates, and other operational issues.
- Manage database user accounts, logins, and permissions.
- Configure, monitor, and troubleshoot HADR environments.
- Support DB2 architecture design and solutioning.

Additional / Preferred Skills
- IBM DB2 pureScale implementation experience.
- Strong understanding of high availability and disaster recovery solutions.
- Experience in architecture design as well as database administration.

📌 Database Administrator (Bengaluru)
🏢 Volto Consulting
📍 Bengaluru