Role: DB2 Admin

Location : Plano TX Onsite

Duration: Fulltime

Job Description

1.Install, upgrade, maintain and customize DB2 and its associated IBM and 3rd party software

2.Monitor DB2 on z/OS environment

3. Create, modify and maintain the DB2 databases on z/OS environment

4. Technical system support for DB2 sub systems, database tools and utilities

5. Support DB2 business, end user and application requirements.

6. Monitors DB2 Regions across life cycles, take necessary remedial action as required.

7. Reorganize and update statistics in the DB2 System Catalog tables.

8. Perform regular housekeeping activities like administer the data server on which DB2 resides like monitoring disk space and the DB2 logs, Backups and protect the integrity of the data.

9. Review all data models for technical accuracy. This includes the enforcement of all modeling and naming standards

10. Perform all structural changes to DB2 databases

11. Work with Buyer’s Security Administration to insure that proper security is in place for DB2 data

12. Regularly review Automation and Dependency of systems tasks

13. Manage and maintain data definitions for all prod and non-prod databases

14. DB2 SQL performance tuning

Job Type: Full-time

Benefits:

• Dental insurance
• Health insurance
• Paid time off

Schedule:

• 8 hour shift

Experience:

• DB2: 8 years (Required)
• SQL: 6 years (Required)

Work Location: On the road