Associate Technical Architect - Data (Oracle)
BengaluruFull-time7–13 yrsPosted over a month ago
Senior software engineering role at Quantiphi in Bengaluru. Needs 7+ years.
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
- SQL
- AWS
- Python
- Shell scripting
- Oracle Database
- ETL
Good to have
- Terraform
- Data warehousing
- CI/CD
- Redshift
- Jenkins
- Spark