Sql Server Data

Shekar Chandra PH: 408-***-**** Email:*********@*****.***

Summary,

Over 12 Years of Experience working as SQL Server DBA

with SQL Server 2014,SQL 2012, SQL Server 2008 R2,/SQL Server 2005/2000,

Worked in roadmap development migration to Microsoft SQL Server 2014

Migration of database services to Cloud based technologies (e.g., Amazon, Azure, Rackspace)

Design and implementating of High Availability(HA) systems (24x7x365) and

Disaster Recovery models(DR): including Setup, Configuration, and monitoring of Database Recovery strategies such as AlwaysOn, Failover Clustering, Replication, Database Mirroring, and Log Shipping

Responsible for administration, maintenance, performance monitoring and availability of Enterprise Production SQL server environments

Provide on Call Support for Prod mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end

Extensively worked in advanced performance tuning, Research and troubleshooting,Query optimizing database design, capacity planning and establishing standards for SQL installations, maintenance, database tuning,backup/recovery, Migration, and codingstandard apply patching & upgrading SQL server software

Worked as data architect or data modeller. Administers and controls an organization's data resources, including multiple relational databases and servers

Evolve the quality and consistency of service delivered by our platforms through automation and process improvement

Carry out root cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments.

Carry out analysis of performance reports and proactively identify expensive SQLs and other performance bottlenecks.

Work with Other DBA’s and application teams to explain critical production performance issues.

Participate in software design reviews with developers to ensure that the architecture is scalable to meet long-term performance goals.

Database optimizing, Indexing, Index partitioning, Table partitioning, disk partitions, Query optimizing, and Disk optimizing.

Physical and Logical Data Modeling

Improve database efficiency by continuously monitoring database performance bottlenecks and perform tuning when required

worked (VLDB) very Large Databases such as multi-terabyte Databases

CERTIFICATION:

SQL Server 2008 Microsoft Certified Database Administrator MCITP

SQL Server 2005 Microsoft Certified Database Administrator MCITP

SQL Server 2000 Microsoft Certified Database Administrator MCDBA

Oracle 11g Certified Database Administrator DBA OCP

EDUCATION:M.Sc.Master’s of Science Major: Computer Science

B.Sc. Bachelors of Science Major: Computer Science

TECHNICAL SKILLS:

Databases

SQL Server2014,2012,SQL Server 2008 R2, SSIS,SSAS,SSRS,BI,

SQL Server 2005/2000,MYSQL,Shell Script, Oracle 11g, MYSQL 5.x, MS Access

Data Modeling

logical and physical Data modeling /Database design using Erwin and Visio etc.

Performance monitoring Tools used

Spot Light, IDERA,Red Gate,IBM Tivili TSM,Double take, SQL Server Profiler, System Monitor, Tivoli Monitoring, BMC patrol, Lumigent_Entegra, etc

Operating Systems

Windows 2008,Windows 2003/2000 Server(64bit), Windows 2000 Advanced Server server, Windows XP, Unix, LINUX.Shell Script

Storage

NETApp/EMC,SAN,Pure Storage Flash Drive Technologies, Rackspace

PROFESSIONAL EXPERIENCE:

Company:Ebay Inc, .(from08/2012 TO 05/2016 )

Position: SQL Server DBA

Responsibilities:

Manage a centralized MS SQL Server 2014, SQL 2012 and 2008R2 Platform consisting of thousands of mission critical databases

Expertise in High Availability and Recoverability of databases in a 24/7 environment using standard MS SQL technologies including Always On

Worked in roadmap development migration to Microsoft SQL Server 2014

Responsible for capturing various database, server, and application metrics, observing trends that will help longer-term capacity planning and analysis efforts

Design, Implement and mainain of Disaster Recovery(DR)and High Availability (HA)solutions with Log Shipping, Replication database Mirrioring etc

Partner with engineering teams to deploy cutting edge data platform technologies – including could base data platform technologies

Evolve the quality and consistency of service delivered by our platforms through automation and process improvement

Serve as primary DBA support for mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end

Ensure backup and recoverability of all enterprise SQL server databases

Design, Implement and mainain of Disaster Recovery(DR)and High Availability (HA)solutions with Log Shipping, Replication database Mirrioring etc.

Contribute to the ongoing development of technology and production processes company-wide.Keep abreast of new design tools, hardware, software and technology and make recommendations for future deployment

Document technical details of issues resolved and assist the team with building and maintaining technical repositories.

Work closely with the infrastructure team to perform SQL Server installations and to configure hardware and software so that it functions optimally with the DBMS. Plan and implement database upgrades as needed

Ensure appropriate procedures are followed for implementation of data and database changes

