Associate Technical Architect - Data (Oracle)

Location: Bangalore/Mumbai

• Description:
• ​Candidate with strong Oracle expertise to lead the rehosting and modernization of enterprise databases into AWS. This role will primarily focus on Oracle database optimization, transaction retention, and seamless migration continuity, especially in environments leveraging services/Tools like Oracle Exadata and Oracle Data Integrator (ODI).
• The ideal candidate combines deep experience in Oracle database platforms, large-scale migration strategies, and modern AWS data engineering practices, ensuring minimal downtime, data integrity, and performance optimization during migration.
• Key Responsibilities
• Lead end-to-end Oracle 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 lakes and metadata using Glue Data Catalog.
• Collaborate with application, infrastructure, and analytics teams for smooth migration and post-migration stabilization.
• Implement data validation, reconciliation, and rollback mechanisms.
• Ensure compliance with security, governance, and regulatory standards (GDPR, HIPAA, etc.).
• Skills:
• 7+ years of experience in database administration and migration (SQL Server, Oracle, MySQL).
• Strong hands-on experience with Oracle databases, including Exadata environments.
• Experience with Oracle Data Integrator (ODI) and legacy ETL workflows.
• Proven expertise in Oracle performance tuning, partitioning, indexing, and transaction management.