Database Administrator (Remote)
Serigor
Contract
Remote
United States
Database Management
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.
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.
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.
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
Phase 2
(3) New FileMaker Cloud database identical in structure and function to existing on-premise FileMaker database.
Phase 3:
Candidate Skills and Qualifications:
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. | ||
| Years | Required/Preferred | Experience |
| 4 | Experience recovering FileMaker Server access, experience working with FileMaker Server and FileMaker Cloud, and experience transferring on-prem FileMaker databases to FileMaker Cloud. | |