Database Administrator

Project Scope :

• Phase 1 : Recover Admin-Level Access to FileMaker Server

Project staff will gain administrative-level user access to the Agency's on-premise instance FileMaker Server v13 and create a new set of administrative-level access credentials for the Agency. Project staff will then create two local backups of the Agency's FileMaker database.

Project staff will upload a copy of the Agency's on-premise FileMaker database to the new FileMaker Cloud database created in Phase 2. Using the existing on-premise database as a reference, project staff will then verify that the new cloud database is accurately populated and fully functional.

Ensuring all records have successfully uploaded

Note : Task "Upload database copy to FileMaker Cloud" may be adjusted to uploading a sample of individual records should no backup copy of the Agency's entire database be successfully created during Phase 1. A modified version of Task 3.3.4 would then follow. The Agency and project staff will mutually agree upon a revised sample size for Task 3.3 and verification process for Task 3.4 if Phase 1 work cannot be completed.

Roles / Responsibilities :

Deliverables

A. Phase 1

(1) One (1) set of functional FileMaker Server administrator-level user access credentials.

(2) Two (2) backup copies of on-premise FileMaker database.

B. Phase 2

(3) New FileMaker Cloud database identical in structure and function to existing on-premise FileMaker database.

C. Phase 3

(4) Populated and functional FileMaker Cloud database.

(5) Certification that all database records have successfully transferred to cloud.

(6) Certification that all record data fields function properly.

(7) Report on test of 350 nonsequential records.

(8) Certification that cloud database is accurately populated and fully functional.

Mandatory Skills :

4+ years experience recovering FileMaker Server access, working with FileMaker Server and FileMaker Cloud, and transferring on-premise FileMaker databases to FileMaker Cloud

Desirable Skills : N / A