Required Skills

XML Database Workflow Issue resolution Stored procedures SQL Server analysis services

Work Authorization

  • Citizen

Preferred Employment

  • Full Time

Employment Type

  • Direct Hire

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 30th Sep 2022

JOB DETAIL

(8-10 years exp) Responsible to develop, test, improve and maintain new and existing databases to help users retrieve data effectively

Responsibilities

Prepare design specifications and functional documentations for assigned database projects

Extracts data from a variety of sources for use in analysis and models

Optimize database queries and systems for performance efficiency

Optimize database code by analyzing query execution plans

Develop tables, indexes, constraints and create database triggers for automation, e.g. automatic notifications

Optimize, tune, and troubleshoot SQL code

Extract, transform and load data, complete ad-hoc reporting and data analysis

Provide support and leadership in critical production support issue resolution Required Qualifications

Required Qualifications

Strong conceptual understanding of relational database modeling maintenance

Expert Knowledge in writing complex queries, stored procedures, packages, views

SQL Server Analysis Services, cubes and MDX query

SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs)

T-SQL / PL/SQL Coding

XML Query development

Graduate in Computer Science engineering or related program with excellent Analytical Skills involving converting business requirements, processes or systems, into DB Specifications

Company Information