Azure SQL Developer & DBA

Job Description

Work with the development team and business stakeholders to transition current systems used by DAI/ US and DAI/ Europe offices into a new platform based on requirements documented by system analysts. Develop new functionality; and troubleshoot and implement fixes into existing code. Identify ways that the system can be configured to accommodate needs of different DAI subsidiaries, clients and projects. Sunera Technologies :: Enabling Innovation Home Careers Job Details Azure SQL Developer & DBA Billable Role / Strategic Role Billable Role FTE (Full Time Employee) 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 DAI_ Senior Manager, IT Operations (OIMT) 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 & 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. 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,

Keyskills :
ssrs ssis sql isualstudioteamsystem office365 visualsourcesafe databaseadministration visualstudio powerbi sqldba sqlserver dataanalysis auditrepo itoperations sqlprofiler teamfoundationserver