Senior Database Engineer (Database Migration)

Job Title - Database Migration Engineer

Location: Charlotte NC

About this Role

The Senior Database Migration Engineer will be responsible for end‑to‑end planning, preparation, execution, cutover, and post‑migration handover of Oracle, Exadata, and Microsoft SQL Server databases as part of a structured, wave‑based datacentre or platform migration program.

The role demands strong expertise in enterprise database platforms, automation‑driven migrations, governance‑led execution, and close coordination with application, middleware, and infrastructure teams in a regulated BFS environment.

Exp: 8

In this Role, You Will:

Planning & Assessment

• Develop the overall database migration strategy, sequencing, and wave plan
• Validate source and target platform readiness for Exadata and SQL Server VM environments
• Perform database discovery, dependency mapping, and classification for migration sequencing
• Conduct compatibility checks covering database versions, patch levels, character sets, storage layouts, and connectivity
• Identify migration tooling and automation requirements, including AMA readiness
• Prepare migration workflows and cutover approaches aligned to *****SOPs, runbooks, and governance

Migration Preparation

• Perform pre‑migration technical checks for Oracle and SQL-Server environments
• Validate and coordinate target environment readiness (DB servers, ASM/storage, clusters, network reachability, RBAC)
• Plan and schedule migration waves with application and infrastructure teams
• Configure replication, data movement, or export/import workflows per approved approach
• Ensure automation jobs and scripts are tested and governance‑compliant
• Stage scripts, job templates, and automation artifacts for migration execution

Migration Execution

• Build and configure databases on target platforms
• Execute database replication, data copy, or migration jobs using AMA or equivalent tools
• Perform backup of source databases prior to migration
• Monitor data transfer, replication health, and execution status
• Resolve migration‑related errors impacting synchronization or readiness
• Maintain real‑time migration tracking and reporting
• Coordinate with storage, compute, and network teams during execution

Cutover Activities

• Execute controlled cutover during approved freeze windows
• Perform final sync, switchover, role transition, and database activation
• Conduct post‑activation checks (listener, connectivity, instance health)
• Validate application‑to‑database connectivity
• Update migration trackers, wave dashboards, and cutover logs
• Coordinate with application teams for functional validation and acceptance

Post‑Migration Handover & Decommissioning

• Perform post‑migration verification, including performance baseline and data consistency checks
• Support hypercare and stabilization, addressing migration exceptions
• Assist with application reconnection and downstream validation
• Document migration outcomes and final signoff
• Execute source shutdown, cleanup, and decommissioning per ***‑approved process
• Handover updated configurations, documentation, and final migration reports to operations