Job Description :
Role: DB2 Database Administrator
Duration: 6+ Month Contract
Location: Sacramento, CA
Interview: Phone and Skype
Job Responsibilities
DB2 Database Administrator (with z/OS Experience)
Provides technical leadership and operational expertise at the decision-making level for the implementation, architecture, design, ongoing support and maintenance of DB2 databases and related software tools;
Supports object-relational features and non-relational structures (e.g., JSON, XML);
Designs, develops, and maintains data models utilizing data modeling and code generation tools (e.g., DB2 Data Studio, Erwin Data Modeler, Sparx Enterprise Architect);
Utilizes available IBM DB2 tools (e.g., QMF and QMF for Workstation, DB2 Administration, Query Monitor, db2top, Recovery Expert, Cloning Tool, Object Comparison Tool) and other supporting tools (e.g., File AID for DB2);
Develops training criteria, training plans, course design, handouts, and provides training and knowledge transfer to staff.
Mandatory Qualifications:
At least five (5) years of FTE experience as a DB2 Database Administrator responsible for the following:
DB2 database administration, DB2 database configuration, DB2 data replication, DB2 utilities, DB2 resource monitoring;
DB2 z/OS static and dynamic SQL; and
DB2 z/OS database backup, recovery, performance tuning, configuration and design.
The DB2 Database Administrator (Backend Web Developer) shall have at least one (1) year of DB2 database administration FTE experience with DB2 v 9.1 or greater on z/OS.
Required experience:
DB2 FTE: 5 years
z/OS 9.1 or higher: 1 year