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