Develop and adhere to common database standards and procedures within a production operations unit.Maintain documentation related to database platforms, guidelines, methods and standards.

In-depth query performance tuning – detailed understanding of the query optimizer, execution plans, plan cache, cost estimation, indexes, and statistics

Strong working knowledge SAN/storage, hardware, and network components used in SQL Server implementations Extensive worked with NetApp/EMC storage technologies

Upgrade and Migrate all SQL Server databases from One Data Centre to Other in Enterprise Level data Centre

Worked as data architect or data modeller. Administers and controls an organization's data resources, including multiple relational databases and servers

Install Set up maintain and administering Microsoft Cluster(MSCS)

Carry out root cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments.

Carry out analysis of performance reports and proactively identify expensive SQLs and other performance bottlenecks.

Responsible for supporting and managing the enterprise-wide databases in Production, development and test environments

Providing DBAs supporting multiple SQL 2014/2012& SQL 2008 R2 RDBMS systems on large Production Infrastructure with responsibilities for managing the availability, reliability and performance of the environment

Responsible for supporting Multi-server Production SQL Server 2014/2012 Clustered database environment to ensure performance and, High Availability

support of large databases, including monitoring, re-indexing, general database maintenance, extract- transformation-load, backup/recovery, documentation, and configuration

Coordinate, schedule and implement database related patches; both software and security

Experience of Reporting, Analysis and Integration Services (SSRS/SSIS/SSAS)

Environment:SQL Server 2014,SQL Server 2012,SQL Server 2008 R2 Business Intelligence Powershell, (BI), to Cloud based technologies(e.g., Amazon, Azure, Rackspace),SQL Server Integration Services (SSIS), Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Profiler,Transact SQL(T-SQL),System Failover Cluster in SQL Server 2008 R2, NETApp/EMC,SAN,Pure Storage Flash Drive Technologies, Rackspace

Monitor, Data Model ERWIN, Microsoft Cluster Service (MSCS), Query Analyzer, Performance Monitor, Windows 2012/2008, SQL Server database virtualization, NET App, EMC Storage, SAN, Powershell

Third Party Monitoring Tools Used: Spotlight, IDERA,SQL LiteSpeedI, BM Tivoli(SM),

red-gate, Double take, SQL Server Profiler, Performance monitor, NETAPP.

Company:Stanford Hospital (from 07/2010 to 07/2012 )

Position: Sr SQL Server DBA

Responsibilities:

Upgrade and Migrate all SQL Server databases from One Data Centre to Other in Enterprise Level data Centre

Serve as primary DBA support for mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end

Work with IT-Infrastructure team to design/optimize physical server and disk structure layout in production, test and development environments

Install Set up maintain and administering Microsoft Cluster(MSCS) in SQL Server 2005,SQL Server 2008 R2 on Windows 2008 and Windows 2003

Carry out root cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments.

Carry out analysis of performance reports and proactively identify expensive SQLs and other performance bottlenecks.

Keep abreast of new, performance related SQL Server features and evangelize their use across IT teams.

Responsible for supporting and managing the enterprise-wide databases in Production, development and test environments

Migrated databases from SQL Server 2000 to 2005 and from 32-bit TO 64-bit with multiple data refreshes in the SQL 2005 environment

Identified critical hardware and software upgrades required and worked with technical & business personnel from proposal to implementation

Microsoft SQL Server management and performance tuning. Focuses on index tuning, query modifications, Table partitioning and hardware optimization.

Extensive worked on Migrating Databases residing on servers in one data center to another and Upgrading Database platforms to newer versions

Database administration for multi-terabyte databases including T-SQL coding, stored procedures, backup/recovery compress Backups to save Disk space in SQL Server 2005/2008

Environment: SQL Server 2008 R2 Business Intelligence (BI),SQL Server 2005, SQL Server Integration Services (SSIS), Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS),SQL Server 2000,DTS, SQL Profiler,Netapp SAN, Transact SQL(T-SQL),System Failover Cluster in SQL Server 2008 R2, Log shipping in SQL Server 2005/2008,Database mirroring in SQL Server 2008. MYSQL5.x, Shell script, LINUX

Monitor, Data Model ERWIN, Microsoft Cluster Service (MSCS), Query Analyzer, Performance Monitor, Windows 2003/2008, Windows 7.0, SQL Server database virtualization, NET App, EMC Storage, SAN, UNIX Solaris, LINUXRed Hat Enterprise

Company:IBM New Jersey (from 01/2008 to 07/2010 )

Position:Lead SQL Server DBA

Responsibilities:

Managing more than 175 SQL Servers, processing more than 12 million transactions

per day with other DBA staff and automated most of the jobs to cut the high management cost and increased productivity

Take responsibility for database monitoring, troubleshooting, performance tuning 24x7 availability of SQL Server databases

