Mainframe Database Administrator

Mainframe Database Administrator

Tech Tammina LLC

Job Description

Production support experience in database administration of DB2, ADABAS, Natural, IMS & CA-Datacom

Production support of all database issues and integration jobs

Production support for DB2 & Direct Connect

Provide on-call 24/7 Incident Response to database issues from production monitoring tools, Command Center personnel and Application Development Analysts

Generate DDM for ADABAS

Optimize DB2 resource utilization by tuning queries (static and dynamic), making appropriate index recommendations and configuration parameter changes

DB2 Connect 64-bit client installs

Handle IMS Resource Lock Manager messages

Participate in Disaster Recovery Exercise

Continuously monitor database performance and take steps pro-actively to ensure a good database performance

Installation, testing and deployment of IMS maintenance and upgrades

Installation, testing and deployment of z/OS OEM software maintenance and upgrades

Installation, testing and deployment of DB2 and/or CICS maintenance and upgrades

Installation, testing and deployment of CA-Datacom maintenance and upgrades

Create policies, standards and procedures for the database system support and usage

Interface with external partners, customers and vendors

Qualifications

Knowledge of IMS system internals

Knowledge 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, DBCTL

Additional Information

Job Status: Full Time

Eligibility: GC or US Citizens