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!
