Lead Database Administrator - DB2 | 3M-TCOE

Job Description

  • Job Title IT Software - DBA, Datawarehousing
  • Salary 2,750,000 INR

School Degree

Description

Position Summary

This Database Admin position is part of the Core Infrastructure Delivery Data Platform Delivery team. Under general direction they will participate in the daily management and administration of DB2 databases on both open systems and IBM zOS. Key responsibilities include responding to incidents and changes, monitoring DB2 activities and troubleshoot accordingly, and escalating critical issues to appropriate teams. This role requires technical and communication skills as well as a level of comfort working with diverse teams.

Job Description & Responsibilities:

  • Accept and process incidents that are assigned to DB2 LUW support team within the SLA
  • Escalate Incidents to appropriate teams.
  • Monitor daily backups for DB2
  • Provide support during storage addition and migrations
  • Maintain archive logs and cleanup as per policy.
  • Basic performance tuning.
  • Diagnoses application or database contention issues
  • Run application snapshot when needed by SAP for diagnoses
  • Manage HADR and TSA issue
  • Idle session monitoring
  • HADR takeovers
  • Restart database and Instances
  • Work with Basis team to verify connectivity
  • Start/Stop/Move Virtual IP address
  • Start/Stop TSA domain
  • Turn off or On Monitoring for Specific databases
  • Recovery and support in DR test
  • Creating Table spaces for Lower environment server if application team is not able to perform during their upgrade process.
  • Raising request to add space in data file system.
  • Deleting trigger for Lower environment server if application team is not able to perform during their upgrade process.
  • Deleting records as per instruction given by application team.

Experience Required:

  • Required 8-10 years of experience supporting DB2 on RHEL and/or zOS including stand-along and HADR configurations
  • Demonstrated ability to grasp and communicate complex system integrations
  • Demonstrated ability to work on projects in a technical environment

Experience Desired

  • Experience working in a large environment or on customer-facing applications
  • Experience working in an Agile environment
  • Experience working with ERP systems, SAP preferred
  • Experience with Cloud, AWS preferred
  • Experience in ODBC connections
  • Education and Training Required
  • Bachelors Degree in information systems or equivalent experience

Primary Skills:

  • Strong analytical skills
  • Data analysis and interpretation
  • Documentation and process flows
  • Good oral/written communication skills
  • Time management
  • Additional Skills:
  • 3rd party backup utilities, i.e., Commvault
  • ETL or other data extraction/manipulation
  • Required 8-10 years of experience supporting DB2 on RHEL and/or zOS including stand-along and HADR configurations
   
Apply

There is something wrong with this job ad? Report the error