Sql Server Data

Viswanath Subramanian (Vish)

Cell No 571-***-**** Email - *******@*****.***

oOver fifteen years’ experience in the software Industry, worked in various customer facing roles providing support to SQL Server environments (2016- SQL version 7) in OLTP & Data warehousing Environment.

oMore than 8 years’ experience with setting up HA solutions using SQL clusters and setting up DR plans,

BCC Exercise, design of protection and recovery plan.

oRecognized as an MVP in SQL Server by Microsoft Corporation for 2006-2007

oWorked extensively in data mining solutions and implementation of high availability solutions.

oMore than 7 years’ experience in database development, performed large database design, created Data model, data dictionary, setup constraints and wrote complex SQL code (stored procedures,triggers,views and other DB objects)

oHands on experience in troubleshooting and administering support to large no of databases in production environment, supported DB sizes in the range of 4 TB (OLAP environment) up to 900 GB (in OLTP environment).

oWorked in the role of Technical Account Manager managed a 10-member team compromising L1, L2 support, managing day to day operations.

oExperienced in Onsite-Offshore model, Managed escalations, planned server migration activities and coordinated production change, prepared SOW for Offshore teams.

oMore than 8 years of experience in setting up SQL Clusters (active-active / active-passive) log shipping, SQL mirroring, transactional replication.

oExtensive experience in troubleshooting, Identifying performance bottleneck using SQL profiler, PerfMon, Query Optimization, Query Plan analysis, trace commands, re-configuring parameters, creating, rebuilding indexes, running DBCC commands, recompiling stored procedures and updating statistics

oWorked as Microsoft® vendor employee, involved in data migration projects, responsible for developing ETL tool for migration of Data from a legacy system to the current system, mapping logic, cleansing data, performing validation for Microsoft® Events portal.

oExtensive knowledge in Change Management/Incident Management/Problem Management.

oInvolved in the designing a load balanced system using partition, distributed processing for upstream and downstream systems, and using complex replication setups.

oWorking knowledge of localization databases, designing databases permitting different localization.

o Automation, tools development to facilitate support, management of disk/DB space, forecasting, Purging and

Maintenance of large databases in database ware environment.

SUMMARY OF TECHNICAL SKILLS

Database

SQL Server 2016/2014/2012 SP2/2008 R2/MySQL (5.X)

SQL Tools

Query Analyzer, Profiler, Query Execution Plan, Index and Database Tuning Advisor

ETL Tools

SSIS/DTS, BCP,OLAP

Reporting

SSRS (SQL Server Reporting Services)

Data Modeling

Toad Data Modeler, ERWin 8.2 & 9.5, SSDD (SQL Server Database Diagram), & VISIO

Monitoring Tool, Others

Solarwinds Orion, COTS Implementation & Maintenance

Operating System

Windows Server 2008R2/2008/2003/2000, Windows XP/NT4.0, MS-DOS, & VMware

Hardware/Storage

SAN, RAID

Performance Tuning Tools

Profiler, Query Execution Plan, Index and Database Tuning Advisor, Windows Event, System Stored Procedures, DBCC, DMV

Third Party Tools

DBArtisan 8.7.0 & 9.5.1, Idera SQL Admin Toolset, Redgate SQL Compare 8 & 11

Development Tools

Visual C++, Visual Basic, ATL, COM+,MTS,Python

Education Qualification

Masters in Leadership Northeastern University, Boston

Bachelors in Computer Science Madras University, India

Professional Experiences:

Employer -COMMVAULT

Jan 2017 – Till Date

Role- Senior DBA / Developer

Location – New Jersey

Description As a member of the core product engineering team, am responsible for DB core design, ensuring high quality of code that can scale up, enforce best practices which compares to the industry standard, promote high security standards that can make our application run in very secure environment where permissions are severely restricted.

Responsibilities:

oSupport- Managing customer escalations, identifying production issues at customer locations, creating hotfix.

oServe as an expert consultant to applications developers to provide expertise on database escalations, query tuning, index suggestion and execution plan analysis.

oSAAS Manage SAAS environment databases, sync in-premise database with SAAS.

oTSQL-Involved in creating new features, implementation of POC’s using SQL, Python and PowerShell scripts.

oResponsible for architecting troubleshooting framework that keeps track of health of the primary database by performing proactive monitoring of application health, errors and creates reports that are shared in the cloud environment.

oCreated new tools that automate operations, periodic maintenance and perform housekeeping activities.

oAZURE-Troubleshoot database performance issues in in-premise managed service, SAAS and customer locations. Extensively used extended events, Profiler to troubleshoot performance issues like deadlocks, blocking and other environmental issues such as memory, CPU, I/O, Disk, etc.

oIdentifying critical performance bottlenecks in product and creating alternatives.

