Job Description

Ref No.:18-09003
Location: Raleigh, North Carolina

Short Description:
The assignment is anticipated to take four to six months. The position will be 40 hours per week, Monday through Friday and the work will take place onsite at the Raleigh headquarters location.

Complete Description:

The position will support legacy mainframe databases and new database installations. The position will work with a team of DBAs that will provide support to tax system databases that contain both federal and state tax information. The selected candidate will serve as primary database support for DB2 on Z Series Mainframe in a production environment. This includes Table Reorgs, Indexing, Table Partitioning, Performance Tuning, Automation and Scheduling of tasks in Zeke with extensive use of JCL, Easytrieve and REXX.

Description (including, but not limited to):
1. Data analysis and database management
2. Maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning
3. (Logical) Administration of application objects within database; maintenance of business requirements for database, database schema, data maps, ERDs, application objects (i.e., tables, indexes, views, etc.); performance of database application tuning; provision of business and data requirements and data for capacity planning
4. (Physical) Environment-level administration; installation/patch/upgrade of database software; management of HA, database-level security; maintenance of database configuration files and data files; completion of database reorganizations, environment tuning, refreshes, exports and imports, backup and recovery; performance of capacity planning driven by technology and resource usage trends

SkillsRequired Minimum Experience Candidate ExperienceLast Used
Mastery of DR best practices and ABARS as well as other complex administration task of high transaction volume tax applicationHighly desired10 Years
Ability to perform Regular Storage Management and Administration of large databases on MainFrame DASDRequired10 Years
Assist programmers in diagnosing/troubleshooting code and queriesRequired10 Years
Provide Performance Tuning on the DB2 Z databasesRequired10 Years
Provide Database Administration on DB2 os390 v11Required10 Years
Strong demonstrated administration skills of IBM DB2 on ZOSRequired10 Years
Experience with CA Database toolRequired10 Years
Demonstrated ability to work with DB2 on the MainframeRequired10 Years
Administration of CICSHighly desired10 Years
File manipulation: FTP, ConnectDirect, File-AID/RDX, VSAM, RACF, IMSHighly desired10 Years
Programming languages; REXX, Easytrieve, Cobol, JCL; ISPF (CLIST, PROCS, Skeletons, Panels, Messages, Tables) and Logon ProcsRequired10 Years


Questions:
QuestionsQuestionsAnswers
Question 1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2All work must be completed on site. Do you accept this requirement?
Question 3Please list candidate's email address HERE that will be used when submitting E-RTR.
Question 4Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.
Question 5Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement?
Question 6Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirement?
Question 7Please note - that if your candidate is selected for hire, the Iran Divestment Act Certification form must be completed and uploaded to the Compliance tab as a part of the onboarding process. This form must be received within a timely manner (expectation 1 business day). Without this form, the Purchase Order cannot be generated and your candidate cannot begin work. Do you accept this requirement?
QuestionsQuestionsAnswers
Question 1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2All work must be completed on site. Do you accept this requirement?
Question 3Please list candidate's email address HERE that will be used when submitting E-RTR.
Question 4Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.
Question 5Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement?
Question 6Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirement?
Question 7Please note - that if your candidate is selected for hire, the Iran Divestment Act Certification form must be completed and uploaded to the Compliance tab as a part of the onboarding process. This form must be received within a timely manner (expectation 1 business day). Without this form, the Purchase Order cannot be generated and your candidate cannot begin work. Do you accept this requirement?

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online