Senior Database Engineers
Industry:
Information Technology (IT)
Department:
Engineering
Number of Position(s):
-
Experience Level:
8+ Years
Location:
Chennai
Job Description
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
Qualifications
Experience:
(8-10 years exp) Responsible to develop, test, improve and maintain new and existing databases to help users retrieve data effectively
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)
Graduate in Computer Science engineering or related program with excellent Analytical Skills involving converting business requirements, processes or systems, into DB Specifications