Associate Architect - Database Specialist (SQL/Oracle)

Role : Associate Architect - Database Specialist (SQL/Oracle)

Experience : 7-13 Years

Location : Mumbai/Bangalore

Key Responsibilities

• Lead end-to-end Oracle/SQL server database migration from on-prem (including Exadata) to AWS platforms such as Amazon RDS, EC2, and Aurora PostgreSQL-compatible environments
• Ensure transaction continuity, CDC-based replication, and minimal downtime cutovers
• Perform Oracle database performance tuning, indexing strategies, and query optimization prior to migration
• Design and execute schema conversion and validation strategies (Oracle to PostgreSQL/MySQL where applicable)
• Leverage AWS DMS and SCT for full load and continuous replication migrations
• Work with ODI pipelines and existing ETL workflows, ensuring compatibility or modernization on AWS (Glue/EMR)
• Design and implement secure, highly available...