Job Description :
HI

Hope you are doing fine!

Please note we have the following role(s) available for 12 Months+ position with direct client in Ashburn, VA USA.

Please send your consultants resumes with: full-name, contact details (phone # and e-mail address), availability, current location (city and state) and hourly rate on W2 / C2C.

Job Title: IMS and Db2 z O/S Database Administrator (DBA

Location: Ashburn, VA USA.

Duration: 12 Months+.

Start Date: ASAP

Description:

· The position involves providing both IMS and DB2 zO/S Database Administration for Mainframe applications. The DBA will need a broad and deep knowledge of IMS (on-line and Batch) and DB2 z O/S, as well as other technologies/tools, e.g. BMC, Delta IMS, Endevor, JCL, and Batch processing.

· The DBA will conduct performance monitoring and tuning activities, backup and recovery as well as troubleshooting applications on IMS and DB2 databases.

· This position also includes on-call rotation duties and participation in all event bridges and leading the technical troubleshooting and implementation of the solution.

· Incumbent exercises considerable judgement in the resolution of technical problems and in all administrative and professional situations.

· Work is performed under limited supervision and is evaluated while in progress and upon completion through direct observation, discussion, review of established procedures and achievement of desired results.

· Minimum 6-10 years of experience.



JOB DUTIES:

· IMS and Db2 z O/S DBA support for wireline applications: Design and build testing environments, and Production implementation.

· Performance tuning and Troubleshooting

· Monitor IMS and DB2 databases space utilization

· Work with Change control and application teams for coordination with Production Release implementation

· Maintenance procedures using BMC Utilities (COPY, REORG, MODIFY, RECOVER)

· Review, implement, and maintain security procedures across the databases

· Provide advice and support to development resources.

· 24x7 on-call support rotation (DB2 and IMS applications)

· Participate in all event bridges and lead the technical trouble-shooting and implementation of the solution. Lead the postmortem technical meeting with the application, technical teams and partner vendors.

MUST HAVE SKILLS:

· 6-10 years mainframe IMS (on-line and batch) and DB2 z O/S DBA expertise

· Experience with Delta IMS and HALDB and fast path databases

· Strong knowledge of SQL coding for performance on DB2 z/OS

· Experience with basic Explain tool for SQL and understanding of DB2 access paths

· Experience with IBM and BMC tools

· Experience working in a TSO/ISPF environment and Endevor

· Ability to independently research problems and provide solutions

· Willing to work a 24/7 on-call rotation

· Availability to provide weekend/off-hours support as needed

· Strong communication skills

· Strong work ethic

· Demonstrates good interpersonal skills



DESIRED SKILLS:

· Microsoft products or Google suite (docs, sheets, slides)

· Mainframe DBA experience with DB2 v12 and IMS v14

· Experience with Encryption (e.g. DB2 EditProc)

· Multi Logical Datacenter(LDC) and Logical Partition(LPAR) z/OS environment experience

· DB2 Datasharing environment.

· Experience working with QMF, REXX, COBOL and PL/1 programming languages



EDUCATION/CERTIFICATIONS:

· BS in Computer Science or equivalent

· IMS and DB2 certifications a plus