Db2 Database Administrator

Tekskills; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Tekskills in Bengaluru, India, is seeking an experienced Mainframe DB2 System Admin/System Programmer to manage DB2 environments, upgrades, tuning, and on-call support. The role requires deep expertise in DB2, SysPlex, and data replication.

You will collaborate with DBAs and IT teams to implement policies, DR, security, and optimization, contributing to stable, high-performance mainframe operations in a 24/7 production setting.

Qualifications

• 7+ years of experience installing and/or customizing Mainframe DB2 products.
• Experience with data replication product suites.
• Experience with large SysPlex environments.
• Strong problem determination in system and application areas.
• Ability to work independently and with DBAs.
• High initiative to improve and optimize solutions.

Responsibilities

• Perform mainframe database software upgrades and tuning for DB2 environments.
• Establish policies and procedures for database management, disaster recovery, security, maintenance, and utilization.
• Analyze new DB2 versions for performance improvements and cost reduction.
• Perform performance data collection and tuning of DB2 systems.
• Executes project and internal initiatives as assigned.
• Participate in incident and problem management for application and DB2.
• Provide 24/7 on-call support for Mainframe infrastructure.
• Develop operational documentation, run books, and best practices.
• Implement tools and procedures to maintain a very stable environment.

Skills

Mainframe DB2

SysPlex

Data replication

Problem determination

Team collaboration

On-call support

Job description

Mainframe DB2 System Admin/System Programmer

Primary Skills

• Have 7+ years of experience of installing and/or customizing software products Mainframe DB2 and/or data replication product suite
• Experience working with large systems in data sharing SysPlex environment
• Has thorough knowledge of resources available and demonstrated ability to use the resources for problem determination, product enhancements and other technical issues related to the components being administered
• Strong problem determination skills in both system and application areas
• Able to work both as individual and as a team member with other subject matter experts and infrastructure DBAs
• A high level of personal initiative is a must to help us improve and optimize the solutions

Secondary Skills

• Preferred experience with IDAA, IDAA Bulk Loader, and CDC Replication
• Experience with design, configuration and support services to production and development departments running critical and 24*7 applications

Job Description

• Perform mainframe database software upgrades coupled with administration and tuning to support DB2 environments
• Establishment of policies and procedures pertaining to database management, Disaster recovery, security, maintenance and utilization
• Analyzing new versions of DB2 for functionality that can improve systems performance and reduce cost
• Perform performance data collection, analysis, and tuning of DB2 systems
• Executes project and internal initiative responsibilities as assigned or delegated
• Participate in incident and problem management activities related to application and DB2
• Perform problem diagnostics and resolution as well as change managementCollaborate with other team members within same Information Technology (IT) departments, functional users and vendors to provide guidance and manage project implementation
• Provide 24*7 on-call support Mainframe Infrastructure
• Develop and maintains operational documentation, best practices, and run books for the operational platform
• Implement tools and procedures required to maintain a very stable environment