- New/modify/delete of account in databases
- Create schema and/or database tables
- Hosting covers:
- Weekly schema object sizing
- Daily monitoring of data block organization, physical storage and contention, table space utilization
- Application is based on Development / Projects
- Download file to disk
- New or revised database design
- Database creation activities and changes as required by the application
- Index creation
- Export or import (of data)
- Providing functional guidance to the systems programmer and the operator
- User management and access review
- Providing functional guidance to the systems programmer and the operator
- Provide this functional guidance to the Operating System Administrator
- Implementation of new database services, tuning, reorg and establishing relevant processes
- S hall be responsible for capturing performance issue using performance tuning advisor and scripts and develop solutions to remove bottlenecks.
- Policy based performance tuning using standard automation tools. Corrective actions will be carried out when these tools indicate resource usage above defined thresholds
- Monitoring of events from applications, databases, and related components / platforms
Do you fit the profile
We are looking for IMS Data Base expert to work with our product and infrastructure teams to support and maintain our mainframe databases.
- 9+ years of experience .
- Good experience in IMS DB with
- DBD/PSB/ACB creation/changes
- DB Monitor and resizing
- DBRC Maintenance
- IMS system upgrades
- Experience in Development (DEV/Test/ACPT/PROD) Support for one-time deliveries
- Environment Refresh
- Troubleshooting, incident resolution, change implementations
- Project Support
- OPC schedule updates for yearly refresh .
- IMS version upgrades
- Deployment Activities
- LOCAL Tool (Generate JCL)
- Ready to work in 24x7 delivery model (with on call)
- Behaviors
- Embracing an agile mindset
- Customer-Centricity and Design Thinking
- Good social and communication skills.
- Being curious, a quick learner and having a structured and analytical mind-set
- Being willing to innovate and take on new challenges.
- Being result oriented and striving for improvements.
- Positive attitude and being motivating and energizing
- Copes with change and decides well without having the total picture
