Job Description
– 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 new 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.
• Solid understanding of high availability and disaster recovery solutions.
• Experience in architecture design as well as database administration.

📌 Database Administrator (Bengaluru)
🏢 Volto Consulting
📍 Bengaluru