DB2 DBA

Next Level Business Services, Inc.; Columbus (OH); On-site; USD 75,000 - 95,000; Full time

Job summary

A professional services firm is seeking an individual skilled in DB2 maintenance and migration processes. Responsibilities include applying DB2 updates, conducting system-level testing, and documenting tasks for customer reporting. Strong knowledge in database systems and migration procedures is essential for success in this role, where attention to detail and communication are key. This position offers the opportunity to contribute to critical database upgrade projects in a supportive team environment.

Qualifications

• Experience with DB2 subsystem migration and maintenance.
• Strong understanding of DB2 tools and utilities.
• Ability to develop detailed migration plans.

Responsibilities

• Order and apply DB2 maintenance for migration.
• Perform system level testing on all DB2 subsystems.
• Document all tasks and upgrades for customer reporting.

Skills

DB2 maintenance

System level testing

Migration procedures

Documenting tasks

Job description

1. Order, receive, apply, any required DB2 maintenance for migration to sandbox DB2 subsystem, DB2S.
2. Roll out maintenance for #1 to remaining DB2 subsystems, DB2T, DB2D and DB2P.
3. Review all DB2 ISV and IBM tools and utilities for compatibility for DB2 11.
4. Document required ISV and IBM tools and utilities upgrades required from #3.
5. Order DB2 11 and any IBM tools and utilities required for migration in a ServerPac.
6. Install and test all software delivered on ServerPac from #5.
7. Create a detailed migration plan, procedure.
8. Migrate the DB2 sandbox subsystem, DB2S, to DB2 11 CM mode.
9. Perform system level testing on migrated DB2S (CM mode), and all tools and utilities.
10. Migrate the DB2 test subsystem, DB2T, to DB2 11 CM mode.
11. Perform system level testing on migrated DB2T (CM mode), and all tools and utilities.
12. Assist with any application testing for DB2T, assist with any issues that are encountered.
13. Migrate the DB2 development subsystem, DB2D, to DB2 11 CM mode.
14. Perform system level testing on migrated DB2D (CM mode), and all tools and utilities.
15. Assist with any application testing for DB2D, assist with any issues that are encountered.
16. Migrate the DB2 production subsystem, DB2P, to DB2 11 CM mode.
17. Perform system level testing on migrated DB2P (CM mode), and all tools and utilities.
18. Assist with any application testing for DB2P, assist with any issues that are encountered.
19. Migrate the DB2 sandbox subsystem, DB2S, to enable new function mode (ENFM) and new function mode (NFM).
20. Perform system level testing on migrated DB2S (NFM mode), and all tools and utilities.
21. Migrate the DB2 test subsystem, DB2T, to enable new function mode (ENFM) and new function mode (NFM).
22. Perform system level testing on migrated DB2T (NFM mode), and all tools and utilities.
23. Assist with any application testing for DB2T, assist with any issues that are encountered.
24. Migrate the DB2 development subsystem, DB2D, to enable new function mode (ENFM) and new function mode (NFM).
25. Perform system level testing on migrated DB2D (NFM mode), and all tools and utilities.
26. Assist with any application testing for DB2D, assist with any issues that are encountered.
27. Migrate the DB2 production subsystem, DB2P, to enable new function mode (ENFM) and new function mode (NFM).
28. Perform system level testing on migrated DB2P (NFM mode), and all tools and utilities.
29. Assist with any application testing for DB2P, assist with any issues that are encountered.

RESPONSIBILITIES

1. Staff this effort with appropriately skilled individuals to perform the Services.
2. Promptly notify Customer of any unsafe condition about which Sirius has knowledge.
3. If applicable, document each task necessary to complete the Services and send a final report to Customer when such tasks are completed.

Additional Information

All your information will be kept confidential according to EEO guidelines.