Database Administrator (DB2)Database Administrator (DB2)

Job Description

. We are seeking an experienced Application Database Administrator (DBA) with strong expertise in Mainframe DB2 on z/OS administration and data migration.

. The role is responsible for database setup, administration, performance monitoring, backup and recovery, database design reviews, SQL tuning, and operational support.

. The ideal candidate will have hands-on experience in migrating data from Mainframe DB2 on z/OS to flat files using scripts or tools within the mainframe environment and ensuring database reliability, performance, and compliance with governance standards.

Key Responsibilities

. Administer and support Mainframe DB2 on z/OS databases in production and non-production environments.

. Perform database setup, configuration, maintenance, backup, recovery, and disaster recovery activities.

. Plan and execute database migrations, including migration of data from Mainframe DB2 on z/OS to flat files using scripts or mainframe tools.

. Monitor database performance, availability, and capacity proactively identify and resolve issues.

. Analyze and tune SQL queries and database objects to improve application performance.

. Review database designs and recommend improvements to data models based on business and application requirements.

Required Skills & Experience

. Minimum 4+ years of experience as a Mainframe DB2 on z/OS Database Administrator.

. Strong expertise in DB2 for z/OS database administration, support, and maintenance.

. Hands-on experience in data migration from Mainframe DB2 on z/OS to flat files using scripts, utilities, or mainframe tools.

. Experience with database backup, recovery, disaster recovery planning, and implementation.

. Strong knowledge of database design, data modeling, and SQL performance tuning.

. Experience in database monitoring, troubleshooting, and performance optimization.