Home > Careers > Job Details


Job ID: SU1015
Position: Azure SQL Developer & DBA
Billable Role / Strategic Role Billable Role
Type of Employment FTE (Full Time Employee)

Customer Name

(If Billable Role)
Location: NSL Arena, Uppal, Hyderabad, Telangana
Required Qualifications 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.
Required Certifications (if any) 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
Reporting Manager DAI_ Senior Manager, IT Operations (OIMT)
Work Shift Overlap at least 3 hours, but for the first few weeks it may be 4 hours a day.
Desired Profile
Prior Experience in terms of number of years and roles & Responsibilities 5 to 8 years’ experience
Develop and support DAI’s Azure and on-premises SQL Server database infrastructure for new data initiatives with database design, development, automation and administration. This person will report to DAI’s Principal Database Administrator.
Role & 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 & administrationSetup/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.


Required technical skills (If applicable) 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 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
Catchment Area 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.
Good to have skills apart from required technical skills Good communication and if locate nearby Uppal office.
Preferred behavioural competency in order of priority
  • Communication
  • Creativity
  • Positive thinking
  • Problem solving
  • Decision making
  • Value and purpose
  • Team Player
  • Listening
  • Others: Presentation Skills
To Apply: Please click on "Apply Now" below to submit your resume.
Suneratech Tweets