Database Administrator

Location: Town of Texas

Bellville, United States | Posted on 10/09/2025

Title:
Database Administrator

Location:

Austin, TX

Job Description

Introduction:
The Agency has anon-premise installation of Claris File Maker Server v13 software. The Agency needs to recover administrative-level user access to this software and then port the database running on it to File Maker Cloud. This project would occur in three successive phases.

In Phase 1 of the project, project staff will recover administrative-level user access to File Maker Server v13. Project staff will then create new administrative-level user access credentials for the Agency. Finally, project staff will create two (2) backups of the database running on the File Maker Server software.

In Phase 2 of the project, project staff will create a new database for the Agency on the File Maker Cloud platform. This database will be identical to the structure (schema) of the Agency's existing on-premise File Maker database.

In Phase 3 of the project, project staff will upload a copy of the Agency's on-premise File Maker database to the new File Maker Cloud database created in Phase
2. Project staff will then verify the success of the database transfer to the cloud via a series of verification checks.

Background

The Agency desires to modernize its database infrastructure by moving to File Maker Cloud. To do this, the Agency needs project staff to access its instance of File Maker Server v13 and backup the database running on it, create a new instance of its database on the File Maker Cloud platform, and then transfer a copy of its existing on-premise File Maker database to File Maker Cloud.

The Agency's existing on-premise database has approximately 7,300 records. Each record has the same forty-five (45) fields:

• 25 Text fields
• 9 Number fields
• 4 Date fields
• 4 Calculation fields
• 3 Summary fields

The database does not appear to have any container fields. The Agency already has a subscription to File Maker Cloud.

Scope of Work Phase 1:
Recover Admin-Level Access to File Maker Server

Project staff will gain administrative-level user access to the Agency's on-premise instance File Maker 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 File Maker database.

• Recover administrative-level user access to File Maker Server v13.
• Create one (1) set of administrative-level user access credentials to File Maker Server.
• Create two (2) backups of the database running on File Maker Server.

Phase 2:
Create New Database in File Maker Cloud Identical in Structure to Existing On-Premise Database

• Project staff will create a new (unpopulated) database on the File Maker Cloud platform that duplicates the structure (schema) of the Agency's existing on-premise File Maker database.
• Create new database on File Maker Cloud duplicating the existing on-premisedatabase structure and function.

Phase 3:
Transfer a Copy of the On-Premise File Maker Database to File Maker Cloud

• Project staff will upload a copy of the Agency's on-premise File Maker database to the new File Maker 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 File Maker database copy for upload to File Maker Cloud

Remediate any pre-upload issues (if necessary)

Upload database copy to File Maker 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

Deliverables

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

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

New File Maker Cloud database identical in structure and function to existing on-premise File Maker database.

Populated and functional File Maker Cloud database.

Certification that all database records have successfully transferred to cloud.

Certification that all record data fields function properly.

Report on test of 350 nonsequential records.

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.

Experience

4 Years Required

Experience recovering File Maker Server access, experience working with File Maker Server and File Maker Cloud, and experience transferring on-prem File Maker databases to File Maker Cloud.

#J-18808-Ljbffr