Sql Server Management

PAVAN ADHYAPAK

Seeking assignments in SQL Server Database Designing / SQL Server Database Administration / Troubleshooting / Client Coordination with an organization of high repute.

CORE COMPETENCIES

Database Administration

Database Designing

SQL Query Tuning

Troubleshooting

Client Coordination

PROFILE SNAPSHOT

EMBA (Information Technology) with over a decade of experience in Database Designing, SQL Designing, Troubleshooting and Client Coordination

Expertise in SQL Database Administration activities encompassing database planning, design, installation, configuration, disaster recovery planning, back up & recovery

Skilled in design, development & support of MS SQL Servers 2012, 2008, 2005, 2000 development environments, replication and cluster server environments

Hands-on experience on MS-SQL Code review & approval, applying database patches, up-gradation, migrations, database cloning, user management, space management and troubleshooting on Windows platforms

An effective communicator with strong planning, analytical and problem solving skills

TECHNICAL PURVIEW

Operating Systems: Windows 2003, 2008, Windows Azure, Linux, Ubantu and CentOS

Database: SQL Server 2012, 2008, 2005, SSISand SQL Azure

Monitoring: SCOM 2007

Big Data: Hadoop Admin

AREAS OF EXPERTISE

Experienced database architect with experience in designing, implementing, and managing enterprise relational and dimensional solutions.

Accountable for database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, developer/integrator relations, script development, documentation and DBA training.

Troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics, and Index Tuning Wizard.

Using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.

Preparing application development backup policies, database migration, SQL server replication, etc.

Creating table’s paces, rollback segments, user maintenance, and database security imposition by creation and granting of roles & privileges, performance tuning, backups&tuning of SQL statements.

Experience in creating SSIS packages,managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.

Implementation and administration of Hadoop infrastructure; Install Linux operating system and Hadoop updates, patches, version upgrades.

Guidance on hardware architectural, planning and estimating cluster capacity, and creating roadmaps for Hadoop cluster deployment.

EMPLOYMENT DETAILS

Unilever, Englewood Cliffs, NJ. Feb 2016 - Till Date

SQL Server DBA Architect Domain: Product

Working on Production environment managing business critical databases which contains Product& Retailers information. Major involvements are administering production, test and development servers, optimizing queries for better performance and design.

Key Result Areas:

Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.

Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.

Performed typical maintenance (re-indexing, backups, manage recovery protocol), monitor and manage space usage, master-slave replication and processing speed. Resolve any data corruption, recommend optimizations.

Proactively identify and resolve any performance issues.

Monitor usage, recommended dropping any tables/indexes or making schema optimizations, promote best practices.

Review or implement schema design, recommend technical solutions and set up platforms for new systems.

Recommended SQL query optimisations and advise developers on the quality of their queries.

Prototype and implement new database features, including Stored Procedures, indexes, schema changes, etc.

Symantec Corporation, Oct 2014 – Feb 2016

Senior SQL Server DBA Architect Domain: Security (Anti-virus)

Worked on Production environment managing large volumes of business critical databases (22 TB) which contains Anti-Virus related data. Major involvements were administering production, test and development servers, optimizing queries for better performance and design.

Key Result Areas:

Provided 24x7 troubleshooting of 2 business critical MSSQL DBs and a number of internal ones.

Responsible for availability, performance and scalability to support the tremendous growth of various services provided by the team.

Performed typical maintenance (re-indexing, backups, manage recovery protocol), monitor and manage space usage, master-slave replication and processing speed. Resolve any data corruption, recommend optimizations.

Proactively identify and resolve any performance issues.

Monitor usage, recommended dropping any tables/indexes or making schema optimizations, promote best practices.

Review or implement schema design, recommend technical solutions and set up platforms for new systems.

Recommend SQL query optimisations and advise developers on the quality of their queries.

Prototype and implement new database features, including Stored Procedures, indexes, schema changes, etc.

SQL Server Upgrade from SQL Server 2005 to SQL Server 2012.

Auditing security settings of the MSSQL Servers and taking corrective action.

Barclays Jan 2012 – Oct 2014

Senior SQL Server DBA Domain: Investment Banking

Managed & supported over one hundred fifty (150) database instances that are used by in-house and third party applications. Major involvements were administering production, test and development servers, optimizing queries for better performance, design and development of in-house monitoring solution for database servers and developing operational standards.

Key Result Areas:

Providing 24x7 troubleshooting and tier-2 support for Microsoft SQL Server version 2000, 2005, 2008 R2 & 2012

Implementing Windows & SQL Server Failover Clustering and SQL Server 2012 AlwaysOn Availability Groups backup & recovery plans

Designing & executing plan to migrate 200 production databases and 1.5 TB of data to a new secure data centres, including auto-generating all T-SQL and Robocopy scripts in advance

Troubleshooting problems by using SQL Server Profiler, SQL Server Performance Dashboard Reports, Activity Monitor, PAL Tool and Perfmon

Resolving critical production problems and performing point-in-time database recoveries

Administering complex enterprise-wide SQL Server 2005, 2008 R2 and 2012 instances

Applying SQL service packs to the current patch level and cumulative updates to address specific issues

Managing topology and capacity planning including number of Windows, SQL server cluster nodes, SQL server instances, CPU, RAM speed & quantity and SAN disk configuration

Upgrading DTS packages to SSIS and developing new SSIS packages for ETL

