Associate Technical Architect - Data (Oracle)

About the role

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).

What you'll do

• 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

What you need

• 7–13 yrs of experience
• SQL
• AWS
• Python
• Shell scripting
• Oracle Database
• ETL
• Any graduate

Good to have

• Terraform
• Data warehousing
• CI/CD
• Redshift
• Jenkins
• Spark