Create database design and help create tables, SQL statements for data presentation and further automation.
Set up and monitor routine maintenance SQL jobs and develop/maintain an alert strategy for failed jobs and database problems or failures.
Automate deployments using CI/CD, handle team estimations, and delivery.
Modify/update T-SQL scripts for importing and organizing data, work closely with analysts and other department personnel in advising best SQL coding practices.
Manage multiple projects simultaneously within time and budget constraints.
Be responsible for data profiling, source-target mappings, ETL development, SQL tunings, and optimization, testing, and implementation.
The candidate must have strong data management skills, good understanding of indexing, querying, and normalization, good understanding of relational database management system, good understanding of database integrity and security.
At least 5 years using MS SQL, data modelling, including an understanding of all normalized forms, design, and development of stored procedures, views, and triggers
