[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 http://www.lmkr.com.

Apply Now

Apply Now