4 days onsite each week, must be local
Candidates need to take a video screen with prime vendor prior to end client submittal
Need valid LinkedIn
Business Objectives & Key Project Details
- Run the current DB2 environment
- Help with data migration related to the product modernization effort (moving to BTAP)
% breakdown of what they will be doing
- 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.
- Lots of patching
- 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.
Required Skills
- 5+ years’ experience as a Database Administrator.
- 5+ years’ experience with Structure Query Language (SQL).
- 3+ years’ experience as a Database Administrator on DB2 LUW.
- 3+ years’ experience with Red Hat’s Enterprise Linux (RHEL).
- 3+ years’ experience with Relational Data Modeling.
Preferred Skills
- Experience with Erwin.
- Experience with Java programming language.
- Experience with scripting languages, such as Perl or Python.
- Experience with SQL Server, MySQL, or Teradata
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.
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
- 5+ years’ experience as a Database Administrator.
- 5+ years’ experience with Structure Query Language (SQL).
- 3+ years’ experience as a Database Administrator on DB2 LUW.
- 3+ years’ experience with Red Hat’s Enterprise Linux (RHEL).
- 3+ years’ experience with Relational Data Modeling.
Preferred Qualifications
- Experience with Erwin.
- Experience with Java programming language.
- Experience with scripting languages, such as Perl or Python.
- Experience with SQL Server, MySQL, or Teradata
- 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 Unix shell scripts, such as ksh, csh, bash or sh.
- Experience with Local, State or Federal government.