DB2 LUW Database Administrator

Engagement Type

Contract

Short Description

Under broad supervision asna DB2 LUW DBA DATABASE ADMINISTRATOR designs and secures computerndatabases to store track and maintain a large volume of critical businessninformation. SQL Development. Develops database models and coordinatesnprojects.

Complete Description

*OnSite position*

*Local Candidates*

Job Responsibilities:

Experience with planning documenting and performing upgrades and migration setting up new database environments.

Develop moderate/complex SQL statement for data migration (ETL process).

Support Application Developers in designing implementing and testing database changes to support business applications.

Assist Application Developers code efficient SQL statements review the SQL statements for performance and make recommendations for indexes.

Design and plan upgrade strategies including coordination with system administrators and developer. Upgrade plans must include checklist milestones complete checkout and exercised fallback procedures

Assist other Database Administrators maintain multiple DB2 LUW environments such as Development QA Training and Production.

Support Database Administrators and Systems Administrators during patching of operating systems and database systems.

Document entity types and the relationships between entities with an Entity Relationship Diagram using Erwin.

Ability to work during nonbusiness hours including weekends and holidays as needed.

Qualifications:

Five years experience as a Database Administrator.

Five years experience with Structure Query Language (SQL).

Three years experience as a Database Administrator on DB2 LUW.

Three years experience with Red Hats Enterprise Linux (RHEL).

One year experience with Relational Data Modeling.

One year experience with Microsofts Outlook EXCEL and WORD.

One year experience with Erwin.

Preferred Qualifications:

Experience with Quests Toad for DB2 LUWIBMs DataQuant or QMF.

Experience with moderate/complex SQL development

Experience with Unix shell scripts such as ksh csh bash or sh.

Experience with COBOL.

Experience with DBI Softwares Performance Suite for DB2 LUW.

Experience with Sql Server MySQL or Teradata

Experience with Local State or Federal government.

Personal Qualities:

Be innovative energetic energizing flexible and eager to learn. Excellent work ethic attention to detail ability to work in a highly collaborative collegial multidisciplinary fast paced team environment. Excellent analytical skills with the ability to manage multiple priorities and requests. Excellent communication and interpersonal skills. Ability to work independently and meet requested deadlines promptly.

Required/Desired Skills

Skill Required/Desired Amount of Experience Experience as a Database Administrator Required 5 Years Experience with Structure Query Language (SQL). Required 5 Years Experience as a Database Administrator on DB2 LUW. Required 3 Years experience with Red Hats Enterprise Linux (RHEL). Required 3 Years Experience with Relational Data Modeling. Required 3 Years Experience with Microsofts Outlook EXCEL and WORD. Required 1 Years Experience with Erwin Required 1 Years Experience with Quests Toad for DB2 LUWIBMs DataQuant or QMF. Highly desired 0 Experience with moderate/complex SQL development Highly desired 0 Experience with COBOL Highly desired 0 Experience with Local State or Federal government Highly desired 0

Questions

Description Question 1 Absences 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 agree to this requirement Question 2 What is your candidates email address Question 3 If selected for engagement your candidates hourly Pay Rate must be at least $83.00 Your candidate can be paid more; however the hourly SRP Rate cannot exceed $112.05 Do you agree to these requirements Question 4 The maximum markup for this engagements SRP rate is 35%. To be competitive on pricing a markup below the 35% threshold is suggested. Do you agree to propose a markup at or below 35% Question 5 This assignment is contingent upon customer renewal and availability of adequate funding. Do you agree to this requirement Question 6 If selected for engagement your candidate will be expected to start no later than 2 weeks (10 business days) after the clients selection date Do you agree to this requirement Question 7 Onsite Required: Due to the essential nature of the work to be performed this position REQUIRES the selected candidate to work ONSITE for the duration of the assignment. Candidates will not be permitted to work remotely. Do you accept this requirement Question 8 Where does the candidate reside

DB2,LUW,RHEL