Data Analyst

Mumbai Salesforce Marketing Cloud

14 Feb 2020

Mumbai

Salesforce Marketing Cloud

Analytics

1

4 - 5 years


·         This role is in US shift (India Night shift- Continuous)

·         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