Database Specialist in Mimer SQL and Microsoft SQL Server
Liam Tran
HR Administrator
Efterfrågade kompetenser
Om tjänsten
Role Summary
A public-sector organization is seeking an experienced Database Specialist for a consulting assignment focused on migrating historical microbiology data from a Mimer SQL database running in a Windows environment to Microsoft SQL Server.
The specialist will assess the existing database structure, plan and execute the migration, and ensure that data integrity and traceability are maintained throughout the transition. The role also includes producing technical documentation and transferring knowledge to support a secure, controlled, and quality-assured handover to the new database environment.
Key Responsibilities
- Map and analyze the existing Mimer SQL database schema and its data structures.
- Develop a detailed migration approach for transferring historical microbiology data to Microsoft SQL Server.
- Plan, execute, validate, and quality-assure the database migration.
- Develop and optimize SQL scripts required for data extraction, transformation, loading, and verification.
- Ensure data integrity, accuracy, completeness, and traceability before, during, and after migration.
- Identify and manage technical dependencies and migration-related risks.
- Produce comprehensive technical documentation covering the database structure, migration process, validation activities, and operational considerations.
- Provide knowledge transfer to relevant technical and operational stakeholders to support the new database environment.
Technical Stack & Requirements
- Mimer SQL: Documented practical experience is mandatory.
- Microsoft SQL Server: Documented experience with SQL Server database environments is mandatory.
- Database migration: Demonstrated experience migrating data between different database management systems is required.
- SQL development: Proven ability to develop SQL queries and scripts for migration, transformation, and validation activities.
- Windows Server: Documented experience working with databases in Windows Server environments.
- Documentation: Experience producing clear and maintainable technical documentation.
- Advantageous technologies: Experience with Analytix or SAS Viya is considered beneficial.
Qualifications & Experience
The successful consultant must have documented experience with Mimer SQL, Microsoft SQL Server, migrations between database management systems, SQL development, Windows Server environments, and technical documentation. Experience with laboratory information systems, including LIS or LIMS, is advantageous. Knowledge of clinical microbiology, healthcare environments, or historical laboratory data is also desirable. Previous work within a regional, government, or comparable public-sector organization would be beneficial.
Work Logistics & Location
This is a consulting assignment within a public-sector organization. The work location, work arrangement, assignment duration, and expected workload have not been specified.