Mainframe DB2 Expert

US-MD-Woodlawn
# of Openings
1
Category
Information Technology
Agency/Project
SSA
Job ID
2017-2167

Overview

OBXtek is an award winning Service Disabled Veteran Owned Small Business providing information technology and management services to the federal government. As the prime contractor on over 85% of its work, OBXtek is a leader in its field and has a robust corporate infrastructure that provides support for all of its programs.

The Social Security Administration's Integrated Data Management System (IDMS) and DB2 architecture comprise the nationwide online database for millions of users, including all SSA users and the public, and processes over 60 million transactions per day.   These environments consist of over 50 IDMS Central Versions (CVs) and more than 30 DB2 subsystems.  SSA’s distributed environment consists of 20 Sun Servers spread across seven physical sites using DB2 UDB for UNIX.  These support SSA Disability Systems and are part of the Document Management Architecture (DMA).  

Responsibilities

OBXtek is currently staffing for a Mainframe DB2 Expert in the Baltimore SSA facility. The job will involve the following tasks: 

 

IDMS and DB2 Software Development and Maintenance

 

> Maintain, test, document, and deploy IDMS and DB2 system level software features and changes.

 

Activities: The following activities shall be performed in accordance with SSA standards, which will be provided by SSA, for building IDMS CVs, DB2 subsystems and adhering to life cycle and change control procedures:

  • Analyze requirements.
  • Develop detailed procedure documents for installation, maintenance and testing.
  • Install, test, and maintain IDMS and DB2 system software.
  • Meet with fellow SSA management and staffs to develop requirements.
  • Manage the life cycle.
  • Coordinate software changes.

Create New or Modify Existing IDMS and DB2 Architectures  

 

> Create new or modify existing IDMS CVs, DB2 subsystems in support of new SSA applications or database architecture re-engineering initiatives.  

 

Activities: The following activities shall be performed in accordance with SSA standards, which will be provided by SSA, for building IDMS CVs, DB2 subsystems and adhering to life cycle and change control procedures:

  • Create new CVs and DB2 Subsystems for Integration, Training, Acceptance, and Production life cycles.
  • Upon Task Manager approval, complete appropriate change management documentation such as specific forms and SSA Change Asset and Problem Reporting System (CAPRS).
  • Update appropriate IDMS and DB2 configuration documentation to reflect changes to the architecture.
  • Communicate and work with application developers and software testers to ensure all IDMS and DB2 resources are identified and defined appropriately.

Problem Management and Production Support

 

> Problem resolution.

 

Activities:

  • Customize commercial off-the-shelf (COTS) monitoring software to monitor the

IDMS and DB2 production environment for problems.  

  • Inform SSA Management and Staffs of problems and subsequent resolutions. 

All problems/ system issues are expected to be worked on until the problem is resolved, even if it requires staying extended periods of time or outside normal business hours.

 

Software Installation and Maintenance

 

>  Install and maintain IDMS and DB2 software and third party vendor products.

 

Activities:

  • Install IDMS and DB2 system software and third party vendor software using System Modification Product/Extended (SMP/E) across SSA System Development Life Cycle (SDLC).
  • Maintain IDMS and DB2 system software and third party vendor software using SMP/E across SSA SDLC.
  • Update configuration documentation reflecting new software versions.
  • Research compatibility between IDMS, DB2 and third party vendor software.
  • Research compatibility between z/OS, Top Secret, Application software in relationship to IDMS, DB2 and third party vendor products.
  • Establish and document test plan.
  • Coordinate test activities with application development staff and external partners.
  • Document changes using SSA Change Management System (CMS).
  • Communicate and coordinate software upgrades with the Task Manager.  

DB2 UDB Software Development and Maintenance

 

>  Develop, maintain, test, document, and deploy DB2 UDB system level software features and changes.

 

Activities: The following activities shall be performed in accordance with SSA standards, which will be provided by SSA, DB2 UDB databases and adhering to life cycle and change control procedures:

  • Analyze requirements.
  • Meet with SSA analysts, management and end-users to develop requirements.
  • Develop detailed procedure documents for installation, maintenance and testing.
  • Coordinate software changes.
  • Install, test, and maintain DB2 UDB software.
  • Manage the life cycle.

Create New or Modify DB2 UDB Architectures.   

 

> Create new or modify existing DB2 UDB and Content Manager databases in support of new SSA applications or database architecture re-engineering initiatives.  

 

 

Activities: The following activities shall be performed in accordance with SSA standards, which will be provided by SSA, for building DB2 UDB and Content Manager databases and adhering to life cycle and change control procedures:

  • Create new DB2 UDB and Content Manager databases for integration, training, acceptance, and production life cycles.
  • Complete appropriate change management documentation such as specific forms and SSA Change Asset and Problem Reporting System (CAPRS).
  • Update appropriate DB2 UDB configuration documentation to reflect changes to the architecture.
  • Communicate and work with application developers and software testers to ensure all DB2 UDB resources are identified and defined appropriately.

Problem Management and Production Support

 

 Problem resolution.

 

Activities:

  • Customize commercial off-the-shelf (COTS) monitoring software to monitor the DB2 UDB production environment for problems.  
  • Inform specified SSA personnel by phone and email of problems and subsequent resolutions.  SSA personnel will be specified by the task manager.

Software Installation and Maintenance for DB2 UDB

 

>  Perform software installation and maintenance of DB2 UDB software and third party vendor products to maintain a reliable and stable infrastructure.

 

Activities:

  • Install DB2 UDB software and third party vendor software across SSA System Development Life Cycle (SDLC).
  • Maintain DB2 UDB software and third party vendor software SSA SDLC.
  • Update configuration documentation reflecting new software versions.
  • Research compatibility between DB2 UDB and third party vendor software.
  • Research compatibility between SUN Solaris, Security Software, Application software in relationship to DB2 UDB and third party vendor products.
  • Establish and document test plan.
  • Coordinate test activities with application development staff and external partners.
  • Document changes using SSA Change Management System (CMS).
  • Communicate and coordinate software upgrades with the Task Manager.  

Qualifications

> Fully qualified candidates will have 10+ years of experience with IDMS and DB2.

> Experience with Queue Replication is highly desirable but not required.

> Strong verbal and written communication skills.

> Ability to offer guidance and insight.

> Effective team player on a development team.

> Experience supporting a large user community.

 

> Must be able to acquire a clearance level of Public Trust.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed