Job Overview
Date Posted
Posted on 24th February 2026
Expiration Date
Expires on 25th April 2026
Salary
Negotiable
Job Categories
Senior Data-Management-EngineerSenior Data-Infrastructure-EngineerSenior Data-Integration-EngineerSenior ETL-EngineerDatabase Engineer-JobsSenior Data-Platform-EngineerSenior Data-EngineerSenior SAP-Data-Migration-Specialist
Seeking a Senior Database Migration Engineer to lead the migration of our enterprise geoscience product database from SQL Anywhere to PostgreSQL.
Seeking a Senior Database Migration Engineer to lead the migration of our enterprise geoscience product database from SQL Anywhere to PostgreSQL. The role requires deep expertise in relational databases, hands-on migration experience, and strong SQL optimization skills to ensure data integrity, performance, and seamless integration with the existing application stack.
Requirements
- Analyze the existing SQL Anywhere database schema, objects, dependencies, and data structures.
- Convert proprietary SQL Anywhere functions, stored procedures, triggers, and queries into ANSI-compliant and PostgreSQL-compatible SQL.
- Redesign and optimize database schemas to align with PostgreSQL best practices.
- Develop, execute, and validate data migration scripts for large production datasets.
- Ensure data integrity, accuracy, and consistency throughout and after migration.
- Perform post-migration validation, reconciliation, and performance benchmarking.
- Optimize indexing strategies and improve query execution performance in PostgreSQL.
- Collaborate closely with application developers to integrate the migrated database with the existing application stack.
- Troubleshoot migration issues and provide long-term database optimization recommendations.