Jagdeep Walia Email & Phone Number

Mississauga, Ontario, Canada

Mississauga, Ontario, Canada

Toronto, Canada Area

Restored lower level SQL environment databases from the production backups on a predefined schedule or ad hoc basis.Designed and developed SSIS modules to load and transform large datasets in and out of the system.Planned and tested Disaster Recovery run through for the Production Servers, facilitated Server upgrades and migrations.Independently configured and maintained SSRS Production Servers.Responsibilities also included deployment and optimizing underlying stored procedures for faster reporting.Promotion of databases and related objects to Production as well as client data loads.Lead the File and Data Analyst team for Data Conversionsefforts and design SSIS packages using BIDS for File Imports& Exports for Benefit Platform.Organized technical meetings with Business Teams for Data Conversion processes, provided administration support for the implementation projects.Deployed objects on the SQL, index tuning, re-building, statistics updatesand database maintenance activities.Analyzed and troubleshoot T-SQL queries, recognize expensive queries and provide or implemented solutions to developer for optimization.Maintained high availability of the SQL Server using Clustering and log shipping.Resolved incidents, change requests and security issues using HPQC/Jira &Maestros.Remote support and after hours support to keep business “lights on”.Partnered with Infrastructure Team to Upgrade SQL Prod Servers from 2005 to 2008R2 along with Windows Server upgrade.Developed import and export processes for large datasets as per Client needs using SSIS.Gained Knowledge of Azure SQL Databases through Microsoft Official Training to leverage scaling and ease of creating DBs as per clients changing needs.

Toronto, Canada Area

Performance monitoring of client applications and serversMonitor Report Server Activity using PerfMon, SQL Profiler and Database Tuning WizardProduce performance monitoring analysis reports and recommendationsDesigned ETL processes for archiving and copy multiple flat filesDeveloped, tested and document ETL processes using SSIS and other tool setsTuned T-SQL query and increased performance by 20% Monitored Mirrored Servers and provided support for High availability

North York, On

Monitored over 40 SQL Servers using SQL Profiler and ServerVantageSynchronized the monitoring of large number of SQL Servers and identified bottlenecksDeployed build on Production ServersInstalled SQL Server 2008R2 on Windows 2008 Production Servers, assigned User logins and defined their roles.Developed Strategy to provide Clustering Failover and Database Mirroring on SQL Server.Configured Data Base mirroring with Witness on Development Server for testing.Refreshed SQL Production Servers and resolved Database issues using Remedy.Resolved incidents, change requests and security issues using Remedy Provided new instances and login access for pilot projects Advised Team Leader on SSAS Server requirements and its licensing issuesWorked on Oracle database using Putty for updating queries and data

Co-Op

B.Tech, Electronics & Communication