DB2 Admin

Job Description

Job Title: DB2 Database Administrator Location: Bangalore Job Type: Full-Time Experience: 3 to 5 Years Job Summary: We are seeking a skilled and proactive DB2 Database Administrator to manage and support our enterprise database environment. The ideal candidate will be responsible for day-to-day operations (BAU monitoring), database deployments, performance tuning, maintenance, and disaster recovery (DR) preparedness. This role requires a strong understanding of IBM DB2, IBM CDC, and associated technologies, along with the flexibility to support 24/7 operations on a rotational basis. Key Responsibilities: Perform daily monitoring and routine health checks of DB2 databases across AIX, Linux, and Windows platforms. Plan and execute scheduled maintenance activities, database upgrades, and performance tuning. Manage and deploy database objects and scripts across environments, including production promotions. Implement and maintain database backup and recovery strategies, including DR drills and documentation. Support database replication using IBM CDC and troubleshoot replication issues. Generate and deliver periodic reports – daily, monthly, quarterly – covering system health, capacity, and performance. Coordinate and support vulnerability assessments (VAPT) and apply necessary remediation. Provide incident management support, root cause analysis, and timely resolution of database issues. Collaborate with application, infrastructure, and security teams for integrated solutions and deployments. Participate in on-call rotation and provide 24/7 support for critical issues and planned activities. Required Skills & Technologies: Strong experience with IBM DB2 (LUW and/or z/OS) database administration. Hands-on experience with IBM InfoSphere CDC (Change Data Capture) . Proficient in AIX , Linux , and Windows environments. Experience with database monitoring tools and incident management systems . Familiarity with JDBC connectivity , application integration, and troubleshooting. Exposure to Kafka for real-time data integration is a plus. Scripting knowledge (Shell, Python, or SQL) for automation and reporting. Additional Information: Role involves rotational shifts and on-call support as part of 24/7 operations. Excellent analytical, problem-solving, and communication skills required. Must be able to handle multiple tasks and priorities in a dynamic environment.