Developing & implementing a process to auto-generate all database recovery T-SQL scripts and saving those commands with backup files and making recovery easily available

Maintaining:

oSQL server documentation including DBA manuals for most every server including design, installation and configuration, as well as detailed work logs

oIndex optimization, consistency checks and data file; monitoring transaction log size using built-in tools, custom written T-SQL scripts, SQL agent jobs & database mail and enterprise monitoring using SCOM & Precise

Accomplishments:

Received "Star Award" for Automating 2005, 2008 SQL Server Patching missing binaries on the server in FY12

Microsoft as Lead Operation Engineer Jan'06 to Jan'12

Domain: Product

Worked as a Lead Operations Engineer at Microsoft, supporting mission critical business applications for Microsoft Corporation. I worked on numerous issues of SQL Server and SQL Azure primarily responsible for maintenance and Performance tuning of SQL servers with 99.9 % up time. Leading and managing the team of vendors in day to day work.

Key Result Areas:

Assisted over 50 instances of Microsoft SQL Server 2000, 2005, 2008 and 2008 R2 across the enterprise

Implemented SQL Server high availability solutions including failover clustering and log shipping in 32 bit & 64-bit Windows Server 2000, 2003, 2008 & 2008 R2 environments

Ensured regular maintenance of index rebuilds, reorganization and statistics updates

Monitored database & application performances, identified issues, troubleshoot & optimizedusing SCOM 2007, AVICODE, performance monitor, profiler, execution plans, database engine tuning advisor and performance dashboard reports

Installed Windows Server on both physical & virtual machines in HyperV; looked after building of service accounts, configuration of networks and creation of firewall rules

Coordinated with core infra teams, upstream (management & stakeholders) / downstream (users and partners) integrations teams on plethora of issues simultaneously while communicating

Provided optimum work-around resolutions to application/data/configuration/environment related issues within SLA

Worked on SQL Server (2000, 2005, 2008), Windows Enterprise Server (2003, 2008) and IIS (6&7)

Assisted Tier-1 (Infra Monitoring Teams), Tier-2 (Application End User Support teams) and Tier-3 (Technical Escalation Team) for Microsoft Incident Management Suite of Tools

Handled entire production release process for LOB applications with more than 15 releases for 10 applications with zero escalations

Oversaw engineering teams for various integration applications and took PMs from IT & Business Teams on prioritization of critical business impacting issues

Analysed the trends/symptoms and worked on capacity & performance issues apart from collaborating/engaging with engineering teams, PSS teams and product teams for issues beyond the support scope

Project Title: MSQuote Database Design Project Location: Seattle (Redmond)

Role: Lead Operation

MSQuote is part of Microsoft Licensing solution which helps channel partners and TAMs with the ability to handle the ‘out of process’ business requests on the existing Licensing Operations Platform Applications across different business units. The users of this application are Internal MS users.

Responsibilities:

• Stakeholder interaction for requirement data gathering and planning.

• Responsible for designing/developing the application, database and its components.

• Designed High Availability Solution using clustering & DB Mirroring.

Tools and Technologies: VB.NET, ASP.NET, SQL Server 2008.

Project Title: SQL MigrationProject Location: Seattle (Redmond)

Role: Lead Operation

Microsoft APOC operations serve internal customers and official partners with various tools/applications for their regional operations and support. These applications range from costing, forecasting, license printing, quality and other various tools. This project is for migrating the existing applications which was designed and running with SQL 2005 to run on SQL 2008 R2.

Responsibilities:

• Responsible for systems configuration & integration (Pre Migration)

• Technical capacity assessment/review. Escalate Bug fixing, working with SQL Core Dev Team.

• Responsible for supporting the application, database and its components (Post Migration).

Technology: Tools and technologies of SQL 2005, SQL 2008

Accomplishments:

Accredited with:

o"IT Pro Award Passionate" in FY 2007, FY 2008 & FY 2009 - Involved in identification of various bugs in Volume Licensing applications and partnering with engineering & solution delivery. Excellent work in making Volume Licensing support successful and demonstrated MSIT attribute of Partnership

o"IT-Star Support Award"FY 2010 & FY 2011–Involved in performance analysis during November 2011 release that allowed right sizing hardware and fixed system bottlenecks which resulted in improved performance for users

Made outstanding contribution in Pricing Application during FY 2007-08–Pivotal role in successful deployment of pricing enhancing tool to support key business requirement. Conducted detailed Business test that unearthed critical configuration during production deployment & proactive in conducing trainings for Service desk & L3 team and partnership in ensuring close monitoring post deployment

Certifiedon Volume Licensing Sales Specialist in 2010

EDUCATION

2014 Executive MBA (Information Technology) from National Institute of Business Management (NIBM), Chennai.

2004 B.Sc. (Computer Science) from Pendharkar College of Science, Commerce & Arts, Mumbai University.

CERTIFICATIONS

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Implementation &Database Development and Windows Server 2008 R2 Server Virtualization

Microsoft Certified IT Professional (MCTIP): Database Administrator &Developer SQL Server 2008, Designing &Developing Windows Azure Cloud.

ITIL Foundation Certified

TRAINING

Trained on Hadoop Admin Setup in 2014

Attended training in Six Sigma Green Belt and Project Management Skills in 2011

PERSONAL DETAILS

Date of Birth: 25th October, 1982

Contact this candidate