Overview
Remote
Accepts corp to corp applications
Contract - Independent
Contract - W2
Skills
aws
oracle
Golden Gate
Job Details
Responsibilities:
Assess current Oracle landscape (version, size, features, dependencies) and define target on Amazon RDS for Oracle.
Select and execute the migration approach (e.g., AWS DMS, Data Pump/expdp impdp, RMAN, or GoldenGate), with clear downtime and rollback strategies.
Design and document cutover plan and backup/restore/runbook procedures compatible with RDS.
Implement schema/data migration, validate data integrity, and tune performance post-move (SGA/PGA, SQL tuning, stats, indexing).
Configure monitoring/alerting (CloudWatch/Performance Insights), and hand off documentation and knowledge transfer.
Qualifications:
8+ years as an Oracle DBA with hands-on migrations to Amazon RDS for Oracle (19c+ preferred).
Strong with AWS DMS, Golden Gate, Data Pump and/or RMAN for low-downtime moves to AWS.
Experience with Oracle Multitenant (CDB/PDB) concepts and consolidation patterns.
Performance troubleshooting (AWR/ASH), space management, and RDS-specific operational patterns (parameter groups, maintenance windows, snapshots/PITR).
Familiarity with security in GovCloud contexts (KMS, encryption at rest/in transit, IAM integration patterns).
Familiarity with Terraform/CloudFormation for repeatable DB infrastructure setup.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.