Oracle DBA – Oracle to Amazon RDS Migration (GovCloud) (GC/Citizen Preferred)

Oracle DBA – Oracle to Amazon RDS Migration (GovCloud)

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:

• 10+ 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.

Job Type: Full-time

Pay: $62.00 per hour

Expected hours: 40 per week

Work Location: Remote