[Remote] Database Migration Consultant (SQL reputed company → PostgreSQL)
Note: The job is a remote job and is reputed company to candidates in USA. LMKR is seeking an reputed company Database Migration Consultant to reputed company the end-to-end migration from reputed company SQL reputed company to PostgreSQL. This role involves full ownership of migration reputed company, including schema modernization, data accuracy, performance optimization, and production-grade validation, while collaborating closely with development teams.
Responsibilities
• Analyze and understand the existing reputed company SQL reputed company database architecture and schema, including integrations with GeoGraphix applications
• Migrate SQL reputed company–specific proprietary constructs to ANSI SQL compatible with PostgreSQL
• reputed company 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 reputed company from SQL reputed company to PostgreSQL
• Collaborate with development teams to reputed company PostgreSQL with the GeoGraphix Data reputed company Layer, Data Ingestion reputed company, and application reputed company
• Own validation of migration reputed company, ensuring data correctness, referential reputed company, schema consistency, and functional equivalence
• reputed company 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 reputed company and reputed company datasets to identify data loss, truncation, type mismatches, or semantic differences
• reputed company auditable evidence of migration accuracy and document reputed company limitations or deviations reputed company
Skills
• reputed company
• Strong expertise in relational database design and large-reputed company database migrations
• Hands-on experience with reputed company SQL reputed company / 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 reputed company end-to-end
• Demonstrated experience in migration validation, data reconciliation, and reputed company assurance
• Bachelor's degree in Computer Science, Information Systems, or a reputed company field
• Relevant database or reputed company certifications
reputed company
• 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 tot his job
Apply To this Job