Roles and Responsibilities (Must Have these skills/experience)
Develop ETL processes to extract data from multiple sources, transform it into a standardized format, and load it into target systems.
Troubleshoot database performance issues by analyzing logs files, executing queries on the server side, and optimizing query execution plans.
Design, develop, test, deploy, and maintain complex SQL databases using various tools such as SSMS, T-SQL, and PowerShell.
Excellent knowledge on writing Stored Procedures
Excellent debugging skills on Stored Procedures
Performance tuning experience
Valuable knowledge in writing Views, Cursors, Triggers and functions.
AWS experience