Associate Technical Architect - Data (Oracle) at Quantiphi Inc

Bengaluru, karnataka, India -

Full Time

Start Date

Immediate

Expiry Date

19 Jul, 26

Salary

0.0

Posted On

20 Apr, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle Database, AWS, Database Migration, Oracle Data Integrator, Performance Tuning, Python, PySpark, SQL, AWS Glue, Amazon RDS, Amazon Aurora, Data Engineering, Shell Scripting, Database Administration, ETL Workflows, Schema Conversion

Industry

IT Services and IT Consulting

Description

While technology is the heart of our business, a global and diverse culture is the heart of our success. We love our people and we take pride in catering them to a culture built on transparency, diversity, integrity, learning and growth. If working in an environment that encourages you to innovate and excel, not just in professional but personal life, interests you- you would enjoy your career with Quantiphi! Role: Associate Architect Database Migration & Data Engineering Experience Level: 6 -14 Years 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. Experience with Oracle migration tools (Data Pump, RMAN, GoldenGate - preferred). Experience migrating Oracle, SQL Server, and MySQL databases to AWS (RDS, EC2, Aurora). Hands-on with AWS DMS and SCT for full load and CDC replication. Strong experience in database administration (HA, DR, backup/restore, schema conversion). Experience building pipelines using AWS Glue, PySpark, or Spark on EMR. Strong experience with S3-based data lakes and Glue Data Catalog. Strong SQL, Python/Pyspark, and shell scripting. Nice to Have: Experience with Aurora Global Database and cross-region replication. Familiarity with Oracle GoldenGate for real-time replication. Knowledge of Data Mesh architecture and cross-account data sharing in AWS. Experience with Redshift, Lake Formation, and modern data warehousing. Exposure to CI/CD pipelines for database and ETL deployments (CodePipeline, Jenkins). AWS certifications (Solutions Architect Associate / Data Engineer Associate). Experience mentoring teams and driving knowledge transfer sessions. Experience with Infrastructure as Code (Terraform / CloudFormation). What is in it for you: Make an impact at one of the world’s fastest-growing AI-first digital engineering companies. Upskill and discover your potential as you solve complex challenges in cutting-edge areas of technology alongside passionate, talented colleagues. Work where innovation happens - work with disruptive innovators in a research-focused organization with 60+ patents filed across various disciplines. Stay ahead of the curve—immerse yourself in breakthrough AI, ML, data, and cloud technologies and gain exposure working with Fortune 500 companies. If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us! Thank you for your interest in Quantiphi! We are a team that dreams together and collaborates to ensure success. We are currently looking for exceptional individuals who can join us and contribute to a fun, diverse and hybrid work culture. As a part of the Quantiphi family, you will get ample opportunities to learn, grow and interact with colleagues from varied experience and backgrounds around the globe. If this excites you, explore our current openings and apply to any job roles that suit and interest you. Quantiphi is an award-winning AI-first digital engineering company driven by the desire to reimagine and realize transformational opportunities at the heart of business. We solve the toughest and most complex business problems with the latest and cutting-edge technologies and to make this happen, we have a vibrant, diverse and talented set of professionals we proudly refer to as the Quantiphi family. Our culture is built on transparency, diversity, integrity, learning and growth. We are committed to provide our teams with an environment that helps them to learn, grow and flourish in their professional as well as personal lives.

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

Lead end-to-end Oracle database migrations from on-premises environments to AWS platforms while ensuring minimal downtime and data integrity. Design and implement secure, highly available database architectures and optimize data pipelines using AWS services.