Role : IT IS_AMS_Mainframe_DB2 AdministrationExperience : 7 to 15 years Location : Bangalore/MumbaiKey skills : z/OS Db2 v13 Database AdministrationDesired Competencies (Technical/Behavioral Competency)Must-HaveExperience in Mainframe Db2 v12/ v13 Database System-Administration on z/OSDB2 installation, upgrade, patching, configuration and operationsProficiency in DB2, VSAM Systems Performance Tuning and Capacity PlanningExperience in Data Sharing setup in Parallel Sysplex environmentKnowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9Experience in SMPE and ISV tools installation and migration Good-to-HaveDatabase DR, Cloning, Backup/Recovery, HA and Point In Time Recovery (PITR) expertiseExperience with Database ISV Tools and Products like OmegaMon and AdminToolApplication related performance tuning; Write, modify, and debug database specific SQL queriesDBA related utilities like Unload, Load, DSNJU003, DSNJU004,Reorg, Runstats, image copyREXX, CLIST, JCL, JES and Assembler knowledgeSNResponsibility of / Expectations from the Role 1Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements 2Recommend operating system and database performance monitoring, tuning and configuration changes3Experience with database physical and logical design, query analysis and optimization4Provide technical assistance and subject matter expertise to applications groups. Provide database storage management and capacity management recommendations
Job Title
IT IS_AMS_Mainframe_DB2 Administration