Senior Associate, Azure Cloud DB Migration, Data & Analytics, Advisory, Hyderabad

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Data, Analytics & AI

Management Level

Senior Associate

Job Description & Summary

At PwC, our people in data and analytics focus on leveraging data to drive insights and make informed business decisions. They utilise advanced analytics techniques to help clients optimise their operations and achieve their strategic goals. In data analysis at PwC, you will focus on utilising advanced analytical techniques to extract insights from large datasets and drive data-driven decision-making. You will leverage skills in data manipulation, visualisation, and statistical modelling to support clients in solving complex business problems.

Why PWC

At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us.

At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations.

Job Description & Summary

A career within Data and Analytics services will provide you with the opportunity to help organizations uncover enterprise insights and drive business results using smarter data analytics. We focus on a collection of organizational technology capabilities, including business intelligence, data management, and data assurance that help our clients drive innovation, growth, and change within their organizations to keep up with the changing nature of customers and technology. We make impactful decisions by mixing mind and machine to leverage data, understand and navigate risk, and help our clients gain a competitive edge.

Responsibilities:

About the Role:

We are seeking a hands-on Data Engineer with 4-8 years of experience specializing in on-premises database migration to cloud. The ideal candidate will have a strong background in cloud migration whether on-premises to Azure cloud, or cloud to Azure cloud.

Key Responsibilities:

• Should have experience of database migration strategy and related technologies.
• Experience of Microsoft SQL DB migration from on-prem to cloud platform.
• Experience of any other cloud (e.g. AWS or GCP) to Azure cloud platform.
• Review Database migration plans, provide recommendation and liaise with Customer and Migration Factory for successful migrations.
• Ability to identify and resolve performance issues post-migration

Required Skills:

• Knowledge in using tools like Azure Data Studio, Azure DMA, Azure DMS, Azure SQL/MI
• Familiarity with migrating SSIS packages using ADF. SSMA Migration Tool, Database migration using SSIS Packages
• In-depth knowledge of SQL, TSQL and programming experience with stored procedures, triggers, functions, etc.
• Stronger performance tuning (partitioning, exec plans, indexing etc.), data modeling experience and dacpac deployment experience, Stored Procedures Optimization
• Extensive experience with Azure Data Services, including Azure Data Factory, Azure SQL Data Warehouse, and Synapse Analytics.
• Strong understanding of database architecture principles and best practices.

Preferred Qualifications:

• Azure Solutions Architect Expert certification.
• Knowledge of SQL Clustering/Always on Availability Groups, Azure SQL, SQL MI
• Experience of CTS/Migration technologies. (Rehost/Clean Deployments)
• Should have exp on Azure project and GitHib as Code Repo
• Knowledge of setting up High Availability & Disaster Recovery configuration.
• Experience in setting up Always ON Availability Groups & Zone Redundant Storage
• Familiarity with Azure DevOps (ADO) for (CI/CD) pipelines, Infrastructure as Code (IaC) tools like Terraform for deploying container apps and associated services
• Knowledge of security best practices and compliance requirements for cloud-based applications
• Backup/recovery, Security related activities, Audit tracking and reporting
• Maintaining and supporting, monitoring production and test environments
• Implementing of High Availability such as Clustering, Database Mirroring, Log Shipping, and Replication

Mandatory skill sets:

• Knowledge in using tools like Azure Data Studio, Azure DMA, Azure DMS, Azure SQL/MI
• Familiarity with migrating SSIS packages using ADF. SSMA Migration Tool, Database migration using SSIS Packages
• In-depth knowledge of SQL, TSQL and programming experience with stored procedures, triggers, functions, etc.

Preferred skill sets:

• Azure Solutions Architect Expert certification.
• Knowledge of SQL Clustering/Always on Availability Groups, Azure SQL, SQL MI
• Experience of CTS/Migration technologies. (Rehost/Clean Deployments)
• Should have exp on Azure project and GitHib as Code Repo

Years of experience required:

Experience: 4-8 Years

Education qualification:

B.Tech / M.Tech / MCA/MBA

Education

Degrees/Field of Study required: Bachelor of Technology, MBA (Master of Business Administration)

Required Skills

Database Migrations

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Algorithm Development, Alteryx (Automation Platform), Analytical Thinking, Analytic Research, Big Data, Business Data Analytics, Communication, Complex Data Analysis, Conducting Research, Creativity, Customer Analysis, Customer Needs Analysis, Dashboard Creation, Data Analysis, Data Analysis Software, Data Collection, Data-Driven Insights, Data Integration, Data Integrity, Data Mining, Data Modeling, Data Pipeline {+ 38 more}

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date