NFL PB Cutover

Tasks & Runbook

Real-time execution checklist for all teams.

#1

Verify Prod DB Server access for file transfer

Pre-Cutover

Ensure access to vitecdata.blob.core.windows.net for SFTP transfer

Jan 14, 12:00 AM
Completed
Vitech
✓ Completed Jan 16, 4:03 PM
#2

Verify Prod App server access for file transfer

Pre-Cutover

Ensure access to vitecdata.blob.core.windows.net for SFTP transfer

Jan 14, 12:00 AM
Completed
Vitech
✓ Completed Jan 16, 4:04 PM
#3

Check Prod DB Server hard drive volume

Pre-Cutover

Increase size temporarily to support the NFL cutover

Jan 15, 12:00 AM
Completed
Vitech
✓ Completed Jan 17, 1:53 AM
#4

Data Freeze - Final database dump & application files

Cutover

Vitech provides final database dump & application files

Jan 16, 5:00 PM
Completed
Vitech
✓ Completed Jan 17, 1:53 AM
#5

Bring down app, batch & webserver

Cutover

Shutdown all application servers

Jan 16, 5:00 PM
Completed
Vitech
✓ Completed Jan 17, 1:53 AM
#6

Zip DBFS files and Transfer to NFL SFTP

Cutover

Package and transfer database files from PROD Server

Jan 16, 6:00 PM
Completed
Vitech
✓ Completed Jan 17, 1:53 AM
#7

DB Backup / Export

Cutover

Create full database backup

Jan 16, 6:00 PM
Completed
Vitech
✓ Completed Jan 17, 1:54 AM
#8

Zip & Store Backup with Password Protected

Cutover

Secure database backup in Prod DB Server (10.88.82.8)

Jan 16, 9:30 PM
Completed
Vitech
✓ Completed Jan 17, 1:54 AM
#9

Transfer back from Prod DB Server to NFL SFTP

Cutover

Move files from vitecdata.blob.core.windows.net to NFL SFTP

Jan 17, 4:00 AM
Completed
Vitech
✓ Completed Jan 17, 1:54 AM
#10

Send final email notification to NFL

Cutover

Notify NFL PB team of data availability

Jan 17, 1:00 PM
Completed
Vitech
✓ Completed Jan 17, 1:54 AM
#11

Download DB Backup Zip from NFL SFTP to AWS Util Server

Cutover

PointClick downloads backup files

Jan 17, 2:00 PM
Completed
PointClick
✓ Completed Jan 17, 9:15 AM
#12

Extract Backup Files on AWS Util Server

Cutover

Unzip and prepare files for restoration

Jan 17, 7:00 PM
Completed
PointClick
✓ Completed Jan 17, 9:15 AM
#13

Upload extracted files to AWS S3 Bucket for Data Pump

Cutover

Stage files in S3 for RDS import

Jan 18, 12:00 AM
Completed
PointClick
✓ Completed Jan 17, 7:40 PM
#14

Restore DBFS Files

Cutover

Import /mnt/dbfs and v3_import_export files

Jan 18, 2:00 AM
Completed
PointClick
✓ Completed Jan 17, 9:16 AM
#15

Import the dump files to RDS Data Pump directory

Cutover

Load database dump files into Oracle RDS

Jan 18, 7:00 AM
Completed
PointClick
✓ Completed Jan 18, 3:27 AM
#16

Start the dump files restore from Data pump directory to RDS DB

Cutover

Execute Oracle Data Pump import (24 hour process)

Jan 18, 12:00 PM
Completed
PointClick
✓ Completed Jan 18, 3:28 AM
#17

Hand over to NFL PB to begin testing and environment validation

Cutover

NFL PB team validates application functionality

Jan 19, 1:00 PM
Completed
NFL PB
✓ Completed Jan 20, 4:48 PM
#18

Vitech team available for assistance

Cutover

Vitech provides Level 2 support during validation

Jan 19, 1:00 PM
Completed
Vitech
✓ Completed Jan 20, 4:48 PM
#19

Go/No-Go Decision

Cutover

Final sign-off to proceed with DNS cutover or rollback

Jan 19, 1:00 PM
Completed
NFL PB
✓ Completed Jan 20, 4:48 PM
#20

Enable 24/7 SOC Monitoring

Post-Cutover

Deploy RocketCyber Agents on all VMs for continuous security monitoring

TBD
Pending
PointClick
#21

AWS Cost Optimization - RDS Rightsizing

Post-Cutover

Analyze and optimize RDS instances (currently ~60% of infrastructure cost)

TBD
Pending
PointClick
#22

Enable and Test DR Replication

Post-Cutover

Configure and validate Disaster Recovery replication processes

TBD
Pending
PointClick
#23

Vulnerability Scanning Baseline

Post-Cutover

Initiate continuous scanning for new PROD environment

TBD
Pending
PointClick
#24

Penetration Testing

Post-Cutover

Schedule third-party assessment (Shield7) to validate security posture

TBD
Pending
PointClick
#25

Configure Jenkins Pipelines

Post-Cutover

Set up automation for monthly release deployments

TBD
Pending
PointClick
#26

Automate Log Management

Post-Cutover

Configure application log retrieval requests for developers

TBD
Pending
PointClick
#27

Adjust Backup Schedules

Post-Cutover

Fine-tune RDS snapshot and AWS Backup policies for production load

TBD
Pending
PointClick