Develop and support Azure and on-premises SQL Server database infrastructure for new data initiatives with database design, development, automation and administration. This person will report to Principal Database Administrator.
Duties and Responsibilities
Azure SQL Development and Administration -70%
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 API’s and/or other internal/external databases.
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.
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.
Bachelor’s 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 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 7.5/6.0/5.0, Visual Studio .Net 2017/2015/2008/2005/2003, Visual Studio Team System, MS Team Foundation server, MS Visual Source Safe, Git, SVN, PVCS & CVS etc.
Total Exp: 5-10 Years
Location : Gachibowli
Work timings ( general shift but first 3 months you need to over lap with US Timings)