oUnderstanding the C++ code and converting cursors to SQL SET based operations.

Employer -EXPERIS

Apr 2009 – Dec 2016

Client – International Monetary Fund (IMF)

Location – Washington DC

Role- Primary SQL Server DBA

Description Was responsible for delivering operational support for TGSIK Division and Joint Library production servers, in my role I created the charter, Disaster recovery plan, server migration plan, audit compliance report .During my tenure I have played key role in the company’s server consolidation efforts,maximized savings by reducing licensing cost, have been key player in collaborating with various teams in server migration and performing sever move under restrictive outage intervals.

Responsibilities:

oInstall /Configuration Performed unattended installation (uninterrupted installation) of SQL Server 2008 R2 SP2, SQL Server 2012 SP2 in development, and staging and production environment using the configuration file.

Configured and managed veritas clusters, always on clusters, standalone SQL Server 2008 R2 SP2, SQL Server 2012 SP2, SQL Server 2014 in development, and staging and production environment.

oDR Plan-Configured mirroring with automatic failover, Always ON Availability Group with Asynchronous and Synchronous Mode,BCC failover plan for all Prod server, Log shipping setup for legacy apps

oPatch Management –Rolled out patch for 100 + Server using batch file, PowerShell remote.

oTSQL -Work with Database Developers to optimize SQL queries and Stored Procedures, Writing custom tools to monitor DB threshold, Indexes fragmentation and Disk capacity

oCreated a config store and migrated packages to centralized SSISDB repository, replicating data from OLTP environment to DW environment for OLAP reports.

oScheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, index re-building etc.

oTroubleshooting Monitor SQL Server Error Log, space usage, Index usage analysis, creating new indexes, data archival plan, rollout scripts to production, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views.

oConfigured additional monitoring using SQL Event Notification to monitor DAC and login changes.

oWorked with development team to set up audit procedures on critical tables using extended events.

oImplemented and configured several COTS applications.

oAuthored and maintained all the SQL Server installation, Service Pack installation documents for the team.

Employer – Mastech June 2008 – Apr 2009

Client – US Bancorp Location – Minneapolis, MN

Responsibilities

oResponsible for managing the inventory database, created new automated tools for monitoring SQL Server using SP and OSQL

oIdentified and fixed various SQL Server Security violation

oSetup multiple database replication between various production environments

oSetup and migrated SQL Server to 2008 and 2005, Configured Database mirroring and log shipping for database high availability.

Employer – Wipro Technologies April 2005 – June 2008

Client – Washington Mutual, Capital One Auto Finance Locations –USA,UK,India, Credit Suisse, Microsoft Corporation

Responsibilities

oResponsible for total understanding of the customer environment, documenting the environment and creating procedures so other DBA’s can seamlessly support the customer with very less interaction or questions.

oSchedule work for Offshore DBA’s, setup internal change control meetings, root cause analysis procedures, document preventive measures, emergency response procedures, On call rotation chart

oSetting up remote facility and offshore support environment, VPN and security

oRepresent DBA team in CAB meeting for scheduling release to production and prepared escalation and root cause analysis reports.

oPrepared a Handoff routine for the US staff and offshore staff, Tracking SLA reports and preparing offshore metrics.

oHire,On boarded new DBA and train new DBA’s

oDocumented the current environment and prepared baseline reports, automate installation build scripts.

oSetup guidelines and procedures on handling critical incidents, set up best practices for offshore, incident handling procedures, define track SLA adherence.

oWorked on escalated deadlock and performance issues which required deeper analysis

oInstall configure SQL Clusters, Mirrors, Troubleshooting SQL replication, SSIS Issues in production.

oPerformed critical Log shipping failover. Worked with the compliance team and external audits, reviewed the various violations in SQL Server and fixed security violations.

Employer – Innova Solutions (Ness Technologies) Nov 2004-April 2005

Client – Sage metrics Corporation Location –LA & India

Responsibilities

Work involved writing complex number crunching algorithms for click stream analysis, Ad targeting for large fortune 500’s. Process involved daily processing of large weblogs over multiple terra byte in size, breaking it into chunks and performing distributed processing using more than 250 servers simultaneously to obtain unique visitor number. My work involved redesigning the system for high efficiency computing and improved batch processing for faster computing, re-design workload support on various MYSQL and MS SQL Server, created tools for NOC to troubleshoot

Employer – Satyam Computer Services Apr2003 – May 2004

Client – Microsoft Corporation (https://events.microsoft.com/) Location – India

Responsibilities

Am Responsible for architecting database design, creating localization support, XML support. Preparing High\Low Level design documents, generating Erwin Model, creating OLAP reports. DB build Scripts, performed data migration between legacy applications to the new system.

Contact this candidate