Organisation

Work/Task Breakdown

Preparation for Migrations

1. Review Oracle documentation and produce high level plan and task list for migrations and dataguard set up
2. Review existing Interface, Cron and UTL documentation and update for any changes since original documentation produced in 2012.

Create Migration environment

1. Establish server space for ‘migration’ instance of HR Payroll on Myres.
2. Configure the clone for the new URL, open Firewall, Configure LB, set up dns, request user accounts
3. Install pre-requisite clone/migration patches (DEV, TEST & LIVE)
4. Install software and create database.
5. Migrate existing database to new database (export/import) + post steps.
6. Testing of migration environment by Production Management
7. Testing of migration environment by business users
8. Sign off of migration environment

TEST Migration

1. Preparatory tasks including establishing new environments, pre-requisite patches and clone
2. Migration of database to new infrastructure
3. Updates to Interfaces, Crons, UTL files, etc to ensure continued functionality
4. Update Technical documentation (if required from TEST migration)
5. Undertake Switch over and DR tests
6. Testing of migration environment by Production Management
7. Testing of migration environment by business users
8. Revise Migration Plan for LIVE
9. Deployment Checklist and all required pre-requisite tasks
10. Handover to Production Management
11. Sign Off TEST Migration

 LIVE Migration 

1. Preparatory tasks including establishing new environments, pre-requisite patches and clone
2. Migration of database to new infrastructure
3. Updates to Interfaces, Crons, UTL files, etc to ensure continued functionality
4. Testing of migration environment by Production Management
5. Testing of migration environment by business users
6. Sign off deployment to LIVE
7. Update Technical documentation (if required from LIVE migration)
8. Update Tech Collaboration WIKI with technical documentation
9. Clone LIVE to DEV to verify the new clone process documentation
10. Sign Off LIVE Migration

DEV Migration

1. Preparatory tasks including establishing new environments
2. Clone LIVE to DEV to verify the new clone process documentation
3. Apply any database changes which have been implemented (in the interim) to current DEV that need to be replicated on the new dev environment following migration
4. Migration of database to new infrastructure
5. Updates to Interfaces, Crons, UTL files, etc as required
6. Update techical documentation including TAD, Operations documentation, patching and clone processes
7. Sign Off DEV Migration

Establish Dataguard [This may be done separately to the Migrations to ensure that the LIVE migration is completed by early December]

1. Establish Dataguard on DEV
2. Document Implementation plan for Dataguard
3. Conduct switchover/failover testing on DEV
4. Establish Dataguard on TEST
5. Undertake switchoverfailover tests in TEST
6. Update documentation (as required)
7. Establish Dataguard on LIVE
8. Carry out switchover/failover tesing in LIVE

Resources Skills and Cost

The HR Systems Manager and the Payroll and Pensions Systems Manager will be the main point on contacts with the HR, Payroll and Pensions teams. They will be required to be involved in all sign off stages and will lead on testing to ensure that this is completed and documented satisfactorily to allow sign off. Where required they will delegate testing but they will maintain responsibility for sign off and ensuring that testers understand test requirements. 

The majority of IS Applications technical input will be required from the Development Technology, SASG Development and Applications Management teams. Technology Management will also provide input but this is expected to be minimal with input to sign off stages and with increased input at the end of the project for handover tasks. 

IS Applications Project Services will provide the Project Management and, as required, Programme Management input. 

The overall effort for the project, taking work already carried out and work remaining into consideration, is estimated at 116 days. This does not include all the tasks that cover DataGuard, which has been estimated at requiring an additional 20-25 days effort.