Senior Database Migration Engineer
Job Overview
Job Title
Senior Database Migration Engineer
Company
LMKR
Location
Pakistan
Job Type
Full-Time
Experience
Senior
About This Role
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.
Originally posted on Himalayas
Why This Job Might Be a Good Fit
- Fully remote full-time position
- Senior devops role at LMKR
- Open to candidates in Pakistan
Similar Remote Jobs
Serasa Experian
More Remote Jobs by Location
More Remote Devops Jobs
Get Daily Remote Job Alerts Before Others Do
Join 12,000+ remote professionals
No spam, unsubscribe anytime. We respect your privacy.
Frequently Asked Questions
Is this position fully remote?
Yes, this role is listed as a remote position. You can work from anywhere within the specified location requirements.
How do I apply for this job?
Click the "Apply on Company Website" button to be redirected to the official application page.
Are international applicants welcome?
Check the location requirements listed above. Some positions are restricted to specific regions.
When was this job posted?
The posting date is shown in the Quick Facts sidebar. We update our listings daily to ensure accuracy.
About LMKR
LMKR