• Senior Data Virtualization Architect Jobs in Bangalore,India - 25312439

  • Diageo India Pvt Ltd
  • Save Job
  • 10 - 13 Years
  • Posted : above 1 month

Job Description:

The purpose of the role is to architect and administrate our cloud data warehouse technology platforms with a primary focus on Azure Synapse Administration across all Data Products and Analytics projects

The candidate should be able to

Provide Cloud Data Warehosue and Azure Synapse platform architecture and expertise
Manage platform/product optimizations
Manage code review and change control processes
Analyse query performance improvements (analyse query profiles/explain plans)
Monitor system performance and mark/fix outliers
Work with development teams to establish and govern SQL best practices on the Virtualization Platform
Manage aggregates strategy and performance/cost optimization
Platform installations, upgrades, regression testing and backups
Be an integrated member of the Big Data architecture team delivering and end-to-end Big Data architecture on Microsoft Azure Cloud, working with the Data Lake product owner to optimize our data caching and virtualization strategy across platforms
Be experienced in the implementation of global information & analytics projects
Have functional domain knowledge relevant to their Product area
Have strong systems design and reporting/analytics experience
Be fluent in English and multi-culturally aware
Demonstrate outstanding collaboration ability in a global setting

Be quick to grasp complex business and technology problems, driving them to resolution

Accountabilities

Azure Synapse / SQL Data Warehouse

Database Administration (DBA) accountabilities for Data Warehouse platform Platform installations, upgrades, backups, query performance optimization, ddl reviews, query plan reviews
Access management
Performance management automate monitoring and logging, mark/fix outliers
Resiliency and uptime management
Platform cost management
Performance testing various options of solutions on the platform

Data Warehouse Governance

Establish best practices for managing data sources, spaces, materialized views and coding standards within the Azure Synapse / SQL Data Warehouse Platform
Establish change control and dev ops processes for deploying code within Data Warehouse Virtualization platforms
Automate monitoring processes to flag poorly written code, bad performing queries and work with developers to address the issues

Data Warehouse Architecture and Roadmap

Work with Data Lake Product Owner to establish long term roadmap for data warehousing / data virtualization platforms to optimize data cache/memory across multiple tools (ie when to use Azure Data Warehouse, vs competitors products, vs Cubes, etc)

Establish working relationship with vendors (ie Microsoft) to track feature requests and critical bug fixes and ensure smooth rollout of new capabilities

Candidate Requisites

Bachelors Degree in Information Technology, Computer Science, Statistics, or similar
10 years experience acting as an application or solution architect in the analytics / business intelligence domain
6 years of experience with multinational companies (preferably CPG) or IT consultancy companies in relevant analytics solution delivery demonstrating a progression of leadership roles
Deep expertise and demonstrated execution experience with the relevant technologies including Cloud Data Warehouse platforms such as Azure Synapse / SQL Data Warehouse, AWS Redshift, Google Big Query, Snowflake, or Dremio Nice to have Denodo, Composite, AtScale or similar
DBA experience managing large database solutions such as Oracle or SQL Server environments at enterprise scale within Cloud Computing platforms (ie Azure)

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Consumer Durables/FMCG, Manufacturing/Industrial
Functional Area : IT Software : Software Products & Services
Role : Software Engineer
Salary : As per Industry Standards
Deadline : 03rd Jun 2020

Key Skills:

These are some of our most popular tutorials

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status