Remote Cloud Oracle DBA Lead: AWS Rehost & Migration

Cognizant; Boise (ID); Remote; USD 137,000 - 155,000; Full time

Job summary

Cognizant is hiring an Oracle DBA Lead to manage the complete migration lifecycle from on-premises to AWS, emphasizing rehosting Oracle databases on EC2. The role covers discovery, assessment, and cutover planning, with strong focus on security, performance, and operational readiness.

The candidate will design and implement Oracle environments on AWS, perform data and schema migrations using RMAN, Data Pump, and GoldenGate, and lead post-cutover stabilization and hypercare across teams.

Qualifications

• 8+ years of hands-on Oracle DBA experience, including production support and database migration responsibilities.
• Strong administration experience with Oracle 11g, 12c, 18c, 19c, and preferably 21c, across Windows, Linux / Unix environments.
• Demonstrated experience migrating Oracle databases from on-premises infrastructure to AWS or another cloud environment; hands-on AWS rehost experience is strongly preferred.
• Hands-on knowledge of Amazon EC2, EBS storage, VPC networking concepts, security groups, IAM integration points, AWS monitoring, and backup or recovery considerations relevant to Oracle workloads.
• Hands-on Oracle RAC or clustered database experience. The current estate may include clustered configurations, so the ability to discover, assess, migrate, and troubleshoot RAC-related dependencies is valuable.
• Experience with Oracle GoldenGate, cross-platform migrations, platform endian conversion, transportable tablespaces, and near-zero-downtime migration patterns.
• Experience with Oracle Enterprise Manager and AWS monitoring or observability tools such as Amazon CloudWatch.
• Expertise in Oracle installation, creation, upgrade, patching, cloning, backup and recovery, performance tuning, capacity management, security, and operational troubleshooting.
• Hands-on experience with RMAN, Data Pump, restore and recovery validation, database consistency checks, and migration reconciliation support.
• Experience designing and supporting high availability and disaster recovery using Oracle Data Guard; ability to assess existing configurations and recreate or adapt them on AWS.

Responsibilities

• Own end-to-end migration of Oracle databases from on-premises environments to AWS, with the primary target pattern being rehost to Oracle Database on Amazon EC2.
• Perform discovery and assessment of database versions, editions, operating systems, storage, interfaces, dependencies, database links, jobs, batch schedules, backup methods, security controls, and high-availability or disaster-recovery configurations.
• Define the migration approach for each database, including prerequisites, target sizing, compatibility, outage requirements, data-transfer method, cutover sequence, rollback plan, validation criteria, and operational handover.
• Build and configure Oracle database environments on AWS EC2, including software installation, database creation or restore, listener and network configuration, storage layout, parameter tuning, patch alignment, backup integration, monitoring, and access controls.
• Execute schema and data migration using appropriate Oracle-native and enterprise tools such as RMAN, Data Pump, transportable tablespaces, Data Guard, or GoldenGate based on database size, platform compatibility, and downtime tolerance.
• Plan and execute mock migrations, production cutovers, application connectivity changes, technical validation, reconciliation support, rollback readiness, and post-cutover stabilization.
• Provide limited-duration post-go-live hypercare, including rapid triage, root-cause analysis, remediation, and resolution of issues identified after migration across availability, performance, connectivity, listener and TNS services, backups, storage growth, invalid objects, jobs, replication, patching, and application-reported database incidents.
• Create and maintain assessment outputs, architecture inputs, migration runbooks, validation checklists, rollback procedures, SOPs, known-error records, and transition documentation.
• Coordinate with application, AWS cloud, network, security, storage, backup, operating-system, and business teams throughout migration and stabilization.
• Provide technical leadership for complex incidents, root-cause analysis, remediation planning, and knowledge transfer to steady-state support teams.

Skills

Oracle DBA

RMAN

Data Pump

GoldenGate

AWS EC2

Oracle RAC

CloudWatch

Tools

Oracle Enterprise Manager

AWS Migration Hub

Data Guard

Job description

Cognizant is hiring an Oracle DBA Lead to manage the complete migration lifecycle from on-premises to AWS, emphasizing rehosting Oracle databases on EC2. The role covers discovery, assessment, and cutover planning, with strong focus on security, performance, and operational readiness.

The candidate will design and implement Oracle environments on AWS, perform data and schema migrations using RMAN, Data Pump, and GoldenGate, and lead post-cutover stabilization and hypercare across teams.