Db2 Database Administrator

Tekskills Inc.; Chennai; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Tekskills Inc. in Chennai seeks a Mainframe DB2 System Admin/System Programmer with 7+ years of experience to install, customize, and optimize DB2 and data replication products. You will manage large SysPlex environments and work on incident/problem management, DR, and performance tuning.

The role requires strong problem diagnosis skills, ability to work independently or as part of a team, and a proactive approach to improving and stabilizing critical mainframe platforms.

Qualifications

• 7+ years of experience with Mainframe DB2 installation/customization.
• Experience with large systems in SysPlex environments.
• Strong problem diagnosis for system and application areas.
• Able to work independently or as a team with DBAs.

Responsibilities

• Perform mainframe DB2 upgrades and tuning to support environments.
• Establish DB management policies for DR, security, and utilization.
• Analyze new DB2 versions for performance improvements and cost reduction.
• Collect, analyze, and tune DB2 performance data.
• Lead project and internal initiatives as assigned.
• Participate in incident and problem management for DB2.
• Diagnose problems and manage changes; collaborate with IT teams.
• Provide 24/7 on-call support for mainframe infrastructure.
• Develop and maintain runbooks and operational documentation.

Skills

Mainframe DB2

Data replication

SysPlex

Troubleshooting

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

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