This job ad has been posted over 40 days ago...


Full-time IMS DBA Consultant

at ethan_william in Indiana

Job Title              :  IMS DBA Consultant

Work Location :  Indianapolis IN

Duration             :   Long Term


Job Description:


Experience Level: 7+ Years of Experience Technical Competency

IMS z/OS Database Administration Job/Role Description:

·         Good experience in the administration of IMS for z/OS     

IMS Version 9 and 11

·         Familiarity with Mainframe tools , Programs, utilities, TSO, ISPF,


Analyze, develops, tests and implements database designs in support of client

area technology requirements.

·         Perform data modeling logical and physical database design

·         Capacity planning , backups and recovery

·         Know different kinds of IMS databases: HDAM, HIDAM, Partition

Database, GSAM, HISAM, etc

·         Know all IMS process modes: DLI, BMP, and MPP

·         Database definition ?DBDs, Segments, Records, Pointers, Sequence

fields, PCB, PSB, ACB Load/Unload, different kind of reorganization,

·         Primary and Secondary Indexes. Logical database relations

·         Sound experience in database creation.

·         Good command of writing complex DLI Code

·         Sound experience in gathering information for corrective actions to

maintain database performance and efficiency.

·         Sound Performance tuning experience, including DLI code and DB,

·         Sound knowledge with IMS Administration and Usage and IMS High

Availability Database Conversion Aid.

·         Monitoring and maintaining database security on corporate

application systems.

·         BMC (any IMS tools) and IBM tools experience along with HALDB DB

·         Facilitating sharing of common data by overseeing proper key

management and the data dictionary.

·         BMC and other third-party database performance, monitoring, and

system status products, Datamanager Data Dictionary or other meta-data

repository preferred.

·         Maintaining the availability and integrity of databases(24 7).

·         Database capacity planning (like storage capacity and backup

capacity) and proven track record of proactive data capacity planning and


·         Meta-data repository experience a plus and

·         Experience with database design, modeling, and implementation of

new structures

·         Developing data models and database design with integration with

other development teams and also develop the entity relationship models.

·         Ensure that all database structures, data definitions, copybooks,

programs, JCL, reports, transactions, terms and data elements (or meta data)

within sphere of responsibility is managed on the Data Dictionary

(Datamanager). ·         Maintain the rules for references identifying usage

and change relationships within the Data Dictionary.

·         Database migration and Data Refresh activities across various sub


·         Good knowledge of Change Management process is required.

·         Good command to process requests for modifications to existing

database structures.

·         Good understanding of Disaster Recovery solutions including

designing, configuring and ongoing support is preferred

·         Good oral and written communication skills, especially in

communicating with the customer and escalating issues is desired

·         24x7 Production Support experience and willingness to provide 24x7

support preferred

·         Good troubleshooting skills and ability to display analytical

thinking for problem solving is preferred.

·         A high level of technical expertise coupled with the ability to

coordinate, consult and review database efforts while arbitrating conflicts of

differing and contradicting requirements.

·         Willingness to work as a team and the desire to mentor juniors to

raise their competency and knowledge is strongly desired

·         Willingness to work on teams which use continuous improvement

methodologies to improve customer satisfaction is desired

·         Relevant certification is preferred

·         Provided the day-to-day support and administration activities of

DB2/IMS subsystems across various LPARS of Z/OS mainframe systems.

·         Worked in BMC  tool to Monitor IMS jobs(preferably BMC Mainview)

and RECON dataset.

·         Should have experience in Image copy, Load, unload, Reorg etc.

·         Involved in migration activities from IMS Ver10 to Ver11


Reference : IMS DBA Consultant jobs

Recent jobs at ethan_william
Full-time Java/J2EE Developer at ethan_william in Georgia 10-31-2017
Full-time EDI Analyst With Axway at ethan_william in Virginia 10-31-2017
Full-time Java Front End Developer at ethan_william in California 10-31-2017
Full-time EDI Analyst With Axway, Norfolk, VA ,Long Term at ethan_william in Virginia 10-31-2017
Full-time EDI Analyst With Axway at ethan_william in Virginia 10-27-2017

« Go back to category
Is this job ad fake? Report it!   
Recommend to a friend
Published at 10-05-2017
Viewed: 19 times