Database Migration Consultant – SQL Anywhere, PostgreSQL
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Database Migration Consultant leading the migration from SAP SQL Anywhere to PostgreSQL for GeoGraphix applications. Ensuring migration quality through schema modernization and validation of migration outcomes.
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.
Requirements:
- 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.
- Prior experience working with complex enterprise or geospatial data platforms is a plus.
- Bachelor’s degree in Computer Science, Information Systems, or a related field (preferred).
Similar Jobs
Managed Application Services Consultant
Managed Application Services Consultant at Evotix supporting clients in optimizing their EHS software. Collaborating with teams to ensure smooth application performance and enhancing customer solutions.
Principal Business Solution Consultant
Customer Solution Consultant at CSG focusing on telecommunications to deliver innovative solutions. Engage with clients to align strategic goals with CSG solutions.
Student Admissions Consultant – Bildungsberatung, Kundenbetreuung
Student Admissions Consultant at StartSteps guiding prospective students through admissions for online tech programs. Responsible for support and relationship building with public institutions.
Global Travel Consultant
Global Travel Consultant designing unforgettable escapes for adventure-seeking clients. Remote work opportunity with flexible schedule and no experience needed.
Global Travel Consultant
Global Travel Consultant working remotely to design unforgettable travel experiences for clients. No experience needed, just passion and bold energy for adventure.
Global Travel Consultant
Global Travel Consultant at Affinity Travels, designing unforgettable travel experiences for clients. Passion-driven role allowing for remote work and flexible schedules.
Energy Consultant
Independent Partner helping households save on everyday bills by introducing essential services like energy and broadband. Flexible self-employed role with training and support.
Technical PS Consultant
Professional Services Consultant responsible for driving customer success and effective Barista platform implementations. Collaborates with customers on requirements and guides deployment for optimal experience.
Technical PS Consultant
Professional Services Consultant ensuring successful implementations of Barista solutions. Partnering with customers to translate requirements into practical solutions and improve employee experience.
Clinical Consultant – Xper IM, Enterprise Informatics
Clinical Consultant optimizing healthcare IT solutions with Xper Hemodynamics. Assisting in training, workflow assessments, and customer support with a focus on clinical impact.
Senior Archiving & ILM Consultant
Senior Archiving & ILM Consultant specializing in SAP solutions, analyzing requirements and implementing concepts for data archiving.
Business Coach, Consultant – Exit Strategy
Business Coach assisting small to mid-sized businesses in increasing profit and value for sale. Engaging with clients through 1:1 consulting based on proprietary Exit Factor method.
Senior Consultant – Dynamics 365 F&SCM, Manufacturing
Join Argano as a Dynamics 365 F&SCM – Manufacturing Senior Consultant. Drive impactful solutions by collaborating with clients to optimize their business processes.
Consultant
Consultant at Argano, LLC devising methods for identifying data patterns and trends. Implementing Anaplan and mentoring junior team members in data integration and visualization.
Senior EAM Consultant – S/4HANA, Cloud, Innovation
Senior EAM Consultant driving SAP S/4HANA projects and innovative solutions in a digital environment at Evora IT Solutions.
Senior Media Consultant
Media Consultant creating 360° media strategies for clients. Covering analysis, implementation, and budget management for effective campaigns.
Energy Billing Consultant – m/f/d
SAP Consultant for the energy sector creating innovative solutions and optimizing billing processes. Joining a strong team and engaging in exciting SAP projects.
Tax Assistant, Consultant
Steuerassistent:in managing strategic tax consulting for clients including companies and wealthy individuals. Collaborating with tax experts on financial planning and legal frameworks.
Senior PS Consultant
Senior PS Consultant providing technical support for custom applications built on Genesys Cloud. Collaborating with customers for troubleshooting and implementation activities.
Professional Product Data Consultant – m/f/d
Product Data Consultant ensuring high-quality, scalable product data at INSPORT Digital GmbH. Collaborating with content, IT, and external partners to automate product data processes.