Remote Senior Schema Evolution Architect

LX Pantos Indonesia; Abu Dhabi; Remote; AED 441,000 - 661,000; Full time

Benefits offered by this job

100% remote work

Professional development

Career advancement

Collaborative data-focused team

Job summary

LX Pantos Indonesia is seeking a Senior Schema Evolution Specialist to manage and modernize database schemas across distributed systems. You will lead migrations, ensure data integrity, and coordinate with engineering teams in a fully remote setting.

Responsibilities include designing versioning strategies, validating compatibility, and automating testing and deployment of schema changes. A strong background in SQL and NoSQL, plus migration tooling, is required.

Qualifications

• Bachelor's degree in Computer Science, Software Engineering, Information Technology, or a related field.
• 5–8 years of experience in database engineering, data architecture, schema management, or software development.
• Strong knowledge of database design, normalization, version control, and migration strategies.

Responsibilities

• Design and implement database schema changes, migrations, and versioning strategies.
• Ensure backward and forward compatibility across applications, services, and database versions.
• Develop safe migration procedures that minimize downtime and operational risk.
• Manage schema evolution across relational databases, NoSQL platforms, and data pipelines.
• Identify dependencies between database structures, application code, APIs, and downstream systems.
• Validate data integrity and consistency before, during, and after schema migrations.
• Collaborate with developers, database administrators, and data engineering teams to coordinate releases.
• Automate schema migration testing, deployment, rollback, and validation processes.
• Troubleshoot migration failures, compatibility issues, and data transformation errors.
• Establish documentation, governance standards, and best practices for schema management.

Skills

Database design

Schema migration

Data integrity

Backward-compatible releases

Distributed systems

Automation & testing

Remote work

Education

Bachelor's degree in CS/SE/IT

Tools

PostgreSQL

MySQL

Oracle

MS SQL Server

NoSQL databases

APIs

Job description

LX Pantos Indonesia is seeking a Senior Schema Evolution Specialist to manage and modernize database schemas across distributed systems. You will lead migrations, ensure data integrity, and coordinate with engineering teams in a fully remote setting.

Responsibilities include designing versioning strategies, validating compatibility, and automating testing and deployment of schema changes. A strong background in SQL and NoSQL, plus migration tooling, is required.