Db2 Database Administrator

Tekskills Inc.; Delhi; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Tekskills Inc. is seeking a Mainframe DB2 System Admin/System Programmer to manage and optimize DB2 environments across large-scale systems.

The role requires hands-on experience with DB2 upgrades, tuning, disaster recovery, and security, with a focus on performance and cost reduction. The ideal candidate will demonstrate strong problem-determination skills, the ability to work independently and within a team of infrastructure DBAs, and a high level of initiative to improve and optimize

Qualifications

• 7+ years of experience installing and/or customizing Mainframe DB2 products.
• Experience with large systems in data sharing SysPlex environment.
• Strong problem-determination skills in both system and application areas.
• Able to work both as an individual and as a team member with infrastructure DBAs.

Responsibilities

• Perform mainframe database software upgrades and tuning to support DB2 environments.
• Establish policies and procedures for database management, disaster recovery, security, maintenance and utilization.
• Analyze new DB2 versions for features that improve performance and reduce cost.
• Perform performance data collection, analysis, and tuning of DB2 systems.
• Collaborate with IT teams, users and vendors to guide project implementations.
• Provide 24x7 on-call support for Mainframe infrastructure.
• Develop and maintain operational documentation, run books, and best practices.

Skills

Mainframe DB2

Data replication

SysPlex experience

Problem determination

Team collaboration

Initiative

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

Added Advantage

• 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 management
• Collaborate 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