Description

You will develop and implement database solutions using T-SQL to meet business reporting requirements.

Responsibilities

• Develop and implement T-SQL procedures, functions, and triggers.
• Analyze existing SQL queries to implement performance tuning and query optimization.
• Build reporting deliverables and manage scheduled management reporting.
• Develop procedures and scripts for data migration and bulk inserts.
• Manage SQL Server Job Agent, backup, and maintenance plans.

Required Skills

• 5+ years of experience with MS SQL Server.
• Expertise in T-SQL, Stored Procedures, Functions, and Triggers.
• Proficiency in XML Operations and JSON support on SQL 2016 and above.
• Hands-on experience with SSIS and SSRS.
• Deep understanding of CTE, EAV data structures, and Table Joins.
• Experience with SQL Server Indexes, Memory Optimization, and BCP.
• Ability to handle Data Migration and CMD Shell tasks.
• Knowledge of Database Designing and SQL Server maintenance.
• Experience with NoSQL integration, specifically MongoDB.
• Familiarity with PL/SQL, Office Open XML, and SQL Azure.

Preferred Skills

• Working knowledge of mobile development activity.
• Experience with web hosting solutions on IIS7.
• Experience working within an offshore-onsite development process.

Key Skills

Education

Any Graduate