Solid knowledge of the logical/physical database design
Knowledge of TSQL coding DML, DDL, and DCL. Complex Stored procedures, functions, views, triggers, and TSQL Tuning.
solid knowledge and experience in managing high volume transactional databases
Troubleshooting database issues
SQL Server automation
Securing database infrastructure
Knowledge of all MS SQL Server backup and recovery scenarios.
Implement SQL Server HADR with Always-On Availability groups.
Microsoft® SQL Server 2016
Managing ETL workloads through SSIS
Managing reporting through SSRS, crystal reports.
Managing business analysis through Power BI, Excel 2016