Overview
Job Details
Oracle DBA / Migration Engineer (OnPrem-to-AWS) | 453245
DETAILS
Location: 100% Remote
Position Type: 2M+ Contract
Hourly / Salary: to $95W2
JOB SUMMARY
Vaco Technology is currently seeking an Oracle DBA / Migration Engineer (OnPrem-to-AWS) for a 2M+ Contract that is 100% remote. The Oracle DBA / Migration Engineer with strong expertise in Oracle 19C Database Administration and AWS DMS (AWS Database Migration Service). The Oracle DBA / Migration Engineer will lead the migration of OnPrem Oracle Databases hosted on AIX Servers to AWS Cloud Infrastructure. The Oracle DBA / Migration Engineer must possess extensive experience in homogeneous / heterogeneous migrations, schema conversions, and cloud-native DB deployments to ensure secure, high-performance, and fault-tolerant data environments in the cloud.
- Oracle-to-AWS Migration – Analyzing / Assessing Oracle 19c Environments on AIX Servers | Designing Optimized Migration Strategy to AWS
- Migration Execution – Planning / Executing Migrations using AWS DMS / Oracle RMAN / Data Pump / Native + Third-Party Tools | Performing Homogeneous (Oracle-to-Oracle) / Heterogeneous (Oracle-to-Aurora / PostgreSQL) Migrations | Schema Conversions
- Schema Assessment – Utilizing AWS SCT for Schema Transformation / Compatibility Assessment
- Performance Optimization – Optimizing Pre-/Post-Migration DB Performance | Indexing / Partitioning / Tuning
- Backup / Disaster Recovery – Ensuring Robust Backup / Disaster Recovery Mechanisms During Migrations
- Security / Governance – Implementing Database Security / Compliance / Cloud Governance Best Practices
- Collaboration – AWS Cloud Engineers / App Teams / Stakeholders | Ensuring Smooth Delivery
- Documentation – Maintaining Detailed Migration Procedure Docs / Fallback Plans / Performance Tuning
- Post-Migration Support – Providing Knowledge Transfer / Ongoing Support to Operations Teams
About the Project: This project will be focused on executing end-to-end migrations of Oracle 19c databases from OnPrem AIX servers to AWS (EC2 / RDS / Aurora). The Oracle DBA / Migration Engineer requires hands-on expertise with Oracle RMAN, Data Pump, AWS DMS, and AWS SCT to support both homogeneous (Oracle-to-Oracle) and heterogeneous (Oracle-to-Aurora PostgreSQL) migrations. The Oracle DBA / Migration Engineer will lead schema conversion, data replication, performance tuning, and ensure secure, compliant database deployments in the cloud. The Oracle DBA / Migration Engineer must be proficient in AIX shell scripting, PL/SQL, and performance tuning, with familiarity in Terraform / CloudFormation and CI/CD pipeline integration preferred.
JOB REQUIREMENTS
- Oracle 19C DBA (hands-on) –Installation / Backup & Recovery / Patching / Monitoring | Performance Tuning / Query Optimization (expertise) | Database Architecture (ASM / RAC optional / RMAN / Data Guard)
- PL/SQL (hands-on) – Writing / Optimizing for Application Support / Migration Validation | Adapting / Debugging / Optimizing PL/SQL during Schema Conversion | Implementing Automation)
- AWS Cloud Platform / Migration Tools – EC2 / RDS / CLI / Aurora / DMS / SCT
- AWS DMS (hands-on) – Designing / Configuring / Executing Data Migration Tasks for Full Load / CDC | Creating Source / Target Endpoints | Monitoring Migration Jobs | Validating Data Integrity / Sync | Troubleshooting Performance / Data Consistency Issues (DMS Task Failures / Latency)
- AWS SCT (hands-on) – Performing Schema Compatibility Assessments for Oracle-to-Aurora Migrations | Converting Oracle DDL / PL/SQL to PostgreSQL-Compatible Objects | Reviewing / Editing Auto-Converted Code | Manually Editing Incompatible Code | Coordinating Converted Schemas Testing with App / Dev Teams
- UNIX / AIX UNIX-Based Systems (expertise) – Hands-on Scripting (BSH / KSH / automation)
- OnPrem-to-Cloud Migrations – Experience Migrating Large-Scale Production Databases to AWS (EC2 / RDS / Aurora)
Determining compensation for this role (and others) at Vaco/Highspring depends upon a wide array of factors including but not limited to the individual’s skill sets, experience and training, licensure and certifications, office location and other geographic considerations, as well as other business and organizational needs. With that said, as required by local law in geographies that require salary range disclosure, Vaco/Highspring notes the salary range for the role is noted in this job posting. The individual may also be eligible for discretionary bonuses, and can participate in medical, dental, and vision benefits as well as the company’s 401(k) retirement plan.