Database Sql Developer

TL;DR

Database SQL Developer: Developing high-quality database solutions using T-SQL, stored procedures, and functions with an accent on performance improvements and data migration. Focus on analyzing SQL queries, building reporting deliverables, and ensuring timely management reporting.

Company

hirify.global is a global software company that believes ecommerce software should enable sustainable growth.

What you will do

• Develop high-quality database solutions.
• Use T-SQL to develop and implement procedures and functions.
• Review and interpret ongoing business report requirements.
• Analyze existing SQL queries for performance improvements and suggest new queries.
• Develop procedures and scripts for data migration.
• Provide timely scheduled management reporting.

Requirements

• 3+ years experience in SQL Development.
• Proficiency in T-SQL, Stored Procedures, Functions, Triggers, XML Operations, and JSON support on SQL 2016 and above.
• Experience with SSIS, SSRS, CTE, and EAV Data structure.
• Experience integrating with NoSQL(MongoDB), SQL Server Indexes, Bulk Insert, BCP, and CMD Shell.
• Knowledge of Memory Optimization, Performance Tuning, Query Optimization, Database Designing, and Table Joins.
• Familiarity with SQL Server Job agent, Backup and Maintenance plan, Data Migration, and Good Communication.

Nice to have

• Working knowledge of mobile development activity.
• Working knowledge of web hosting solution on IIS7.
• Experience working with an offshore – onsite development process.