Oracle prem to AWS Migration Architect

Cognizant is seeking an Oracle – On Prem to AWS Migration Architect for a full time remote opportunity. Applicants must be authorized to work in the US . Cognizant will not offer visa sponsorship now or anytime in the future.

The Oracle DBA Lead will be responsible for the complete database migration lifecycle, from source discovery through post-migration stabilization. The role is primarily focused on rehosting Oracle databases from on-premises infrastructure to AWS, while ensuring operational readiness, recoverability, performance, security, and supportability after cutover.

• 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 table spaces, Data Guard, or Golden Gate 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.

• 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 Golden Gate, cross-platform migrations, platform endian conversion, transportable table spaces, and near-zero-downtime migration patterns.
• Experience with Oracle Enterprise Manager and AWS monitoring or observability tools such as Amazon Cloud Watch.
• 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.
• Ability to diagnose complex Oracle issues using alert logs, trace files, AWR, ASH, ADDM, execution plans, wait events, and…