Mainframe Database AdministratorTech Tammina LLCJob DescriptionProduction support experience in database administration of DB2, ADABAS, Natural, IMS & CA-DatacomProduction support of all database issues and integration jobsProduction support for DB2 & Direct ConnectProvide on-call 24/7 Incident Response to database issues from production monitoring tools, Command Center personnel and Application Development AnalystsGenerate DDM for ADABASOptimize DB2 resource utilization by tuning queries (static and dynamic), making appropriate index recommendations and configuration parameter changesDB2 Connect 64-bit client installsHandle IMS Resource Lock Manager messagesParticipate in Disaster Recovery ExerciseContinuously monitor database performance and take steps pro-actively to ensure a good database performanceInstallation, testing and deployment of IMS maintenance and upgradesInstallation, testing and deployment of z/OS OEM software maintenance and upgradesInstallation, testing and deployment of DB2 and/or CICS maintenance and upgradesInstallation, testing and deployment of CA-Datacom maintenance and upgradesCreate policies, standards and procedures for the database system support and usageInterface with external partners, customers and vendorsQualificationsKnowledge of IMS system internalsKnowledge of, and experience using IMS commands to start and stop IMS, alter bufferpools, perform recovery, list threads and determine their status, and manipulate IMS connections with other subsystems (including CICS, IMS, DB2 and other database systems)Knowledge of mainframe infrastructure to include experience or familiarity with IBM mainframe tools and jobs: TSO, JCL, SDSF, ISPF, CICS, IMS/DB, IMS/DC DB2, z/OS, WLM SMP/E, IDCAMS, IEBCOPY, DBCTLAdditional InformationJob Status: Full TimeEligibility: GC or US Citizens