MainFrame DB2 DataBase Administrator

  • Bengaluru
  • Tata Technologies

o Good experience in DB2 with

§ Creation of new DB objects

§ Providing access to Group id's in XDEV/IGRT/DEVE/ACPT/PROD

§ Cleanup of existing individual id's

§ Maintenance of objects in all Env.

§ Environment Refresh

§ Troubleshooting, incident resolution, change implementations

§ Deployments related to PROD environment changes

§ Application operations and maintenance for app DB, deadlocks, connections/sessions analysis, RCA

§ Schema level issues during database upgrades and

§ schema Troubleshooting Assistance.

§ Performance optimization & implementation with help from Supplier teams & provide suggestions to Customer from DB perspective.

§ DB recovery operations during outage/disaster (included if it is caused by bug or failure on the infrastructure).

§ Coordinate with SRM & Supplier infra teams (internally), and customers during DB issues

§ Suggestion on creating and executing scripts on schema level for performance tuning, query optimization.

§ BIND or REBIND of packages

§ DB2 version upgrades support

o Exposure with DL1 database

o Ready to work in 24x7 delivery model (with on call)