Job Summary:
We are 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.
Job Responsibilities:
- 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.
Required Skills:
- Strong hands-on expertise in PostgreSQL (or SQL Server with proven migration experience)
- Advanced SQL skills, including stored procedures, triggers, constraints, and indexing
- Strong understanding of query optimization, performance tuning, and execution plans
- Experience working with large schemas and enterprise-scale production databases
- Proven ability to troubleshoot complex database and data consistency issues
- Strong analytical and documentation skills
Experience:
- 7+ years of hands-on experience working with relational database systems
- Demonstrated experience in database migration projects, preferably involving legacy systems
- Experience collaborating with application development teams during database transitions
- Exposure to enterprise or product-based systems with long-term data lifecycles
Education / Qualification:
- Bachelor’s degree in Computer Science, Software Engineering, Information Systems, or a related field
- Relevant database certifications (PostgreSQL, SQL Server, etc.) will be a plus
Location:
- Pakistan (Remote)
Skills Required
- 7+ years of hands-on experience working with relational database systems
- Strong hands-on expertise in PostgreSQL or SQL Server with proven migration experience
- Advanced SQL skills, including stored procedures, triggers, constraints, and indexing
- Strong understanding of query optimization, performance tuning, and execution plans
- Experience working with large schemas and enterprise-scale production databases
- Proven ability to troubleshoot complex database and data consistency issues
- Strong analytical and documentation skills
What We Do
Founded in 1994 and built on a strong geoscience and data management footprint, LMKR has evolved into a premier technology company expanding its reach to Clean Energy, Transportation, Agri-Tech and Digital Media. LMKR is a private business with global operations serving fortune 500 companies, SMEs and government regulatory organizations in over 80 countries. The company offers a diverse portfolio of products and services through a combination of online and onsite solutions. For more information on LMKR visit: www.lmkr.com Like us on Facebook: /lmkrnews Follow us on twitter: @lmkrnews Subscribe to our YouTube channel: https://www.youtube.com/c/LMKRChannel
.png){kind=logo}
