Under broad supervision as a
DB2 LUW DBA DATABASE ADMINISTRATOR, designs and secures computer databases to store, track, and maintain a large volume of critical business information. Develops database models and coordinates projects.
In this role as a DB2 LUW DBA DATABASE ADMINISTRATOR, you ll be responsible for working with the Application Development team to design, create and update DB2 LUW database objects and be a member of the Database Administration staff. The applications are primarily Java and some COBOL running on Red Hat s Enterprise Linux. You ll assist the Application Development team code efficient SQL statements, review the SQL statements for performance and make recommendations for indexes. You ll document entity types and the relationships between entities with an Entity Relationship Diagram using Erwin. You ll also support the Quality Assurance team with testing applications.
*On-Site position*
*Local Candidates*
Job Responsibilities:
Experience with planning, documenting and performing upgrades and migration, setting up new database environments..
Design and plan upgrade strategies including coordination with system administrators and developer. Upgrade plans must include checklist, milestones, complete checkout, and exercised fallback procedures
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.
Support the Quality Assurance team test applications.
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 non-business hours including weekends and holidays, as needed.
Minimum 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 Hat s Enterprise Linux (RHEL).
Three years experience with Relational Data Modeling.
Three years experience with Microsoft s Outlook, EXCEL and WORD.
One year experience with Erwin.
One year experience with Java programming language.
Preferred Qualifications:
Experience with IBM s WebSphere.
Experience with COBOL.
Experience with Hibernate.
Experience with IBM s DataQuant or QMF.
Experience with Quest s Toad for DB2 LUW.
Experience with DBI Software s Performance Suite for DB2 LUW.
Experience with scripting languages, such as Perl or Python.
Experience with Unix shell scripts, such as ksh, csh, bash or sh.
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
SkillRequired /DesiredAmountof ExperienceExperience as a Database Administrator for
DB2 LUWRequired3YearsExperience with Structure Query Language (SQL)Required5YearsMonitor production databases and dbm settings, adjusting for optimal performance and throughput.Required3YearsExtensive experience with planning, documenting and performing upgrades and migration, setting up new database environments. Required3YearsExperience with IBM's DataQuant or QMF or Quest's Toad for
DB2 LUWRequired1YearsExperience with Red Hat's Enterprise LinuxRequired3YearsExperience with Unix shell scripts, such as ksh, csh, bash or shRequired1YearsExperience with Relational Data ModelingDesired2YearsExperience with Microsoft's Outlook, EXCEL and WordRequired2YearsExperience with Java or COBOL programming languageDesired1YearsExperience with DBI Software's Performance Suite for
DB2 LUWDesired1YearsExperience with Sql Server / MySQL / TeradataDesired1YearsExperience with Local, State or Federal governmenDesired0
Questions
No.QuestionQuestion1Absences 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? Question2Please list candidate's email address.Question3Candidate must be paid AT LEAST $$$ if selected for engagement. Candidate can be paid more; however, the SRP rate cannot $$$$$$. Do you accept this requirement? Question4The maximum mark-up for this engagement s SRP rate is 35%. To be competitive on pricing, a mark-up below the 35% threshold is suggested. Do you agree to propose a mark-up at or below 35%?Question5This assignment is contingent upon customer renewal and availability of adequate funding. Do you accept this requirement?Question6The selected candidate will be expected to start their engagement no later than 2 weeks (10 business days) from the client s selection date. Do you accept this requirement?Question7Onsite 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?