Database Migration Expert

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

We’re a bunch of hardworking, fun-loving, people-oriented technology enthusiasts. We love what we do, and we’re passionate about helping our clients thrive in an increasingly complex digital world. Zensar is an organization focused on building relationships with our clients and with each other—and happiness is at the core of everything we do. In fact, we’re so into happiness that we’ve created a Global Happiness Council, and we send out a Happiness Survey to our employees each year. We’ve learned that employee happiness requires more than a competitive paycheck, and our employee value proposition—grow, own, achieve, learn (GOAL)—lays out the core opportunities we seek to foster for every employee. Teamwork and collaboration are critical to Zensar’s mission and success, and our teams work on a diverse and challenging mix of technologies across a broad industry spectrum. These industries include banking and financial services, high-tech and manufacturing, healthcare, insurance, retail, and consumer services. Our employees enjoy flexible work arrangements and a competitive benefits package, including medical, dental, vision, 401(k), among other benefits. If you are looking for a place to have an immediate impact, to grow and contribute, where we work hard, play hard, and support each other, consider joining team Zensar!

About the Role

Zensar is seeking a seasoned Database Migration Expert - Oracle, SQL Server & Cloud Modernization to lead the migration of Oracle and Microsoft SQL Server databases as part of a data center modernization program. The role owns the end-to-end migration lifecycle: assessment, planning, execution, validation and cutover. Target environments may include a new data center, private cloud or public cloud (AWS, Azure, OCI). The ideal candidate combines deep hands‑on DBA expertise with strong migration planning skills, and can deliver complex migrations with minimal downtime and zero data loss.

This is an onsite role requiring five days per week in the office, located in either Hillsboro, OR or Santa Clara, CA.

Key Responsibilities

• Assessment & discovery: inventory and assess existing Oracle and SQL Server estates. This covers versions, sizes, dependencies, licensing, performance baselines and application integrations.
• Migration strategy: define the approach for each database, whether rehost, replatform or refactor, and covering homogeneous moves (Oracle → Oracle, SQL Server → SQL Server) and heterogeneous moves (e.g., Oracle → SQL Server or PostgreSQL).
• Migration planning: build detailed wave plans, runbooks, rollback plans and cutover schedules in line with business downtime windows.
• Execution: perform migrations using the right tools and techniques, such as Oracle Data Guard, RMAN, Data Pump, GoldenGate, SQL Server Always On, log shipping, backup/restore, AWS DMS or Azure DMS.
• Data validation: design and run reconciliation checks covering row counts, checksums and data integrity, to confirm complete and accurate migration.
• Performance tuning: benchmark pre- and post-migration performance, and tune queries, indexes and configurations in the target environment.
• High availability & DR: design and configure HA/DR in the target environment (RAC, Data Guard, Always On Availability Groups, clustering).
• Cutover & hypercare: lead cutover activities and provide post-migration stabilization support.
• Stakeholder coordination: work closely with application owners, infrastructure, network, security and business teams to align migration windows and resolve dependencies.
• Documentation: produce migration runbooks, as-built documentation, lessons learned and handover materials for operations teams.
• Risk management: identify migration risks (data loss, downtime, compatibility, licensing) and drive mitigation plans.

Required Qualifications

• Experience: 10-12+ years as an Oracle and/or SQL Server DBA, including at least 4-6 years leading database migrations as part of data center or cloud migration programs.
• Oracle expertise: strong hands‑on knowledge of Oracle 12c/19c and later, RMAN, Data Pump, Data Guard, RAC, ASM and GoldenGate.
• SQL Server expertise: strong hands‑on knowledge of SQL Server 2016 and later, Always On Availability Groups, log shipping, SSIS and backup/restore strategies.
• Migration tooling: experience with migration and replication tools such as Oracle GoldenGate, AWS DMS/SCT, Azure Database Migration Service or equivalent.
• Scale: proven record of migrating large, business-critical databases (multi‑TB) with minimal downtime.
• Scripting: proficiency in SQL, PL/SQL, T‑SQL and scripting (PowerShell, Bash or Python) for automation and validation.
• Infrastructure knowledge: working understanding of storage, networking, virtualization (VMware) and OS platforms (Linux, Windows Server).
• Communication: ability to explain technical migration plans, risks and status clearly to technical and business stakeholders.

Preferred Qualifications

• Experience with cloud database services: Amazon RDS, Azure SQL / Managed Instance, Oracle Cloud Infrastructure (OCI) or Exadata Cloud
• Heterogeneous migration experience (e.g., Oracle → PostgreSQL or SQL Server)
• Knowledge of Oracle and Microsoft licensing implications during migrations
• Familiarity with ITIL change management and formal cutover governance
• Certifications such as Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator Associate, or AWS Certified Database – Specialty

Success Measures

• Databases migrated on schedule within agreed downtime windows
• Zero data loss, validated through documented reconciliation
• Post-migration performance at or above baseline
• Complete runbooks and smooth handover to operations

Zensar believes that diversity of backgrounds, thought, experience, and expertise fosters the robust exchange of ideas that enables the highest quality collaboration and work product. Zensar is an equal opportunity employer. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. Zensar is committed to providing veteran employment opportunities to our service men and women. Zensar is committed to providing equal employment opportunities for people with disabilities or religious observances, including reasonable accommodation when needed. Accommodation made to facilitate the recruiting process are not a guarantee of future or continued accommodation once hired.

All applicants must be legally authorized to work with Zensar. Visa sponsorship may be available for qualified applicants for certain positions.

Zensar values your privacy. We’ll use your data in accordance with our privacy statement located at: https://zensar.com/privacy-notice