Data Analyst

Job Description

Exp -3-4 year

Write and optimize in-application SQL statements, Procedures, Views Etc.

Ensure performance, security, and availability of databases

Prepare documentations and specifications

Handle common database procedures such as upgrade, backup, recovery, migration, etc.

Profile server resource usage, and optimize and tweak as necessary

Collaborate with other team members and stakeholders

Prepare & optimize SSIS package & Schedule them

Prepare SSRS reports

Work on SSAS

Critical Success factors:

Strong proficiency with SQL and its variation among popular databases

Experience with some of the modern relational databases

Skilled at optimizing large complicated SQL statements

Knowledge of best practices when dealing with relational databases

Capable of configuring popular database engines and orchestrating clusters as necessary

Ability to plan resource requirements from high level specifications

Capable of troubleshooting common database issues

Familiar with tools that can aid with profiling server resource usage and optimizing it