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

Qualified 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.

📌 Oracle To AWS Database Migration Specialist (Hubballi)
🏢 SSD Shared Services
📍 Hubballi