Hands-on experience in setting up and configuring new SQL server transactional push replications. Experience in supporting SQL server replication agent failures, latency issues.
Experience in reviewing SQL server Agent jobs, tasks and SSIS packages to monitor in production environment.
Experience in T-SQL query analysis, execution plan, performance tuning etc Maintaining SQL server/Database user access/permissions.
All production SQL data database support (database backup/restore, SQL server installation, upgrade and configuration.
Experience in troubleshoot application sluggishness and poor performance.
Experience in maintain, and administer complex ETL using SQL Server (SSIS).
Experience in analyze and understanding SSIS workflow/dataflow tasks to support production jobs and activities.
Knowledge of Azure data factory pipelines and Azure SQL Managed Instances.