Data Analyst

• 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