Overview
Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Skills
Oracle
DBA
RDS
19c
AWS
DMS
RMAN
GovCloud
terraform
administrator
Job Details
Need US Permanent residents only
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.