• DB2, Oracle Database Support/E-Verify/EDW

    Job Locations US-MD-Woodlawn | US-NC-Durham
    # of Openings
    1
    Category
    Information Technology
    Agency/Project
    SSA
    Job ID
    2018-2657
  • Overview

    OBXtek Inc. is an established award-winning business providing information technology and professional management services to the federal government. OBXtek is a leader in its field and is committed to identifying, developing, and delivering innovative, mission-focused technical and logistical solutions to over 15 civilian and military partners in the Federal Government.

     

    As a prime contractor for 93% of our current work, we possess a robust corporate infrastructure that provides management oversight and support for all our programs. OBXtek pairs lessons learned across disciplines with industry standard quality practices such as CMMI-Dev Level III, ITIL, 6Sigma, PMI, and ISO to create processes that leverage best practices and result in novel, successful solutions.

     

    Responsibilities

    SSA’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).

     

    The E-Verify program determines the employment eligibility of new hires for businesses across the country by matching information provided by the employee to existing information contained on SSA and DHS databases.

     

    SSA’s DataBase 2 (DB2) architecture comprises 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 more than 30 DB2 databases.

     

    SSA’s ORACLE architecture comprises the nationwide client/server databases for both internal and internet users. This area currently supports over 450 ORACLE databases throughout SSA’s life cycle environment.

     

    Scope of Task

    The objective of this task is to provide IDMS /DB2/Oracle systems programming support for SSA integration, training, acceptance, and production life cycles. The infrastructure that must be maintained includes: DB2 subsystem across four life cycle environments, the installation and maintenance of software packages such as CA-Unicenter, Omegamon and QMF; over 50 IDMS CVs and 30 DB2 subsystems across four life cycle environments, the installation and maintenance of over 10 vendor software packages; Oracle architecture client/server databases for over 450 databases throughout SSA’s life cycle.

     

    Another objective of this task is to provide DB2 UDB systems programming support for SSA. The distributed infrastructure consists of seven DB2 UDB databases on a SUN Solaris platform (20 servers).

     

    In support of the task, the contractor shall perform activities such as those described in the sub-tasks below.

    OBXtek is looking for a Principal Subject Matter Expert to provide DB2 and Oracle systems programming support for SSA integration, training, acceptance, and production life cycles. The infrastructure that must be maintained includes: DB2 subsystem across four life cycle environments, the installation and maintenance of software packages such as CA-Unicenter, Omegamon and QMF.

    In support of the task, the contractor shall perform activities such as those described in the sub-tasks below.

     

    ORACLE Support

    Purpose: Maintain ORACLE database software, and related ORACLE products: Oracle Internet Directory (OID), Oracle on VM (OVM), Oracle Enterprise Manager (OEM), Oracle Warehouse Builder (OWB), Oracle Enterprise User Security Services, Oracle Partitioning Product, Oracle Real Application Cluster (RAC), Oracle Data Guard and Oracle SQL Client.

     

    Activities:

    • Install and maintain ORACLE software versions 10,2,20, & 11G and OID, OEM, OWB, OEUS, RAC and OES.
    • Operate and configure ORACLE. Some common activities include:
      • Create primary database storage structures (tablespaces) after application developers have designed an application.
      • Create new database objects (table, views, indexes) once application developers have designed an application.
      • Modify the database structure, as necessary, from information given by application developers for DB releases.
      • Enroll users and maintaining system security.
      • Ensure compliance with ORACLE license agreements.
      • Control and monitor user access to the database.
      • Maintain archived data.
      • Restore databases.
      • Create new ORACLE instances.
      • Manage names resolution via OID.
      • Modify the database structure, as necessary, from information given by application developers.
      • Perform database reorganizations, export/imports.
      • Evaluate and install ORACLE security patches.
    • Write shell scripts as well as SQL scripts to monitor all process for the ORACLE databases.   Example: Scripts to alert all team members as well as the database administrators in other SSA components of problems.
    • Write UNIX based scripts to monitor database integrity, server stability, security, and intruder detection alerts, and system resources.
    • Assist UNIX/Linux administrators with configuration changes to the HP UNIX or Redhat operating systems for both the RISC and x86 platform as they apply to Oracle software.
    • Create job flows for Control-M batch in conjunction with backups and downloads from main-frame.
    • Troubleshoot problems at a high level using system dumps, system traces, log files and the ability to correct level of Oracle support using Metalink.
    • Develop sophisticated and sometimes complex documentation regarding processes, procedures and tasks performed.
    • Create detailed build and upgrade documents that explain precisely what was performed, how it was done and why it needed to be done.
    • Attend meetings on upcoming and ongoing projects.
    • Train SSA personnel on related software.

     

    All of the above activities must be completed in accordance with SSA build standards and maintenance requirements, which will be provided either orally or in writing.

     

    Deliverables:

    • The contractor shall distribute build and upgrade documentation as a hard and soft copy to a distribution list furnished by the Project Manager. A sample document will be provided.
    • Software depot to be located where agreed upon with the SSA Project Manager.
    • The contractor shall provide status reports on meetings and efforts to the Task Manager via email on a weekly basis.
    • Via email, the contractor shall submit design documents and flow charts to the Task Manager within 5-8 working days of completion of requirements analysis.
    • The contractor shall brief SSA Managers and staffs of all change/installation plans within 2-5 working days of schedule development.
    • The contractor shall submit documentation to the Task Manager via email between 1 day and 2 months of assignment

     

     

     

    Software Installation and Maintenance

     Purpose: Perform software installation and maintenance of ORACLE and DB2 software and third party vendor products.

     

    Activities:

    • Install DB2 software and third party vendor software such as CA-Unicenter, Omegamon, and QMF using System Modification Product/Extended (SMP/E) across SSA System Development Life Cycle (SDLC).
    • Install ORACLE and third party vendor software such as F-Secure, CA Access Control, CA eTrust software suite, and EMC’s Time Finder across SSA System Development Life Cycle (SDLC).
    • Maintain ORACLE and DB2 software and third party vendor software across SSA SDLC.
    • Install DB2 Data Replication software and maintain a continuously available environment.
    • Update configuration documentation reflecting new software versions.
    • Research compatibility between DB2 and third party vendor software.
    • Research compatibility between z/OS, Top Secret, application software in relationship to DB2 and third party vendor products.
      • Establish and document test plans.
      • 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.
      • Upgrade all software according to agreed upon schedule.
      • Update configuration documentation.
      • Install and maintain new third party tools and software.
      • Address audit findings through documentation or software changes or process changes.Deliverables:
      •  
    • The contractor shall submit documentation of any external customization of COTS monitoring software to the Task Manager via email usually within 2-3 days of completion. Customization configuration will be determined by the Managers and staffs; software will be provided by SSA.
    • Using CAPRS, document problem resolutions including full root cause within 2 working days of problem resolution.
    • Other documents required upon resolution of problems will be due based upon a mutually agreeable date between the contractor and SSA Task Manager.

     

    Pagers and Laptops

     

    The contractors are required to carry a cell phone and respond to SSA calls at all time.

    Qualifications

    10+ years of experience with mainframe Oracle and DB2

     

    Experience with Support and Troubleshooting

    Options

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