01Overview
Job ID:202433
Required Travel: Minimal
Managerial - No
Location:India
- Pune (Amdocs Site)
Who are we :
In one sentence:
The DB administrator is handling physical and applicative database administration activities supporting end 2 end life cycle of product from database perspective
What will your job look like :
- Ensure database resources are sized accurately and a design strategy is developed to make sure that the database is maintained at a healthy size.
- You will perform routine DBA tasks like database maintenance, backups, recovery, table space management, upgrades, etc.
- You will execute periodic health checks for databases and recommend changes that should be executed in the production environment to ensure effective performance.
- You will interact and work with multiple infra and IT teams as part of environment setup, maintenance and support
- You will work closely with developers, assist them with database structure design as of business needs (e.g. indexes, constraints, integrity)
All you need is.:
- DB2 DBA on Mainframe(Z/OS):
- DB Objects - Experience in creating and modifying DB2 objects - Database, Storage Group, Tablespace, Tables, Views, Indexes, etc.
- Experience with DB2 commands: - Stop/Start Databases, Display command, Cancel thread and Term & Display utility, others.
- Hands on experience on DB2 utilities: Reorg and Runstat, Backup and Recovery of Table spaces (copy & recover), Repair, Load/Unload utilities.
- Ability to bind/rebind the Plans/Packages and Granting required accesses to Packages/Plans/Collections.
- Experience in Database Monitoring.
- Experience in Database replication - IBM DB2 Data Propagator
- DB2 administration - Strong Troubleshooting skills
- DB2 privileges and RACF
- z/OS - TSO, ISPF, JCL.
- Tools - DB2 Admin tool, QMF, FileManager, Changeman, ESP.
Why you will love this job:
- Drive growth by constantly looking for opportunities to bring more value to new and existing customers. Calling upon your superb communica .
