SQL Analyst Mumbai

 



Detailed JD :-
Help write and optimize in-application SQL statements

•             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

•             Understand and analyse business requirements.

•             Develop, implement and optimize stored procedures and functions    using T-SQL

•             Create Stored Procedures, Views and Data integration scripts to extract data from SOR and load in Azure SQL Database

•             Create Views and SQL Functions on Azure to expose data to Applications

Skills and Qualifications

•             Strong proficiency with SQL and its variation among popular databases

•             Experience with Azure Databases

•             Understanding of PL-SQL

•             Skilled at optimizing large complicated SQL statements

•             Knowledge of best practices when dealing with relational databases

•             Experience in working with SSIS package

•             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

•             Experience with procedures and scripts for data migration

•             Document specifications and design solution

•             Generate technical training documents