Key Responsibilities
Develop high-quality database solutions.
Use T-SQL to develop and implement procedures and functions.
Review and interpret ongoing business report requirements.
Research required data.
Build appropriate and useful reporting deliverables.
Analyze existing SQL queries for performance improvements.
Suggest new queries.
Develop procedures and scripts for data migration.
Provide timely scheduled management reporting.
Investigate exceptions with regard to asset movements.
MUST-HAVES FOR THIS GIG
T-SQL, Stored Procedure, Functions, Triggers, XML Operations, JSON support on SQL 2016 and above SSIS, SSRS, CTE, EAV Data structure, Integration with NoSQL(MongoDB), SQL Server Indexes, Bulk Insert, BCP, CMD Shell ,Memory Optimization, Performance Tunning, Query Optimization, Database Designing, Table Joins, SQL Server Job agent
Backup and Maintenance plan ,Data Migration, Good Communication
Nice-to-haves For This Gig
Working knowledge of mobile development activity.
Working knowledge of web hosting solution on IIS7.
Experience working with an offshore –onsite development process
Skills:- MS SQLServer, PL/SQL, Office Open XML and SQL Azure
Any Graduate