Job Description

Link Technologies (LinkTechConsulting.com), a Las Vegas-based IT consulting firm, is currently looking for a Mainframe Systems Programmer 4 to join our team.

Project Overview

The application (CARRS) is an integrated system that is supported by both client server and web applications written in Power Builder, VB.NET, ASP.NET, COBOL, DB2, CICS, and SQL Server. The application has over 900 internal users, 800,000 portal accounts, many

external customers, and interfaces with local, State and Federal agencies. The core application runs on System Z with multiple CICS and DB2 environments secured by RACF. The core application is COBOL/DB2 programs that run both in batch and CICS environments.

The consultant will be working on the following but not limited to:

• Administer DB2 database and
  • Monitor storage, support capacity planning, support securing ZOS resources, perform routine maintenance tasks, assist with data migration tasks, troubleshoot and resolve
• Provide status reports as required by
• Log activity and time using time tracking software (Jira)
• Follow guidelines established by the Client.
• Support IT teams as
• Document changes and follow protocols established by the Client.

The consultant will work with IT teams and complete the assigned tasks in the scope of work in accordance with the IT standards and procedures.

Scope of Work

Consultant must provide the following based on the agreed upon project plan/schedule:

• Manage, monitor, and tune DB2 subsystems and application
• Clone databases and establish additional application
• DB2 database and dataset backup and
• Refresh data, as
• Clone and establish additional application environments, as
• Aid in data conversion projects and extract data to staging environments, as
• Maintain privacy and security of
• Support Application Lifecycle, application development tools, as
• Migrate database

• Document and update procedures and check
• Coordinate upgrades to ZOS, CICS, DB2, Administration tools, and application development
• Coordinate DR testing and support data conversion and
• Help IT teams with SQL review and
• Discuss business requirements and help with application and database
• Support CICS

Deliverables

Consultant must:

• Complete work and project tasks
• Consultant must provide daily / weekly status reports of the project with details on tasks and hours spent on each task, as well as:
  • Overall completion status of the project in terms of the approved project plan and
  • Document problems that were encountered and proposed/actual
  • Document issues that need to be
  • Document accomplishments during the
  • Document activities to be accomplished during the next reporting

Experience and Skills Required

ZOS DB2 DBA consultant must:

• Have the capability to perform the functions described in Scope of Work
• Have a bachelor's degree in computer science, or any other equivalent degree or equivalent years of relevant experience, with a minimum of seven (7) years of DB2 DBA experience in ZOS
• Have experience administering complex DB2 environments with multiple
• Be experienced working on ZOS tools and utilities - TSO, ISPF, SDSF, JCL, DFSORT, ICETOOL, DFDSS, DFSMS, DFHSM, OMVS, RACF, REXX/CLIST.
• Be experienced with using DB2 tools - SPUFI, QMF, DB2 Admin Tool or equivalent, DB2 Object Compare or equivalent, IBM Data Studio, OMEGAMON or equivalent, Query Monitor or

equivalent.

• Be proficient with DB2 utilities and DB2 backup and
• Be able to work with the DMV IT teams to understand the requirements and design
• Be able to implement and migrate database
• Have experience securing database
• Have expertise in evaluating and tuning SQL and experience tuning DB2
• Have knowledge of DB2 Attachment
• Have good knowledge of COBOL/CICS/DB2 application programming
• Have good communication, documentation and user requirement gathering
• Be proficient in analyzing, debugging, and troubleshooting issues and
• Be a team player who can work with other contractors/consultants and permanent employees under a complex team structure.

Experience and Skills Preferred

• Experience installing and configuring DB2
• Experience working with Application Lifecycle Management tools like LCM, CHANGEMAN, ENDEVOR, SCLM, RTC, or similar.
• Experience working with data modeler tools like ERWIN or

Link Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination based on race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.