Lead Database Engineer

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.

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 Wells Fargo 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 Wells Fargo-approved process
• Handover updated configurations, documentation, and final migration reports to operations, * 8-12+ years of experience as an Enterprise Database Administrator supporting Oracle and Microsoft SQL Server platforms in large-scale environments

Database Administrator (Oracle / Exadata / MS SQL), * Strong understanding of database architecture, design, and administration for:

• Oracle (11g/12c/19c) including Exadata
• Microsoft SQL Server (2016/2019/2022) on VM platforms
• Proven experience supporting datacenter or platform migration programs, including planning, execution, cutover, and post-migration stabilization
• Hands-on expertise in:
• Oracle RAC, ASM, Data Guard, RMAN
• SQL Server Always On, clustering, backup/restore, and replication
• Database build, configuration, and hardening on target environments
• Strong experience performing pre-migration readiness checks, including:
• Version and patch compatibility
• Character set and collation validation
• Storage layout and capacity planning
• Connectivity and access validation
• Solid understanding of backup, recovery, and rollback strategies to support migration and cutover activities
• Experience executing and validating database replication, data copy, or export/import-based migration approaches
• Strong knowledge of HA/DR concepts, failover testing, and production cutover best practices
• Ability to perform post-migration validation, including data consistency checks and performance baseline comparisons
• Experience working in regulated BFS environments with strict governance, audit, and change control requirements
• Hands-on exposure to automation-driven database migration or administration (scripts, job scheduling, tooling such as AMA or equivalent) is a plus
• Working experience with ServiceNow, Jira, and CMDB updates as part of migration execution and operational handover
• Strong documentation skills with the ability to produce runbooks, migration reports, and handover artifacts
• Excellent communication and coordination skills, with the ability to work closely with application, infrastructure, and operations teams

Pulled from the full job description

• 401(k)
• Opportunities for advancement, * Hybrid Work Model: Combination of on-site and remote work, depending on business needs.
• Collaborative Culture: Work closely with cross-functional teams, vendors, and senior leadership.
• Professional Development: Access to training programs, certifications, and career advancement opportunities.
• Global Impact: Support a mission-critical network infrastructure serving millions of customers worldwide.

Please share out your resume at shikha@transtechinc.co

Pay: $50.00 - $55.00 per hour

Benefits:

• 401(k)