Senior Database Migration Lead – Oracle & SQL Server

Zensar Technologies; Hillsboro (OR); On-site; USD 140,000 - 190,000; Full time

Job summary

Zensar Technologies is seeking a seasoned Database Migration Expert to lead the migration of Oracle and Microsoft SQL Server databases as part of a data center modernization program. Onsite role in Hillsboro, OR or Santa Clara, CA, five days per week in the office.

The candidate will own end-to-end migration lifecycle, from assessment to cutover, delivering complex migrations with minimal downtime and zero data loss while coordinating with business and IT teams.

Qualifications

• 10-12+ years as Oracle and/or SQL Server DBA, including 4-6 years leading database migrations.
• Oracle 12c/19c+ with RMAN/Data Guard/Data Pump/RAC/ASM/GoldenGate experience.
• SQL Server 2016+ with Always On, log shipping, SSIS, backup/restore expertise.
• Migration tooling experience: GoldenGate, AWS DMS/SCT, Azure DMS.
• Multi-TB migrations with minimal downtime and zero data loss.
• Proficient in SQL/PLSQL/T-SQL; scripting in PowerShell, Bash, Python.
• Understanding of storage, networking, virtualization (VMware), Linux/Windows OS.
• Strong communication to explain plans, risks, and status.

Responsibilities

• Lead assessment of Oracle and SQL Server estates including versions, sizes, dependencies, licensing, and baselines.
• Define migration strategy for rehost, replatform, or refactor (homogeneous and heterogeneous moves).
• Develop detailed wave plans, runbooks, rollback plans, and cutover schedules.
• Perform migrations using tools like Oracle GoldenGate, DMS, and migration services.
• Design validation checks for data counts, checksums, and integrity post-migration.
• Tune performance pre- and post-migration; optimize target environment.
• Design HA/DR (RAC, Data Guard, Always On) and manage cutover/ hypercare.
• Coordinate with application owners, infra, network, and security; create runbooks and handover materials.
• Identify risks and mitigation plans; ensure governance and compliance.

Skills

Oracle DBA

SQL Server DBA

Migration lead

Oracle GoldenGate

AWS DMS

Azure DMS

PowerShell

Python

SQL/PLSQL

Data Guard

RAC

Always On

Bash

Linux

Windows Server

VMware

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle GoldenGate

AWS DMS

Azure Database Migration Service

Job description

Zensar Technologies is seeking a seasoned Database Migration Expert to lead the migration of Oracle and Microsoft SQL Server databases as part of a data center modernization program. Onsite role in Hillsboro, OR or Santa Clara, CA, five days per week in the office.

The candidate will own end-to-end migration lifecycle, from assessment to cutover, delivering complex migrations with minimal downtime and zero data loss while coordinating with business and IT teams.