SQL Server Data Engineers

The SQL Server Data Engineer will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. The data warehouse supports an enterprise application suite of program management tools. Must be capable of working independently and collaboratively.

Responsibilities:

• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Troubleshoot issues related to memory-optimized tables in MS SQL Server 2019
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Assist developers with complex query tuning and schema refinement.

Requirements

The ideal candidates must have:

• Minimum 5 years of relevant experience in data modelling, database & datawarehouse management, performance tuning on Microsoft SQl server Databases
• 3+ years of experience with programming and database scripting; and
• experience with clustered configurations, redundancy, backup and recovery
• Good knowledge of SSIS development, T-SQL, Views, Stored Procedures, Functions and Triggers.
• Experience in AWS and Azure Cloud will be an added advantage

Remote Work :

No