Senior Database Engineers Job in Savvy It

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