BURHAN INSELBAGGIL

Richmond Hill, ON, L*B *H*

linkedin.com/in/sqlpro 647-***-**** aczfuw@r.postjobfree.com

SQL SERVER DBA/DEVELOPER/ARCHITECT

Connect “big picture” business needs to engineering specifics

by leveraging deep SQL Server 6 to 2016 expertise

Known as trusted advisor. Believes in proactive approach. Seeks innovative ways to improve database efficiency and quality to maximize the ROI. Strives to make the database systems robust and secure.

Collaborate well. Excellent customer and vendor relation skills; set expectations and ensure customers’ needs are met within time sensitive deadlines. Possess high degree of integrity demonstrated by the ability to handle sensitive information. Holds “Enhanced” and “Secret” Federal Security Clearances.

Expertise:

Database Design / Architecture

Health-check / Assessment

T-SQL Development

Performance Tuning / Troubleshooting

Cloud – Azure (PAAS, IAAS)

Microsoft BI Tools including Power BI

PROFESSIONAL EXPERIENCE

SQL SERVER CONTRACTOR / CONSULTANT Jan 2016 – Present

Client: COSSETTEhttp://www.centrichealth.ca, Toronto, ON SQL Server Developer/Architect (Jan 2017 – Mar 2017)

Designed and implemented new marketing database ETL & Reporting technical solution using SSDE, SSIS, BIDS

Published Design and Operational documentation

Client: CENTRIC HEALTHhttp://www.centrichealth.ca, Burlington, ON SQL Server Consultant (Aug 2016 – Nov 2016)

Assessed and remediated Kroll(pharmacy) application database after major performance issues

Client: DELOITTEhttp://www.centrichealth.ca, Toronto, ON SQL Server Developer (Jan 2016 – Jul 2016)

Called for a long running performance problem with Deloitte Global team’s key in-house ETL & Data Warehousing application that collects, processes, and distributes employee data to its member(countries) firms

Dropped key process duration from 48 hrs to 6 hrs (takes 13% of the original time to run on the same server) by

oRe-writing complex stored procedures

oIndex Tuning

oOS and SQL Instance configuration changes

Called for a deadlocking and concurrency issue on their SQL Server 2008 conversion system at WSIB (June 2014)

Fixed both issues by tuning and increased conversion process throughput by 30%

MICROSOFT CANADA, Mississauga, ON Nov 2014 – Dec 2015

Premier Field Engineer - SQL Server

Provided mostly proactive services designed for large and mid-market enterprise customers to increase health and stability thus improving their service delivery. Required to:

- Work independently with minimal management supervision as part of nationwide team of engineers

- Provide regular thorough and specialized documentation capturing engagement objectives and outcomes

- Provide 100 level chalk-talks and demos on Microsoft Azure focusing on IaaS

Delivered workshops, chalk-talks, risk assessments (RaaS), short-term/long-term custom engagements

Specialized on database backend performance tuning for SharePoint and Dynamics AX

FIRMEX, Toronto, ON Aug 2013 – Nov 2014

SQL Server DBA/Developer, Engineering Team

Planned and implemented a SQL Server 2012/2014 High Availability and Disaster Recovery solution for an application with 44,000+ databases currently on clustered SQL Server 2008R2 instances

Designed and developed Firmex BI’s ETL processes using MS BI tools

SQL SERVER CONTRACTOR / CONSULTANT Aug 2005 – Jul 2013

Client: COMPLETE INNOVATIONS, Markham, ON SQL Server Consultant (Jun 2013 – Jul 2013)

Completed an initial health and performance assessment for new version of their fleet management application. Initial assessment followed by a remediation plan. Urgent steps are implemented.

Client: CENTRIC HEALTH, Toronto, ON SQL Server Consultant (Mar 2013 – May 2013)

Completed an initial health and performance assessment. Created remediation plan. Executed %80 of the plan.

Application performance for key transactions and reports improved 20% to 80%

Client: IBM CANADA, Markham, ON SQL Server Production DBA, Contractor (Jan 2009 – Oct 2012)

Dedicated to Rogers, Bank of Nova Scotia, Bell accounts. Supported (3rd level) critical 1200+ SQL Server instances.

Lead a large successful SQL Server security project for Rogers from assessment to remediation.

Client: ONTARIO MINISTRY OF TRANSPORTATION, Toronto, ON SQL Server DBA, Contractor (Sep 2008 – Oct 2009)

Architected the database layer of the new Ontario-wide service delivery environment using SQL Server 2008 including SSAS, SSRS, SSIS, SharePoint, Dynamics, System Centre, TFS and others

Physical design included 74 SQL Instances (on 8 SQL Server clusters) servicing 40,000 provincial employees

Client: MERCER, Consulting firm, Toronto, ON SQL Server DBA/Developer, Contractor (Jan 2008 – Sep 2008)

Designed and documented SQL Server Security, DR, and Development Policies, produced guidelines.

Designed, implemented, and supported SQL Server 2005 Farms on 64-bit OS, including one 3+TB database.

Client: IBM CANADA, Markham, ON SQL Server Production DBA, Contractor (Aug 2005 – Oct 2007)

Supported critical replicated and log-shipped 20+ (few 1+TB in size) databases on clustered servers. Optimization Expert.

Improved high availability from “One 9” to “Three 9s” in two years

NAVCANADA, Ottawa, ON Aug 2004 – Jul 2005

Lead SQL Server DBA/Developer

Contributed to the development of efficient, effective organization that uses defined processes, standards, and procedures; primarily on security, SQL development, VLDB maintenance, change and incident management

MICROSOFT, Mississauga, ON May 2003 – Aug 2004

SQL Server Support Engineer, Product Support Services, Contractor/Vendor

Worked on incoming SQL Server support calls and achieved a high number of cases handled per engineer.

EDUCATION / TRAINING

Associate of Science in Electronics, Computer Option, Bogazici University, Istanbul, Turkey, 1996

SQL Server Data Engine (2-month full-time 300 level internal training), Microsoft, Toronto, ON 2014

Participated and reviewed 2 beta courses presented by content writer, Microsoft, Seattle, WA 2012

- 20465A: Designing Database Solutions for Microsoft SQL Server 2012

- 20467A: Designing Business Intelligence Solutions for Microsoft SQL Server 2012

Presented “SQL Server Troubleshooting” session for TorPASS, 2009

Presented “SQL Server 2008 Performance Tuning and Monitoring” session at TechDays Canada, 2008

Contact this candidate