Job description
Job Title: Database Administrator (Remote)
Location: Austin, TX
Duration: 12 Months
Job Description:
The Individual shall have experience in recovering administrative access to FileMaker Server v13 or a similar on-premise FileMaker Server version, experience in preparing and successfully transferring an on-premise FileMaker database to FileMaker Cloud, and experience in working with the Claris cloud platform.
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.
- Recover administrative-level user access to FileMaker Server v13.
- Create one (1) set of administrative-level user access credentials to FileMaker Server.
- Create two (2) backups of the database running on FileMaker Server.
Create New Database in FileMaker Cloud Identical in Structure to Existing On-Premise Database
Project staff will create a new (unpopulated) database on the FileMaker Cloud platform that duplicates the structure (schema) of the Agency’s existing on-premise FileMaker database.
- Create new database on FileMaker Cloud duplicating the existing on-premise database structure and function.
Transfer a Copy of the On-Premise FileMaker Database to FileMaker Cloud
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.
- Verify readiness of on-premise FileMaker database copy for upload to FileMaker Cloud
- Remediate any pre-upload issues (if necessary)
- Upload database copy to FileMaker Cloud
- Verify cloud database functionality and accuracy by…
- Ensuring all records have successfully uploaded
- Ensuring all record data fields function properly
- Selecting at least 350 nonsequential records and comparing them to the same record in the on-premise database to ensure all data fields have properly populated
- Certifying the above to the Agency
Note: Task 3.3.3 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.
Deliverables
Phase 1
- One (1) set of functional FileMaker Server administrator-level user access credentials.
- Two (2) backup copies of on-premise FileMaker database.
Phase 2
(3) New FileMaker Cloud database identical in structure and function to existing on-premise FileMaker database.
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.
Candidate Skills and Qualifications:
Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.YearsRequired/PreferredExperience4RequiredExperience recovering FileMaker Server access, experience working with FileMaker Server and FileMaker Cloud, and experience transferring on-prem FileMaker databases to FileMaker Cloud.
