Database Migration & Modernization Specialist

Tecnoprism; Mumbai; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Tecnoprism is seeking a Database Migration & Modernization Specialist to lead end-to-end migration projects from planning through execution. The role covers cross-platform migrations across Oracle, MSSQL, PostgreSQL and MySQL, with emphasis on schema mapping and performance optimization.

You will refine code, refactor database objects, and apply leading migration tools in on-site client environments. Candidates should demonstrate hands-on experience with GoldenGate, ODI, AWS DMS and Azure DMS,

Qualifications

• End-to-end enterprise-scale database migration and modernization programs.
• Migration and re-platforming across Oracle, MSSQL, PostgreSQL, MySQL.
• Schema conversion, structural refactoring, and source-to-target data mapping.
• Advanced SQL performance tuning, query optimization, execution plan analysis, indexing strategy design.
• Database code refactoring involving stored procedures, triggers, and database objects.
• Hands-on experience with migration utilities such as Oracle GoldenGate, Oracle ODI, AWS DMS, Azure DMS.

Skills

End-to-end migration

Migration & re-platforming

Schema conversion

SQL performance tuning

Query optimization

Execution plan analysis

Indexing strategy

Stored procedures

Triggers

Database objects

Migration utilities

Tools

Oracle GoldenGate

Oracle ODI

AWS Database Migration Services

Azure Database Migration Services

Job description

Requirement: Database Migration & Modernization Specialist

We are specifically looking for candidates with strong and demonstrable experience in:

• End-to-end enterprise-scale database migration and modernization programs
• Migration and re-platforming across Oracle, MSSQL, PostgreSQL, and MySQL
• Schema conversion, structural refactoring, and source-to-target data mapping
• Advanced SQL performance tuning, query optimization, execution plan analysis, and indexing strategy design
• Database code refactoring involving stored procedures, triggers, and database objects
• Hands-on experience with migration utilities such as:
• Oracle GoldenGate
• Oracle ODI
• AWS Database Migration Services (DMS)
• Azure Database Migration Services

Work Location (Applicable for Both Requirements)

Candidates should be comfortable working from any of the following client locations:

• BKC
• Malad
• Turbhe

Work Conditions

• 100% Work From Office
• Working Hours: 9:00 AM 6:00 PM
• Alternate Saturdays working as per the banking calendar