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.
ELLIOTT MOSS CONSULTING PTE. LTD.
We at Elliott Moss Consultng inspire individuals and organisations to work more effectively and efficiently, and create greater choice in the work domain, for the benefit of all concerned. Our primary mission is to provide our clients with the best suitable employees who bring success to your organiza,on and allows us to grow together.