Database Migration Consultant (SQL Anywhere → PostgreSQL) jobs in United States
cer-icon
Apply on Employer Site
company-logo

LMKR · 8 hours ago

Database Migration Consultant (SQL Anywhere → PostgreSQL)

positionUnited States
timeFull-time
remoteRemote
senioritySenior Level

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.

Oil & Energy

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

Qualification

Database migration expertiseSAP SQL AnywherePostgreSQLANSI SQLDatabase performance tuningMigration toolingAnalytical skillsDocumentation skillsCollaboration skills

Required

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

Preferred

Bachelor's degree in Computer Science, Information Systems, or a related field
Relevant database or cloud certifications

Company

LMKR

twittertwittertwitter
company-logo
Founded in 1994, LMKR is a global provider of Geo-Technology and Information Technology services to businesses and governments.
dateFounded in 1994
location
Dubai, Dubai, ARE
people-size201-500 employees
web-link
http://www.lmkr.com

Funding

Current Stage
Growth Stage

Recent News

ProPakistani
LMKR Partners with LG&HTP to Modernize Karachi’s Property Tax System
2025-01-18
Pakistan Observer
LMKR partners with LG&HTP to modernize Karachi’s property tax system
2025-01-16
Company data provided by crunchbase