SQL Database Administrator

Job Description

SQL Developer, BI Developer
DB implementation, design, maintenance, optimisation
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard

Designed and automated sliding window with table partitioning in SQL 2008R2
Created ETL packages using Heterogeneous data sources and then loaded the data into destination tables by performing different kinds of transformations using SSIS
Enhanced the functionality in OLAP cube by implementing Currency Conversion, STD type2, Many-to-Many relationship using SQL 2008R2 SSAS
Performed setup for Log Shipping, MSSQL Mail, SMTP
Implemented SSRS, design and developed Performance management reports and dashboard

APPLY NOW

Power BI dashboard development


Sophisticated in BI development include Data Warehouse and Cube designing, ETL implementing and building dashboard reports by Microsoft products
Fully skilled in T-SQL programming, including complicated queries, user defined functions, stored procedures and triggers
Proficient in SSRS, SSIS, SSAS(Multi Dimensional and Tabular)
Proficient in Power BI and Tableau
Dashboard and KPI, Post Event, Post Campaign Analysis, reporting & recommendation
Decision tree, Propensity model, Forecasting Model and Data Trend Analysis
Business Intelligence Analysis and Reporting
R and Python, SPSS Data modeler, Cognos TM1
Databases: Performance Tuning and Administration for SQL Server 2017

APPLY NOW

CERTIFICATION
Microsoft Certified Database Administrator (MCDBA)
Salary: INR 7,00,000 - 12,00,000 PA.

Industry:IT-Software, Software Services

Functional Area:IT Software - Application Programming , Maintenance

Role Category:Programming & Design

Role:Team Lead/Technical Lead

Employment Type: Full Time, Permanent

APPLY NOW