Lead Database Engineer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, MphasiS Corporation USA, is seeking the following. Apply via Dice today!

ob Title: Lead Database Engineer

Location: Irving, TX , Charlotte, NC, Iselin, NJ

Employment Type: Full-Time

About This Role

The Senior Database Migration Engineer will be responsible for endtoend planning, preparation, execution, cutover, and postmigration handover of Oracle, Exadata, and Microsoft SQL Server databases as part of a structured, wavebased datacentre or platform migration program.

The role demands strong expertise in enterprise database platforms, automationdriven migrations, governanceled execution, and close coordination with application, middleware, and infrastructure teams in a regulated BFS environment.

In this Role, You Will:

Exp: 8 to 12 Yrs

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 Clients SOPs, runbooks, and governance
  
  

Migration Preparation

• Perform premigration 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 governancecompliant
• 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 migrationrelated errors impacting synchronization or readiness
• Maintain realtime 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 postactivation checks (listener, connectivity, instance health)
• Validate applicationtodatabase connectivity
• Update migration trackers, wave dashboards, and cutover logs
• Coordinate with application teams for functional validation and acceptance
  
  

PostMigration Handover & Decommissioning

• Perform postmigration 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 client approved process
• Handover updated configurations, documentation, and final migration reports to operations
  
  

Desired Qualifications:

Database Administrator (Oracle / Exadata / MS SQL)

• 6 of experience as an Enterprise Database Administrator supporting Oracle and Microsoft SQL Server platforms in largescale environments
• 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 postmigration stabilization
• Handson 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 premigration 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 postmigration validation, including data consistency checks and performance baseline comparisons
• Experience working in regulated BFS environments with strict governance, audit, and change control requirements
• Handson exposure to automationdriven 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
  
  

Work Environment & Benefits:

• 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.