Involved in advanced performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning, and coding standards

Redesigned a thorough backup and recovery strategy for all major production systems

Run diagnostic tools to identify database performance bottlenecks including Clustering and replication experience

Prepare set up environment for Disaster recovery (DR Server) with Standby by ServerSet up configure and maintain Microsoft Cluster in SQL Server 2000/2005

Design setup maintaining strategies for High Availability systems (24x7x365)

Set and maintain and trouble-shoot Replication, Log-Shipping, in SQL server 2005/2

Designed and implemented Transactional and Snapshot Replication for Synchronization data between production and standby server in SQL server 2005

Administrator all SQL Server Databases creation/Installation/configuration, backups, recovery/restore, automate jobs, performance tuning

Responsible for logical and physical Database design RDBMS with a significant effort towards

application and database tuning

Take responsibility for database monitoring, troubleshooting, performance tuning and

the 7x24 availability of SQL Server databases

summaries to consistently meet aggressive product release timeframes

Monitor and Maintain DB growth and capture changes for capacity planning

Take responsibility for database monitoring, troubleshooting, performance tuning and the 7x24 availability of SQL Server databases

Design and implement disk structures, space management strategies, transaction log architectures and recovery models

Wrote installation and procedural manuals for support staff

Performing substantial data cleanup, restructuring and reporting

deployed and monitored SSIS Packages including upgrading DTS to SSIS

Index evaluation and recreating of indexes and views based on data collection methods

data modeling using ERWIN to document and maintain data model And data Dictionaries

Monitored Database Logs database objects, such as tables, indexes, rules, user-defined data types, defaults, database triggers & stored procedures (to implement complex business rules)

worked with the application support / development teams for database upgrades and releases

Improve database efficiency by continuously monitoring database performance bottlenecks and perform tuning when required

database support & problem resolution within virtualized and non-virtualized Windows 32-bit & 64-bit

Planning, implementation, and documentation of Microsoft SQL Server 2005/2008

environments

Deploy, maintain and test enhance all backup, failover, failback and disaster recovery capabilities of the databases as appropriate

Environment:SQL Server 2005,SQL Server 2000,SSIS,SSRS,DTS,SQL,profiler,system Monitor, Data Model ERWIN, SQL Trace, Transact SQL(T-SQL), Query Analyzer, Performance Monitor, Windows 2003, Microsoft Cluster Service (MSCS), MYSQL, Oracle 10g,UNIX Solaris,Red Hat Enterprise Linux,EMC,NETApp,Data guard, OEM monitoring, Partitioning, PL/SQL, RMAN, Data Warehouse concepts, Windows 32-bit & 64-bit OS.

Performance Monitoring Tool Used: Spotlight, IDERA,red-gate, Tivoli Monitoring, BMC patrol, Double take, Profiler, System Monitor

Company: Deutsche Bank (New York) (01/ 2005 -10/2007)

Position:Senior SQL Server DBA

Responsibilities:

Administrator all SQL Server Databases creation/Installation/configuration, backups, recovery/restore, automate jobs, performance tuning, etc.

Involved in advanced performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning, and coding standards

Involved in advanced performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning, and coding standards

Involved in advanced performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning, and coding standards

managing over 50 SQL Servers in multiple countries supporting several hundred users

Setup and maintain High Availability with Cluster

Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts

deploy, maintain and enhance all backup, failover and disaster recovery capabilities of the databases as appropriate

Prepare and set up environment for Disaster recovery (DR Server) with Standby by Server

Designed and implemented Replication,Log-shipping in SQL Server 2000

Provided analysis and recommendations for implementing full text indexing to meet management requirements

designing, documenting, and performing all Replication Agent test plans, test designs, test cases, and test summaries to consistently meet aggressive product release timeframes

SQL Server trouble shooting

worked for Sox compliance Auditing creating, testing, and reviewing

set and maintain Log-Shipping, Replication in SQL server 2000

take responsibility for database monitoring, troubleshooting, performance tuning and

the 7x24 availability of SQL Server databases

Optimized the code and database for maximum performance

Developed Backup and Recovery Procedures, Batch processing, Performance Monitoring, log maintenance and automating functions wherever possible

Perform capacity planning for OLTP and OLAP environments

implementation of physical database changes, performance tuning, capacity and architecture planning, index tuning, event and job monitoring

maintain database security (create and maintain users and roles, assign privileges)

Environment: SQL Server 2005/2000,DTS, SQL Profiler, system Monitor, Data Model ERWIN, SQL Trace, Transact SQL (T-SQL), Query Analyzer, Performance Monitor, Windows 2000 Microsoft Cluster Service (MSCS), MYSQL,LINUX

Contact this candidate