Quantiphi Logo

Quantiphi

Associate Technical Architect - Data (Oracle)

Posted 4 Days Ago
Remote
Hiring Remotely in Canada
Senior level
Remote
Hiring Remotely in Canada
Senior level
Lead the migration of Oracle databases to AWS, ensuring minimal downtime and performance optimization. Responsibilities include database administration, schema conversion, and collaboration with various teams for smooth transitions.
The summary above was generated by AI

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!

About Quantiphi:

  • Quantiphi is an award-winning, AI-First digital engineering and consulting company focused on delivering high-impact Services and Solutions that help organizations solve what truly matters. We partner with enterprises to reimagine their businesses through intelligent, scalable, and transformative AI—driving measurable outcomes at the very core of their operations.
  • Since our founding in 2013, Quantiphi has tackled some of the world’s most complex business challenges by combining deep industry expertise, disciplined cloud and data engineering practices, and cutting-edge applied AI research. Our work is rooted in delivering accelerated, quantifiable business value—not just technology for technology’s sake.
  • Headquartered in Boston, Quantiphi is a global organization with 4,000+ professionals serving clients across key industry verticals, including BFSI, Healthcare & Life Sciences, CPG, MFG, TME etc. As an Elite and Premier partner to leading cloud and AI platforms such as NVIDIA, Google Cloud, AWS, and Snowflake, we build and deliver enterprise-grade AI services and solutions that create real-world impact.

We have been recognized with:

  • 3x AWS AI/ML award wins.
  • 3x NVIDIA Partner of the Year titles.
  • Recognized Leaders by Gartner, Forrester, IDC, ISG, Everest Group and other leading analyst and independent research firms.
  • We offer first-in-class industry solutions across Healthcare, Financial Services, Consumer Goods, Manufacturing, and more, powered by cutting-edge Generative AI and Agentic AI accelerators.
  • We have been certified as a Great Place to Work for the third year in a row- 2021, 2022, 2023.

Be part of a trailblazing team that’s shaping the future of AI, ML, and cloud innovation. Your next big opportunity starts here!

For more details, visit: Website or LinkedIn Page.

Role: Associate Architect Database Migration & Data Engineering

Experience Level: 7+ years

Employment type: Full Time

Location: Remote (USA/Canada)

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!

Top Skills

Amazon Rds
Aurora Postgresql
AWS
Aws Dms
Ec2
Emr
Glue
Oracle
Oracle Data Integrator
Pyspark
Python
SQL

Similar Jobs

An Hour Ago
In-Office or Remote
Calgary, AB, CAN
Expert/Leader
Expert/Leader
Information Technology • Business Intelligence • Consulting
The Sales Executive will drive strategic sales of IT services within Alberta's public sector, managing complex deals and engaging senior executives. Responsibilities include building client relationships, pursuing new opportunities, and achieving sales targets.
Top Skills: Cloud TransformationCybersecurityData And AiDigital ModernizationEmr/Ehr IntegrationManaged Services
6 Hours Ago
Remote or Hybrid
Senior level
Senior level
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The Solution Sales Executive supports market success by overseeing strategy and solution wins in specialty areas, coaching account teams, and aligning with customer needs for digital transformation.
Top Skills: AI
11 Hours Ago
Easy Apply
Remote
2 Locations
Easy Apply
Senior level
Senior level
Artificial Intelligence • Enterprise Web • Software • Design • Generative AI
As a Senior Application Security Engineer, you will secure Webflow's applications, implement secure development practices, and mentor junior engineers.
Top Skills: Ai Coding AgentsApplication SecurityDastPenetration TestingSastSca Supply ChainSecure CodingThreat Modeling

What you need to know about the Calgary Tech Scene

Employees can spend up to one-third of their life at work, so choosing the right company is crucial, not just for the job itself but for the company culture as well. While startups often offer dynamic culture and growth opportunities, large corporations provide benefits like career development and networking, especially appealing to recent graduates. Fortunately, Calgary stands out as a hub for both, recognized as one of Startup Genome's Top 100 Emerging Ecosystems, while also playing host to a number of multinational enterprises. In Calgary, job seekers can find a wide range of opportunities.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account