Q

Quantiphi

AI-driven digital transformation and automation services

Associate Technical Architect - Data, Oracle

Database Administration +1Confirmed live in the last 24 hours
Full-timeNo salary listed

About the Job

Requirements

  • At least 7 years of experience in database administration and migration, including SQL Server, Oracle, or MySQL.
  • Strong hands-on experience with Oracle databases, including Exadata environments.
  • Experience with Oracle Data Integrator and legacy ETL workflows.
  • Expertise in Oracle performance tuning, partitioning, indexing, and transaction management.
  • Experience with Oracle migration tools such as Data Pump, RMAN, or GoldenGate; GoldenGate experience is preferred.
  • Experience migrating Oracle, SQL Server, and MySQL databases to AWS RDS, EC2, or Aurora.
  • Hands-on experience with AWS DMS and SCT for full-load and CDC replication.
  • Strong database administration experience, including high availability, disaster recovery, backup and restore, and 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 skills.

Responsibilities

  • Lead end-to-end Oracle database migrations from on-premises environments, 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 before migration.
  • Design and execute schema conversion and validation strategies, including Oracle to PostgreSQL or MySQL where applicable.
  • Use AWS DMS and SCT for full-load and continuous-replication migrations.
  • Work with ODI pipelines and existing ETL workflows to ensure compatibility or modernization on AWS using Glue or 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 on migration and post-migration stabilization.
  • Implement data validation, reconciliation, and rollback mechanisms.
  • Ensure compliance with security, governance, and regulatory standards, including GDPR and HIPAA.

Desired Qualifications

  • 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 using CodePipeline or Jenkins.
  • AWS Solutions Architect Associate or Data Engineer Associate certifications.
  • Experience mentoring teams and conducting knowledge-transfer sessions.
  • Experience with Infrastructure as Code using Terraform or CloudFormation.

About the Company

Quantiphi

AI-driven digital transformation and automation services

Quantiphi uses AI and digital engineering to help organizations transform by making products and operations smarter and safer. It partners with clients to understand their challenges and then designs and builds customized AI and automation systems—combining machine learning, data analytics, and software engineering—delivering them under long-term contracts with ongoing support, and collaborating with Google Cloud to integrate technologies. Compared with competitors, it provides end-to-end, tailored solutions across industries rather than one-off projects, backed by long-term relationships and strong technology partnerships to scale. Its goal is to embed AI into products and processes to improve customer experiences and overall efficiency.

Company size
1,001-5,000
Company stage
Series A
Total funding
$23.4M
Headquarters
Marlborough, MA
Founded
2013

Recently Posted Jobs

Explore more opportunities at Quantiphi

See more jobs