Sr. Database Migration Architect

Posted 7 Hours Ago
Be an Early Applicant
Bangalore, Bengaluru, Karnataka
Senior level
eCommerce • Logistics
The Role
The Sr. Database Migration Architect will lead data migration projects between Oracle and SQL Server, utilizing Syncsort and scripting tools. Responsibilities include managing database integrity, troubleshooting issues, mentoring DBAs, and collaborating with IT and business teams for effective data migration and integration.
Summary Generated by Built In

Scope:

We are seeking experienced Data Migration Specialists with a strong background in Oracle and SQL Server databases to join our team. The successful candidates will be responsible for running our data migration program, ensuring the seamless transfer of data between Oracle and SQL Server using Syncsort or another third-party tool. This role requires a deep understanding of database management, data migration best practices, and proficiency in Syncsort and Python scripting.

The role also expects candidate to learn BY’s solution to performs effective database migration and troubleshooting. This opportunity will suit an Oracle DBA or MSSQL DBA who specializes in data migration and administration activities. We’re looking for people who work quickly, willing to learn new things, self-starters, smart and do what is needed.

Primary Responsibilities:

  • Data Migration: Plan, execute, and manage data migration projects between Oracle and SQL Server databases.
  • Syncsort Tool Utilization: Use Syncsort to facilitate data transfer, ensuring data integrity and accuracy.
  • Database Management: Maintain and optimize Oracle and SQL Server databases throughout the migration process.
  • Technical Expertise: Provide technical guidance and support during all phases of the data migration project.
  • Issue Resolution: Identify and resolve any issues or discrepancies during data migration.
  • Documentation: Develop and maintain comprehensive documentation of data migration processes, procedures, and protocols.
  • Collaboration: Work closely with IT, data analytics, and business teams to ensure successful data migration and integration.
  • Install, patch, and maintain all Oracle software.
  • Tune all Oracle instance components including SQL and PL/SQL
  • Owning and resolving problems and managing customer expectations
  • Actively seek to learn, optimize, and investigate all issues related to database migration.
  • Support and collaborate with support analyst, product developer and professional services.
  • Proactively Identification of bottle necks and blocking and deadlock issues
  • Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
  • Troubleshoot and resolve, in conjunction with Operational/Customer DBAs, database application issues across production, test and development environments.
  • Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing shell scripting or other scripting tools.
  • Mentor fellow DBAs

What we are looking for:

  • Bachelor’s degree (STEM preferred) and minimum of 5-10 years of relevant work experience Oracle and Sql Server databases.
  • Strong understanding of cloud computing technologies; preferable hands-on experience in working with Azure
  • Experience in handling customer escalations
  • Proficiency in Syncsort tool for data migration.
  • Experience in writing automation scripts, using PowerShell, Python, Perl, Bash
  • Excellent problem-solving and analytical skills
  • Strong communication and collaboration skills
  • Ability to work independently and as part of a team.
  • Strong attention to detail and ability to prioritize tasks effectively.
  • Solid understanding of cloud Infrastructure environments, specifically Linux and Windows based deployments.
  • Excellent SQL skills and ability to write complex queries to pull and analyze data from multiple sources.
  • Good understanding of different file formats such as YML, JSON, Parquet.
  • Excellent organizational skills, able to take a systematic approach in resolving issues.

Our Values


If you want to know the heart of a company, take a look at their values. Ours unite us. They are what drive our success – and the success of our customers. Does your heart beat like ours? Find out here: Core Values

Diversity, Inclusion, Value & Equity (DIVE) is our strategy for fostering an inclusive environment we can be proud of. Check out Blue Yonder's inaugural Diversity Report which outlines our commitment to change, and our video celebrating the differences in all of us in the words of some of our associates from around the world.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

Top Skills

Bash
Oracle
Perl
Powershell
Python
SQL
The Company
HQ: Scottsdale, AZ
5,001 Employees
On-site Workplace
Year Founded: 1985

What We Do

Blue Yonder is the world leader in digital supply chain and omni-channel commerce fulfillment. Our intelligent, end-to-end platform enables retailers, manufacturers and logistics providers to seamlessly predict, pivot and fulfill customer demand. With Blue Yonder, you can make more automated, profitable business decisions that deliver greater growth and re-imagined customer experiences. Blue Yonder - Fulfill your Potential

Blue Yonder’s tagline “Fulfill Your Potential” reflects the company’s mission to empower every organization and person on the planet to fulfill their potential. Each day, our global teams of associates and business partners work together to accelerate global economic growth, increase sustainability and prosperity with a Sonoran Spirit.

Similar Jobs

CSC Logo CSC

Software Engineer

Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Bangalore, Bengaluru, Karnataka, IND
8000 Employees

Exabeam Logo Exabeam

Senior Software Engineer - Java, Kafka/PubSub, NoSQL

Artificial Intelligence • Information Technology • Machine Learning • Security • Software • Cybersecurity • Generative AI
Hybrid
Bangalore, Bengaluru, Karnataka, IND
850 Employees

Exabeam Logo Exabeam

Principal Engineer - Security Applications

Artificial Intelligence • Information Technology • Machine Learning • Security • Software • Cybersecurity • Generative AI
Hybrid
Bangalore, Bengaluru, Karnataka, IND
850 Employees

Exabeam Logo Exabeam

Senior Software Engineer

Artificial Intelligence • Information Technology • Machine Learning • Security • Software • Cybersecurity • Generative AI
Bangalore, Bengaluru, Karnataka, IND
850 Employees

Similar Companies Hiring

Block Thumbnail
Software • Payments • Fintech • Financial Services • eCommerce • Cryptocurrency • Blockchain
Oakland, CA
12000 Employees
Munchkin, Inc. Thumbnail
Kids + Family • Enterprise Web • eCommerce • Consumer Web • 3D Printing
Milton, Ontario
325 Employees
Cencora Thumbnail
Pharmaceutical • Logistics • Healthtech
Conshohocken, PA
46000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account