Associate Architect - Database Specialist (SQL/Oracle)
Location
Mumbai, Maharashtra
Job Type
Full-time
Category
Computer Occupations
Posted
June 03, 2026
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 database architectures on AWS
Build and optimize data pipelines using AWS Glue, PySpark, or EMR
Manage S3-based data...
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 database architectures on AWS
Build and optimize data pipelines using AWS Glue, PySpark, or EMR
Manage S3-based data...