Data Warehouse Administrator

CCIE, DB2, TSO, DBA, DFDSS, SPUFI, ERWIN, LCM, DMV, IBM Data Studio, OMEGAMON
Contract Independent, Contract W2, 5

Job Description

Greetings from VSVWINS!

We have a job opening with one of our clients as a Data Warehouse Administrator onsite

Please reach out at: lt;/p>

Position: Data Warehouse Administrator

Location: onsite , Carson City , NV

Duration: 5 Month

Deliverables Consultant must:

  • Complete work and project tasks assigned
  • 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 schedule
  • Problems that were encountered and proposed/actual resolution
  • Issues that need to be addressed
  • Accomplishments during the period
  • Activities to be accomplished during the next reporting period.

Experience and Skills Required:

  • ZOS DB2 DBA consultant must
  • Have the capability to perform the functions described in Section ii, Scope of Work
  • Have a bachelor's degree in computer science, or any other equivalent degree with a minimum of seven (7) years of DB2 DBA experience in ZOS platform
  • Have experience administering complex DB2 environments with multiple subsystems
  • 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
  • Be proficient with DB2 backup and recovery
  • Be able to work with the DMV Application team to understand the requirements and design databases
  • Be able to implement and migrate database changes
  • Have experience securing database objects
  • Have expertise in evaluating, and tuning SQL
  • Have experience tuning DB2 subsystem
  • Have knowledge of DB2 Attachment facilities
  • Have good knowledge of COBOL/CICS/DB2 application programming environment
  • Have good communication, documentation and user requirement gathering skills
  • Be proficient in analyzing, debugging, and troubleshooting issues and ABENDs
  • 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 Connect.
  • Experience working with Application Lifecycle Management tools similar to LCM, CHANGEMAN,
  • ENDEAV OR, SCLM, RTC, or similar
  • Experience working with data modeler tools like ERWIN or Oracle Data Modeler

Dice Id : 91113330
Position Id : 2022-753
Originally Posted : 7 months ago
Have a Job? Post it

Similar Positions

BI/DW Platform Administrator (Tableau, Informatica, Cognos)
  • University of California, Irvine
  • Irvine, CA, USA
Consultant I - DB Administrator / Analyst
  • Bank Of America
  • Richardson, TX, USA
Data Warehouse Developer-II
  • V.L.S. Systems, Inc
  • Madison, WI, USA
EDW Business Intelligence Lead Developer
  • Bourntec Solutions, Inc.
  • Springfield, IL, USA
Administrator
  • Wipro Ltd.
  • Memphis, TN, USA
DB2 Database Administrator Remote
  • Paramount Software Solutions, Inc
  • Atlanta, GA, USA
VP, Data Engineering & Data Warehouse
  • Medical Mutual of Ohio
  • Brooklyn, OH, USA
Mainframe COBOL Programmer
  • Vector Consulting, Inc
  • Durham, NC, USA
permanent position: z/OS Systems Programmer
  • CNC Consulting
  • New York, NY, USA
Mainframe Systems Programmer
  • Financial Information Services Agency
  • New York, NY, USA