• Suneratech - Azure Developer/Database Administrator - SQL/OLAP Jobs in Hyderabad,India

  • Sunera
  • Save Job
  • 5 - 12 Years
  • Posted : above 1 month

Job Description:

Summary

- Develop and support DAIs Azure and on-premises SQL Server database infrastructure for new data initiatives with database design, development, automation and administration This person will report to DAIs Principal Database Administrator

Duties and Responsibilities

(I) Azure SQL Development and Administration 70%

a) Design and Develop OLAP & BI solutions

- Using Azure Analysis Services, Azure Data Warehouse, Cubes and Models to improve existing and create new ways to use and manipulate data

- Work with other developers and recommend best practices, performance tuning of T-SQL queries, write MDX multi-dimensional models, DAX for PowerPivot and Tabular models especially for use in Power BI reports

- Develop complex queries, stored procedures, triggers, user-defined functions, etc

- Design and develop processes that transform JSON data into tables and views that facilitate reporting in Power BI and other data analysis tools, including developing Star and/or Snowflake schemas as necessary

- Develop tools for loading data from external third-party APIs and/or other internal/external databases

b) Azure Database security & administration

- Setup/Manage databases, SQL external logins, generate SQL audit reports, set alerts, security, firewalls rules, backup/restore, monitor and troubleshooting, manage cost, elastic pools, create ETL jobs using SSIS, Azure Data Factory V2, etc

- Assist in defining the necessary schemas and AD groups to simplify the management of DB security

(II) On-premises Application and O365 support 30%

- Support and troubleshoot on-premises legacy and Azure web applications based on IIS, SharePoint, SQL, Power BI, PowerApps, etc

- Assist in the management of Office 365 licenses and feature management, support and troubleshoot O365 applications and deployment for Power BI, PowerApps, etc Microsoft Azure, SharePoint, SQL Server, etc

Job Requirements

- Bachelors degree or higher

- 5+ years of experience designing, building and implementing BI solutions with Microsoft technologies including SQL Server, SSIS, SSRS, SSAS with MDX and DAX skill with the multidimensional and tabular cube is a must

- Experience with dimensional modeling and creating Star/Snowflake schemas

- Strong SQL DBA and troubleshooting skills

- Strong SQL Server knowledge across multiple versions including Azure SQL

- Understanding of database tuning and troubleshooting

Programming Languages and DB skills required T-SQL, DAX, MDX, PL/SQL, JSON, ODBC, OLEDB, Development and design with SQL Server Azure, SQL 2017/2016/2014/2012/R2/2008/R2/2005/2000, Linked servers, Oracle 11g/10g/9i

Experience with Tools SQL Management Studio, SQL Profiler, BIDS, SSDT, SSIS, SSRS, SQL Configuration Manager, DTExec, SQLCmd, PowerBI enterprise Gateway, Power BI Desktop, Azure Data Warehouse, Azure Analysis Services, Azure Data Factories

Experience with Applications Windows Server (64/32bit 2016/2012/R2/2008), Win (10/7), Office 365, Microsoft Azure, SharePoint Server 2013/2010/2007, SharePoint Online, Microsoft Office PerformancePoint Server 2007, Active Directory, IIS 75/60/50, Visual Studio Net 2017/2015/2008/2005/2003, Visual Studio Team System, MS Team Foundation Server, MS Visual S

Profile Summary:

Employment Type : Full Time
Salary : Not Mentioned
Deadline : 18th Mar 2020

Key Skills:

Company Profile:

Not Mentioned

These free online tutorials may interest you

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