Database Administrator (Remote)

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. Apply tot his job Apply To this Job