Job Title: Analyst | Database Migration | Modernization Specialist | Mumbai | Technology Strategy & Transform
Database Migration | Kafka | Modernization Specialist (Oracle DB, MSSQL, Postgres SQL, MySQL) | Mumbai
We are seeking a Database Migration and Modernization specialist to lead the transformation, optimization and migration.
Focus entirely on profiling legacy architecture (Oracle DB, MSSQL, Postgres SQL, MySQL), refactoring schema/code, optimizing performance and migrating workloads to modern data platforms.
Core Responsibilities
- Database Migration and Re-platforming
- Lead end to end data migration projects from legacy system to modern platforms.
- Map source to target data schemas, convert complex data types and manage structural refactoring
- Advanced SQL Performance Tuning
- Profile and rewrite poorly performing queries, stored procedures and triggers across database.
- Analyse execution plans, design optimal indexing strategies.
- Database Modernization and Code refactoring
- Implement modern data practices, including zero-downtime schema migrations and integrating database changes into CI/CD pipelines
- Multi-Engine Expertise
- Deep Structural understanding of Oracle DB, MSSQL, Postgres SQL, MySQL
- Migration Utilities:
- Hands-on experience with schema conversion and data movement utilities (Oracle ODI, Oracle Golden gate, AWS and Azure Database Migration)
Soft Skills
- Proven track record of executing at least 2 major enterprise-scale database modernization.
- Problem Solving - Exceptional engineering mindset focused on code efficiency.
- Collaboration- Strong ability to work alongside Application developers, DevOps Engineers etc. to coordinate seamless system cutovers.