Job Title:  T&T-EAD-Consultant | Cloud Infrastructure | Bengaluru | Engineering

What impact will you make?

Every day, your work will make an impact that matters, while you thrive in a dynamic culture of inclusion, collaboration, and high performance. As one of the leading professional services organisations, Deloitte is where you will find numerous opportunities to succeed and realise your full potential.

The team
Deloitte is working with global customers on cloud technologies to help them spot unseen business trends, transform, and curate data to find meaningful insights, and so on. Due to continued expansion, we’re searching for like-minded individuals to help us ‘take it to the next level’.

The ideal candidate will have a proven track record in implementing data ingestion and transformation pipelines for large-scale organizations. We are seeking someone with deep technical skills in a variety of technologies to play an important role in developing and delivering early proofs of concept and production implementation.

You will get good experience in building solutions using a variety of open-source tools on a cloud platform and a proven track record in delivering high-quality work to tight deadlines.

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