[Remote] Database Migration Consultant (SQL Anywhere → PostgreSQL)

Note: The job is a remote job and is open to candidates in USA. LMKR is seeking an experienced Database Migration Consultant to lead the end-to-end migration from SAP SQL Anywhere to PostgreSQL. This role involves full ownership of migration quality, including schema modernization, data accuracy, performance optimization, and production-grade validation, while collaborating closely with development teams. Responsibilities • Analyze and understand the existing SAP SQL Anywhere database architecture and schema, including integrations with GeoGraphix applications • Migrate SQL Anywhere–specific proprietary constructs to ANSI SQL compatible with PostgreSQL • Modernize and optimize database schemas by removing trivial views and triggers, and tuning tables, indexes, and constraints for PostgreSQL performance • Design and build migration tools, scripts, and services to migrate existing GeoGraphix projects from SQL Anywhere to PostgreSQL • Collaborate with development teams to integrate PostgreSQL with the GeoGraphix Data Access Layer, Data Ingestion framework, and application layers • Own validation of migration outcomes, ensuring data correctness, referential integrity, schema consistency, and functional equivalence • Develop a comprehensive migration test plan covering validation scope, edge cases, and risk areas • Design and implement repeatable validation suites and automated test scripts with integration-test–level rigor • Reconcile and compare source and target datasets to identify data loss, truncation, type mismatches, or semantic differences • Provide auditable evidence of migration accuracy and document known limitations or deviations clearly Skills • Experienced • Strong expertise in relational database design and large-scale database migrations • Hands-on experience with SAP SQL Anywhere / SQL Server and PostgreSQL • Proficiency in ANSI SQL and database performance tuning • Strong skills in building migration tooling, automation, and validation frameworks • Excellent analytical, documentation, and cross-team collaboration skills • Proven experience leading or owning database migration projects end-to-end • Demonstrated experience in migration validation, data reconciliation, and quality assurance • Bachelor's degree in Computer Science, Information Systems, or a related field • Relevant database or cloud certifications Company Overview • Founded in 1994, LMKR is a global provider of Geo-Technology and Information Technology services to businesses and governments. It was founded in 1994, and is headquartered in Dubai, Dubai, ARE, with a workforce of 201-500 employees. Its website is Apply tot his job