Senior Schema Evolution Specialist

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

Job Title: Senior Schema Evolution Specialist

Location: United Arab Emirates (Remote)

Employment Type: Full-Time

Work Arrangement: 100% Remote — Work From Home

About the Role

We are seeking an experienced Senior Schema Evolution Specialist to manage database schema changes, ensure data compatibility, and support reliable system modernization. The ideal candidate will have strong expertise in database design, schema migration, data integrity, and backward-compatible changes across distributed applications.

Key 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.

Qualifications and Experience

• 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.


• Experience with SQL databases such as PostgreSQL, MySQL, Oracle, or Microsoft SQL Server.


• Familiarity with NoSQL databases, data serialization formats, and API compatibility.


• Experience with migration tools, automated deployment pipelines, and database testing.


• Understanding of distributed systems, data integrity, and backward-compatible software releases.


• Strong analytical, problem-solving, and communication skills.


• Ability to work independently in a fully remote environment.

What We Offer

• Competitive salary based on experience and qualifications.


• 100% remote work with no routine office attendance.


• Professional development and career advancement opportunities.


• Collaborative environment focused on data reliability and technical innovation.