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 system health and performance, to ensure high-performance levels, 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.
The ideal candidates must have :
Minimum 3 to 5 years of relevant experience in data modeling, database & data warehouse management, and 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