Oracle To AWS Database Migration Specialist

MUST HAVE Mandatory Skills for each technology (All MUST) 10 Year of Hands on experience with Oracle Database Minimum 5 Years working with Amazon database platforms (Aurora PostgreSQL, Amazon RDS & PostgreSQL) Minimum 5 Years into Migration from on-premises Oracle to AWS managed cloud Database Should have excellent communication (written & verbal) for client communication. Required Skills & Qualifications Technical Skills Strong experience with: Oracle Database (architecture, PL/SQL, performance tuning) PostgreSQL (preferably Aurora PostgreSQL and RDS PostgreSQL) Hands-on experience with: AWS DMS, AWS SCT, ora2pg Deep understanding of: Database migration methodologies Schema conversion and data transformation Replication, failover, and disaster recovery strategies Familiarity with: AWS services (VPC, IAM, CloudWatch, S3, etc.) Linux/Unix environments Professional Experience 5+ years of experience in database administration, migration, or cloud data engineering. Proven track record of executing large-scale database migrations. Experience working in client-facing roles and cross-functional teams. Soft Skills Strong analytical and problem-solving abilities. Excellent communication and stakeholder management skills. Ability to document complex technical solutions clearly. Proactive and detail-oriented approach. Preferred Qualifications AWS certifications (e.g., AWS Certified Database Specialty, Solutions Architect). Experience with automation and scripting (Python, Shell, etc.). Job Summary We are seeking a skilled Database Migration Specialist to lead and execute enterprise-scale database migration initiatives from on-premises Oracle environments to AWS-managed database platforms such as Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL. The role requires deep expertise in database architecture, migration strategies, cloud-native design, and data replication technologies. The ideal candidate will collaborate closely with client platform teams, design robust migration strategies, and ensure seamless, secure, and high-performance transitions with minimal downtime. Key Responsibilities 1. Assessment & Discovery Collaborate with client platform and database teams to: Understand existing on-premises Oracle database architecture, schema design, dependencies, and workloads. Analyze database size, performance characteristics, and integration points. Conduct schema and code assessment for compatibility with PostgreSQL. Identify potential migration risks, constraints, and optimization opportunities. 2. Migration Planning & Strategy Design and document end-to-end migration strategies from: Oracle Amazon Aurora PostgreSQL Oracle Amazon RDS for PostgreSQL Define migration approaches including: Homogeneous vs heterogeneous migration considerations Downtime minimization strategies Phased vs big-bang migration Evaluate and recommend appropriate tools and methodologies. 3. Architecture & High Availability Design Design and implement cloud-native database architectures including: Regional replication strategies Read replicas (read-only scaling) Automated failover mechanisms Ensure high availability, fault tolerance, and disaster recovery readiness. Optimize database performance, storage, and cost efficiency in AWS environments. 4. Migration Execution Perform full-load database migration using tools such as: AWS Schema Conversion Tool (SCT) ora2pg Execute Change Data Capture (CDC) pipelines using AWS Database Migration Service (DMS). Validate schema, data integrity, and application compatibility post-migration. Troubleshoot and resolve migration-related issues. 5. Documentation & Governance Prepare detailed technical documentation including: High-Level Design (HLD) documents Migration runbooks Database cutover strategies Present architecture and migration plans for stakeholder and architecture board approvals. Ensure compliance with enterprise standards, security policies, and best practices. Disclaimer : This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.