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.