Senior Database Migration Engineer

LMKR is a global technology company providing exploration and production software, data management, and consulting services to the oil and gas industry, while also expanding into clean energy and intelligent transportation.

LMKR

Employee count: 501-1000

Pakistan only

Stay safe on Himalayas

Never send money to companies. Jobs on Himalayas will never require payment from applicants.

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.

Apply now

Please let LMKR know you found this job on Himalayas. This helps us grow!

Apply now

About the job

Apply before

Apr 25, 2026

Posted on

Feb 24, 2026

Job type

Full Time

Experience level

Senior

Location requirements

Pakistan

Hiring timezones

Pakistan +/- 0 hours

About LMKR

Learn more about LMKR and their company culture.

View company profile

What began in 1994 as a focused endeavor in petroleum technology has evolved into a global powerhouse of innovation. LMKR started its journey with a clear mission: to provide cutting-edge geoscience and data management solutions to the oil and gas industry. Over the decades, the company has not only solidified its standing as a leader in exploration and production (E&P) software but has also boldly expanded its horizons. From its early days of developing reservoir-centric interpretation tools, LMKR has grown into a diversified technology company, now driving advancements in sectors as varied as clean energy, intelligent transportation, and agri-tech.

Today, LMKR stands as a testament to the power of adaptability and vision. With a global footprint that spans North America, Europe, the Middle East, and Asia Pacific, the company serves Fortune 500 companies and government organizations in over 80 countries. Its portfolio has blossomed to include the renowned GeoGraphix suite, smart urbanization solutions, and AI-driven analytics. Through strategic acquisitions and a relentless commitment to research and development, LMKR continues to push the boundaries of what is possible, transforming complex data into actionable knowledge and shaping a smarter, more connected future for industries worldwide.

Tech stack

Learn about the tools and technologies that LMKR uses to build, market, and sell its products.

View tech stack

Node.js

Python

Java

PHP

GraphQL

NumPy

Pandas

Oracle

JBoss

LMKR employees can create an account to update this tech stack.

Employee benefits

Learn about the employee benefits and perks provided at LMKR.

View benefits

Disability Insurance

Disability insurance coverage.

Life Insurance

Life insurance coverage for employees.

Casual Dress/Atmosphere

Casual dress code and work atmosphere.

Paid Holidays / Vacation

Paid time off for holidays and vacation.

View LMKR's employee benefits

Apply now

Please let LMKR know you found this job on Himalayas. This helps us grow!

Apply now