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.
