Job Description
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