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.
Job Requirements
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)