Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Db2, Oracle Database Support/E-Verify/Edw

Expired Job

Obxtek Durham , NC 27701

Posted 3 months ago

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


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Manager Manufacturing Support And Training

Avexis

Posted 3 days ago

VIEW JOBS 12/14/2018 12:00:00 AM 2019-03-14T00:00 Overview Ready to join a team committed to moving gene therapies into the clinical and commercial settings for patients and families devastated by rare neurological genetic diseases? AveXis is advancing cutting-edge science to treat rare and life-threatening genetic diseases starting with our clinical-stage, proprietary gene therapy candidate, AVXS-101. We are in the midst of an incredible journey and are looking for passionate individuals to join us on this important mission. AveXis, Inc., a Novartis Company, is a clinical-stage gene therapy company, dedicated to developing and commercializing novel treatments for patients suffering from rare and life-threatening neurological genetic diseases. Our initial product candidate, AVXS-101, is our proprietary gene therapy product candidate currently in development for the treatment of spinal muscular atrophy, or SMA, Type 1, the leading genetic cause of infant mortality, and for the treatment of SMA Type 2. The U.S. Food and Drug Administration, or FDA, has granted AVXS-101 Orphan Drug Designation for the treatment of all types of SMA and Breakthrough Therapy Designation, as well as Fast Track Designation for the treatment of SMA Type 1. In addition to developing AVXS-101 to treat SMA Type 1 and Type 2, we also plan to develop other novel treatments for rare neurological diseases, including Rett syndrome (RTT) and a genetic form of amyotrophic lateral sclerosis (ALS) caused by mutations in the superoxide dismutase 1 (SOD1) gene. The Senior Manager, Manufacturing Support will be responsible for multiple functions within the North Carolina site including technical training, NCR/CAPA authoring and investigation, ownership of major manufacturing related change controls, and finite scheduling. This is a leadership role reporting to the Site Head that provides support across site teams and requires understanding of multiple site functions as well as major business and quality systems. The Senior Manager, Manufacturing Support may also provide training activities to other departments, making sure that all employees understand the importance of their job functions. In addition, this position will contribute to other quality system activities such as NCR/CAPA, inspection preparation and change control processes. Responsibilities * Lead and support individual departments to develop and execute employee qualifications for technical training. * Write and review GMP documents such as Standard Operating Procedures and Batch Records. * Create, update and modify training documents in the Learning Management System. * Lead a team that authors and investigates NCR/CAPA's for manufacturing. * Ownership of major manufacturing related change controls including tech transfer, capital projects and major process changes. * Develop and maintain detailed, task-based manufacturing schedules (Finite) to support seamless multifunction activities at the site. Qualifications * Bachelor's degree in Life Science or Engineering field required * 5+ years of experience in a GMP manufacturing or quality position with 3+ years of training in a GMP manufacturing pharmaceutical/biotechnology environment * Understanding of FDA regulations and best practices for training and development * Experience with GMP documentation management * Good interpersonal skills and strong written/communication skills * Energetic and detail oriented with strong organizational skills * Experience with the Learning Management System ComplianceWire is a plus Approximately 5 % travel required. The level of this position will be based on the final candidate's qualifications. Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. AveXis is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity, national origin, genetics, disability, age, sexual orientation or veteran status. Avexis Durham NC

Db2, Oracle Database Support/E-Verify/Edw

Expired Job

Obxtek