Sql Server Manager
Resume:
Mahesh Gupta
Architect Consultant Blogger Specialist for Microsoft SQL Server Database
Administrator SQL Azure SharePoint DBA
Location
Dallas/Fort Worth Area
Industry
Computer Software
.
Mahesh Gupta
Contact Mahesh Gupta directly
Mahesh Gupta's Overview
Current
Database Consultant, SQL DBA, Administrator, Architect, Mentor, Advisor, Pre Sales
Specialist, SME at IT Company
Founder Blogger Database Consultant Microsoft SQL Server SME SQL DBA Trainer at
sqlServer-Training.com (Sole Proprietorship)
Microsoft SQL Server Database Consultant Administrator, Microsoft Certified Database
Administrator at Microsoft SQL Server Certified
Past
Database Manager Delivery, Pre Sales Consultant, SQL DBA,
Administrator, Architect, SME,
Specialist at Dell Services (Formerly known as Perot Systems
)
Pre Sales Consultant, SME,
Delivery Manager, SQL DBA,
Administrator, Architect, Database
Specialist at Dell Services (Formerly known as Perot Systems
)
Database Administrator, SQL DBA, Technical Solution Architect, Consultant, SME,
Specialist, Manager at ibibo Web Pvt. Ltd
.
Database Consultant, SQL DBA,
Administrator, Architect, Advisor, Pre Sales Specialist,
SME, Manager at Dell (Formerly known as Perot Systems
)
Specialist, SQL DBA,
Database Administrator, Delivery Consultant, Architect, Advisor,
SME, Manager at Citibank - Citigroup Inc
.
Associate Manager, SQL DBA,
System Administrator, Database Consultant, Architect, SME,
Specialist at BCH Electric LTD,
Faridabad
Database Consultant, SQL DBA,
Administrator, Architect, Delivery Manager, Advisor,
Specialist, SME at HCL Technologies
SQL Server DBA, Developer, Database Administrator, Technical Consultant, SQLDBA,
Advisor,Specialist at NIIT Limited
MSSQL DBA, Microsoft sql server Database consultant, Microsoft SQL DBA Trainer Mentor
at www.CallDBA.com
see less
see all
Education
National Institute of Information Technology
Sikkim Manipal University of Health, Medical and Technological Sciences
Additional Courses Completed
Recommendations
4 people have recommended Mahesh
Connections
500+ connections
Websites
SQL DB Consultant complex updt
SQL Server Administrator QA
My Blog - Database Tutorial
Mahesh Gupta's Summary
Trained, certified and experienced with SQL Server. Having 12+ years experience in
Microsoft SQL Server Database Administration, Designing & Implementing Solutions on SQL
Server 2012, 2008, 2005, 2000, 7.0, 6.5 versions; databases ranging from GBs to TBs in
size.
Contacts:
Phone : +1 (260) CALL DBA
Email : ******@******.**
Google+ : http://tiny.cc/dbatag
Twitter : @SQL_ServerDBA
Education / Certifications
Masters in Computer Applications; MCA (Database Management)
Project Management Professional (PMP Certified) since 2009
ITIL V3 Foundation Certified
Quality Management Certification
MCITP Database Administrator, Database Developer, Business Intelligence Developer
MS Certified Database Administrator (MCDBA) SQL DBA
MS Certified System Engineer (MCSE)
Oracle Certified Professional (OCP)
Community Achievements
Written 1000+ Articles on Microsoft SQL Server
Develop 50+ Video Tutorials and Presentations on SQL Server which has more than 100+
thousand views
Strong Twitter followers (12,000+) for SQL News & Updates (@SQL_ServerDBA)
Massive Facebook Page FANs (14,000+) for SQL News and Updates
4000+ daily users on my blog
Expertise
Database Administration (DBA) for Microsoft SQL Server 201*-****-**** 2000 7.0
for VLDB Environment
SQL Server Consolidation & Virtualization
Production Database Support & Troubleshooting (24*7*365)
Performance Tuning Query Tuning
Finding & Tuning SQL Server hardware Bottlenecks
Business Continuity Planning & DR Setup
SQL Clustering (Installation/Maintenance)
SQL Replication, Log Shipping, Mirroring, HADR, AlwaysON
SQL Version upgrade
Server migration
Maintaining managing Business Intelligence, Data Warehousing solutions for large
enterprises.
Workd as SQL DBA, Database Consultant, Solutions Architect, Pre Sales Specialist,
Database Service Delivery Manager, SQL Server Specialist Advisor in past.
Mahesh Gupta's Experience
Database Consultant, SQL DBA, Administrator, Architect, Mentor, Advisor, Pre Sales
Specialist, SME
IT Company
April 2011 Present (1 year 6 months) Dallas/Fort Worth AreaSQL DBA
===
[24*7*365] Production Support as SQL DBA
Implementing and Maintaining Log Shipping Database Clustering Mirroring Always
On HADR
SQL Server Virtualization & Consolidation
Installation, Version Upgrade & Architect Setup
SQL Server Hardening & Best Practice Implementation
Capacity Planning, Load Balancing & Scaling out SQL Services
Design and Implement Database Backup Restore & Disaster Recovery Strategy
Hardware sizing, Setting up Base lining and Capacity Planning
Auditing SQL Server Security
Plan, Design and Scheduled Database Maintenance & Administrative Tasks
SQL Server Database Monitoring with DDL Triggers SQL Server Profiler Event
Notifications
Troubleshooting SQL Server
Schedule SQL Jobs SQL Server across multiple Servers
Performance Tuning, Execution plan, Profiler, Perfmon, Extended Events, Data Collector
and Resource Governor
Install multinode multisite clusters
Enterprise Policy Management / Centralized Management
Data Quality and Master Data Service Design and Implementation
OLAP
===
Installing & Configure Analysis Services on clustered environment
Cube Deployment
Syncronizing OLAP Databases
Logging, Monitoring and Optimizing Analysis Services Solution
Backing Up and Restoring an OLAP Database
SSRS
===
Installing and Configuring Reporting Services on Clustered Environment for High
Availibility
Publishing / Depoying Report on multiple Report Servers
Managing Shared Data sources and permissions
Configured Reports Snapshots, Report Caching for reporting performence
Created and managed subscriptions for Reports
Assigning report level permissions to Secure business information
upgraded / Migrated SQL Server reporting services
Configure Backups for Reporting Services
SSIS
===
Installing and Configuring Integration Services on Clustered Environment for High
Availibility
Troubleshooting and Optimising SSIS package performence
Deployed and Scheduled DTS SSIS Packages
Founder Blogger Database Consultant Microsoft SQL Server SME SQL DBA Trainer
sqlServer-Training.com (Sole Proprietorship)
Public Company; Myself Only; Computer Software industry
May 2010 Present (2 years 5 months) Dallas/Fort Worth Area
As I did my Masters in Computer Applications with 12+ years of corporate experience, I
founded my blog with a mission to help DBA's, Developers, Industry Experts, small
corporations, groups, individuals and professionals on various issues, based on my
education and personal/professional experiences which I earned working as SQL Server
Database Consultant SQL DBA
My expertise ranges a variety of subjects, but primarily focused on: Database management
systems
To achieve this objective, I founded my personal blog / website www.sqlServer-
Training.com, one of the popular website on the Internet devoted to SQL Server performance
tuning, troubleshooting, Training and Tutorials for SQL Server DBA's
This blog has also helped me in learning lot of other skills
Professional networking & social media (i.e. Linkedin, Twitter, Facebook) and power of
Social Media
Computer / IT use for business & development purposes
Cloud Computing - IAAS / PAAS / SAAS
Search Engine Optimisation
Technolgy for better life, SMART TV, TABLET etc beyond Windows :)
College/career/life mentoring & coaching
Other Database technologies like NO SQL DB etc.
Strategic management for business prospective
Recruiting
Business / Risk Advisory
Start-up and Entrepreneurship
Fundraiser & Fund Management
Preserving Human capital
Training ROI
Subject Matter Expert
More Skills required as Microsoft SQL Server Database Consultant & SQL DBA
Technologies SSAS, SSRS, SSIS, SQL Server Database Management
Microsoft SQL Server Database Services
Microsoft SQL Server Analysis Services - SSAS
Microsoft SQL Server Reporting Services - SSRS
Microsoft SQL Server Intergration Services - SSIS
SQL Server Consolidation & Virtualization Virtual VMWare Hyper-V
Cloud Services, SQL Server Azure, Windows AZUREDetailed Technical Profile : http://bit.ly/ME6CvO
Microsoft SQL Server Database Consultant Administrator, Microsoft Certified Database
Administrator
Microsoft SQL Server Certified
Public Company; 10,001+ employees; MSFT; Computer Software industry
December 2001 Present (10 years 10 months)
Certified Microsoft SQL Server Certified Database Administrator and hold Certifications
like MCDBA, MCSE, MCTS, MCITP, MCSA since 2001 and upgrading continuously.
Database Manager Delivery, Pre Sales Consultant, SQL DBA,
Administrator, Architect, SME,
SpecialistDell Services (Formerly known as Perot Systems)
Public Company; 10,001+ employees; DELL; Information Technology and Services industry
August 2008March 2011 (2 years 8 months) Noida Area, India
As a Database Delivery Manager, my key role is to lead the Database team in the delivery
of high quality business services to the various business customers. With this role I have
been responsible for:
Role and Responsibilities includes:
Continue to institutionalize maintenance and implementation processes that are
effective, efficient, and supported by visible metrics.
Managing Database team that maintain / manage various applications Databases and
supporting tools across platform
Establish and manage relationships with customer subject matter experts and appropriate
customer management, with an objective of maintaining and building the business.
Monitor and ensure organizational goals and contractual commitments are met (e.g.
budget/cost, service availability, responses, reports).
Develop and execute an appropriate delivery team model (e.g., resources, skills) to
meet current and projected needs/constraints
Build strong analytical and problem solving skills in team
Manage the deployments, data / environment cloning, data refreshes, patching, backups,
archieving, purges, etc.
Resolve/monitor customer escalations as appropriate
Established COE and senior Consultant for other SQL DBA's
Technologies SSAS, SSRS, SSIS, Database Management
Microsoft SQL Server Database Services (SQL DBA)
Microsoft SQL Server Analysis Services - SSAS
Microsoft SQL Server Reporting Services - SSRS
Microsoft SQL Server Intergration Services - SSIS
SQL Server Consolidation & Virtualization Virtual VMWare Hyper-V
Cloud Services, SQL Server Azure, Windows AZURE
Pre Sales Consultant, SME, Delivery Manager, SQL DBA, Administrator, Architect, Database
SpecialistDell Services (Formerly known as Perot Systems)
Public Company; 10,001+ employees; DELL; Information Technology and Services industry
January 2008July 2009 (1 year 7 months) Noida Area, India
As a member of the Pre-Sales Consulting team, I was having a key role as a technical
liaison between sales representatives and prospective customers to articulate the
technical and business value the database solution.
Role includes:
Provide technical pre-sales support to prospective customers.
Present and demonstrate database solutions at customer sites and/or via the internet,
presentations may include white board sessions, architecture overviews, product
walkthroughs, and proof of concepts
Interact with prospective customers to solve very specific problems affecting their
database environment and assisting sales teams in selling solutions
Remain very hands-on by using a mix of your database architecture expertise and
platform related knowledge to solve complex problems in enterprise production environments
Provide necessary input into RFI s and RFP s.
Understand the dependencies on other Microsoft and 3rd party software components to
develop complete solutions for customers.
Worked with Microsoft SQL Server Product Management teams to provide feedback on
current and future product requirements
Helped Customers to identify market and product requirements based on field experience
and market trends
Covering technical aspect of RFP / proposals.
Production Support & On Call Support for multiple customers as SQL DBA
Designing Delivery Manager Deliverable for Database Service
Technical Specialty
Microsoft SQL Server Database Services (SQL DBA)
Microsoft SQL Server Analysis Services - SSAS
Microsoft SQL Server Reporting Services - SSRS
Microsoft SQL Server Intergration Services - SSIS
SQL Server Consolidation & Virtualization
Virtual VMWare Hyper-V
Cloud Services, SQL Server Azure, Windows AZURE
Database Administrator, SQL DBA, Technical Solution Architect, Consultant, SME,
Specialist, Manager
ibibo Web Pvt. Ltd.
Privately Held; 201-500 employees; Internet industry
April 2007 January 2008 (10 months) Gurgaon, India
QQ.com is one of the top 10 websites in the world currently at rank 7 in world.and No. 2
in China, getting more web traffic / hits than Linkedin.com and Amazon.com The same
company (Tencent, Inc / Naspers) started operation in India as IBIBO Web Pvt Ltd with
portal www.ibibo.com
www.ibibo.com is currenly ranked in top 100 sites in India and has Payu.in gaadi.com
tradus.in ibibo.com goibibo.com in portfolio
Currently the entire portfollio get millions of daily unique visitors and maintaining
high response and data security is a challenge.
I accepted and delivered this role successfully as One man army for Database solutions.
As a Database Administrator, my key role ensure the continous availability of Database
Services by increasing efficiency, availability, productivity and security for Business
information.
Responsibilities:
Ensures business continuity by developing database recovery plans, procedures and
implementing high availability for all mission critical database
Drives continuous database improvement initiatives to increase efficiency,
availability, productivity and security
Design database solutions to satisfy application (business and technical) requirements
Provide written status reports to management regarding project status, task, and
issues/risks
Approve, schedule, plan, and supervise the installation and testing of new products and
improvements to computer systems, such as the installation of new databases.
Train Developers to build the logical database area and provide technical guidance for
Optimisation during all phases of the development process
Design and document database architecture - Data Modeling
Develop custome utilities to automate recurring operational activities
Database Consultant, SQL DBA, Administrator, Architect, Advisor, Pre Sales Specialist,
SME, Manager
Dell (Formerly known as Perot Systems)
Public Company; 10,001+ employees; DELL; Information Technology and Services industry
September 2005 March 2007 (1 year 7 months) Noida Area, India
Dell Services formally known as Perot Systems offers Infrastructure Support to various
customers.
As part of Infrastructure Support Team, having a responsibility of implementing all
stages of infrastructure / maintenance projects, starting from
- Requirements gathering
- Scoping Services engagement
- Hands-on delivery
- Transition / Implementation
- Documentation
- Transferring support to Operations
- Training and finally mentoring.
Technical Implementions
Production Database Support & Troubleshooting (24*7*365)
SQL Clustering (Installation/Maintenance)
SQL Server Replication, Log Shipping DB Mirroring, AlwaysON (HADR)
SQL Server Virtualization & Consolidation
SQL Server Business Intelligence OLAP
SQL Server Integration Services (SSIS)
Architect Design, Install, Upgrade SQL Server
Team Management, Client interaction, Consulting & Reporting.
Scaling out SQL Server
Migrating DTS Packages to SSIS
SQL Server Installation, Version Upgrade & Architect Setup
Best Practice Implementation & Server Hardening - Data Security
Database Archiving / Partitioning (Horizontal / Vertical)
SQL Server Load Balancing
Solution Architect Design / Implementation
Setting up Base lining and Capacity Planning
SQL Server Hardware sizing and bottleneck tuning
Setting High/Mid/Low level SQL monitoring - Preventive alerts
Enterprise Policy Management / Centralized Management
Performance Tuning Execution plan, Profiler, Perfmon, Extended Events and Resource
Governor
Data Quality and Master Data Service Design and Implementation
People Training
MS SQL 2012 / 2008 / 2005 / 2000 / 7.0 DBA on VLDB Environment
Finding & Tuning SQL Server hardware Bottlenecks
Business Continuity planning and Disaster Recovery Implementation
Server migrations
T-SQL Development, Data Mining, Report creation
Security Audit, Stress Testing
Indexing rebuilding Strategies for VLDB
SQL Server Backup/Restore & Disaster Recovery & DR Mock testing
Specialist, SQL DBA,
Database Administrator, Delivery Consultant, Architect, Advisor,
SME, ManagerCitibank - Citigroup Inc.
Public Company; 10,001+ employees; C; Financial Services industry
April 2005August 2005 (5 months) Chennai Area, India
Supporting SQL Server for Financial / Insurance products.
DBA
SQL Server DBA Production Support - Finance Domain [24*7*365]
Design and Implement Database Backup Restore Strategy
Auditing SQL Server Security
Data Transfer / Transformation
Plan Database Maintenance & Administrative Tasks
Configuring Replication / Data Syncronization
Implementing and Maintaining Log Shipping Database Clustering
Monitoring with DDL Triggers SQL Server Profiler Event Notifications
Troubleshooting SQL Server
Schedule SQL Jobs SQL Server across multiple Servers
Tuning SQL Server Performance
OLAP
Installing & Configuring SQL Server Analysis Services on clustered environment
Memeory Management for SQL Server Analysis Services
Cube Deployment using BIDS, deployment wizard, XLMA Script
Syncronizing OLAP Databases
Database Backup Restore Strategy design and Implementaion for OLAP Databases
Logging, Monitoring, and Optimizing an Analysis Services Solution
Backing Up and Restoring an Analysis Services Database (OLAP)
SSRS
Installing and Configuring Reporting Services on Clustered Environment for High
Availibility
Created basic Reports to meet adhoc business requirement
Publishing / Depoying Report on multiple Report Servers
Managing Shared Data sources and permissions
Configured Reports Snapshots, Report Caching for reporting performence
Created and managed subscriptions for Reports
Assigning report level permissions to Secure business information
upgraded / Migrated SQL Server reporting services
Creating Subscription for Reports
Configure Backups for Reporting Services
SSIS
Installing and Configuring Integration Services on Clustered Environment for High
Availibility
Troubleshooting and Optimising SSIS package performence
Deployed and Scheduled DTS SSIS Packages
Associate Manager, SQL DBA, System Administrator, Database Consultant, Architect, SME,
SpecialistBCH Electric LTD, Faridabad
Privately Held; 501-1000 employees; Machinery industry
September 2003April 2005 (1 year 8 months) Faridabad Area, India
Worked with BCH Electric LTD as Associate Manager and Database Consultant to support SAP
implementation. Managed System / Operations team.
As Database specialist:
Setting Server & Storage hardware benchmarking for new DB Servers & Projects.
New Setup/Installation or database server migration & High availability Setup
Setting High/Mid/Low level SQL monitoring
Defining guidelines & implementing Microsoft SQL Server best practices
SQL Installation, Upgrade, Maintenance & Architect
Backup/Restore & Disaster Recovery Setup
Performance Tuning, Stress Testing & Capacity Planning
Interacting Microsoft Database consultant for any PSSdiag PSS diag issues and first
point of Contact for Microsoft Database consultant for any logged issue / Case.
Production database support for SQL 7.0; 2000;
As Associate Manager:
Defining Support SLA
Monitoring operational support SLA's / OLA's
Review of Associate Performance
Department Budgeting
Managing Inhouse IT Support and remote locations
Upgraded the entire system from legacy system to Windows 2000 environment
Database Consultant, SQL DBA,
Administrator, Architect, Delivery Manager, Advisor,
Specialist, SME
HCL Technologies
Public Company; 10,001+ employees; 532281; Information Technology and Services industry
January 2003August 2003 (8 months) Noida Area, India
Hired by HCL as Microsoft SQL Server Database Consultant to support implementation for
one of their customer EASYBILL ( http://www.easybillindia.com/), pioneer in financial
transaction processing for Bill payment and Ticketing Solution in India.
Microsoft SQL Server Database Monitoring & Daily production DBA Tasks (24*7*365)
T-SQL Development, Data Mining, Report creation
Monitoring Microsoft SQL Server performance
Microsoft SQL Server Query optimization and performance tuning
Business Continuity planning and Disaster Recovery Implementation
Security Audit, Stress Testing & Capacity planning
Microsoft SQL Server Replication
Backup and Restoration / Maintenance of Databases.
SQL Server DBA, Developer, Database Administrator, Technical Consultant, SQLDBA,
Advisor,Specialist
NIIT Limited
Public Company; 5001-10,000 employees; Education Management industry
April 2000 December 2002 (2 years 9 months) New Delhi Area, India
Provided key support Services for one of in house project named eNCORE, student
Management system helps clients at more than 2000 centers worldwide manage student
administration with greater ease and efficiency. eNCORE is an integrated application that
provides data synchronization across centers and manages administrative data related to
students.
Creating Databases, Schemas
Planning, creating and Optimizing Indexes in SQL Server
Implementing Data Integrity by Using Constraints and Triggers
Creating, Managing & Optimizing Performance for Views, Procedure, Triggers, CLR
Objects, Table, Functions
Query Performance Optimisation - Execution Plans, Exception Handling
Optimizing distributed Transactions and Locks
Migration data from foxproto SQL Server
Database Administration
Replication
Query Tuning
Live data processing
Performing Maintenance for Database Servers
Data Modeling, Database Schema development including table, Index, stored procedures,
functions creations for Database Systems.
Consolidating and merging data
Optimizing distributed Transactions and Locks
MSSQL DBA, Microsoft sql server Database consultant, Microsoft SQL DBA Trainer Mentor
www.CallDBA.com
April 2000 May 2002 (2 years 2 months)
Microsoft sql Database consultant, MSSQL, SQLDBA, Microsoft sql server Database
consultant, Microsoft sql DBA
Mahesh Gupta's Languages
English
Hindi
Mahesh Gupta's Publications
SQL Server Tutorials, Articles & Videos
www.sqlServer-Training.com
May 18, 2010
Authors: Mahesh Gupta
Being a technical Blogger, written 1000+ articles on SQL Server Database Technologies for
HOW TO, TIPS, Tricks, Scripts and Operational support @ http://www.sqlserver-training.com/
Mahesh Gupta's Skills & Expertise
Microsoft SQL Server
Database Administration
SQL Clustering
SQL Server Consolidation
Database Consolidation
Performance Tuning
SQL Replication
Log Shipping
database mirroring
AlwaysON HADR
SQL Server Virtualization
Disaster Recovery
Database Design
Query Writing
Query Optimization
Database Server migration
Technical Writing
Database Log Shipping
SQL Injection
Project Management
Server Optimisation
Database SAN Management
Trainer
SSIS
SSRS
SSAS 2008
SQL Server Management Studio
SQL Azure
Database Scripting
HADR
Solution Implementation
Replication
High Availability
Data Warehousing
vldb
SQL Tuning
T-SQL
Cluster
Stored Procedures
Data Modeling
Analysis Services
Database Admin
Cloud Computing
SharePoint
Databases
ETL
Oracle
Business Intelligence
Data Mining
View All (49) Skills View Fewer Skills
Mahesh Gupta's Certifications
Project Management Professional
PMI
February 2009
Microsoft Certified Professional
Microsoft SQL Server
October 2001
Microsoft Certified Database Administrator (MCDBA)
Microsoft
December 2001
Microsoft Certified Systems Engineer
Mcirosoft
December 2001
Microsoft Certified Technology Specialist - SQL Server 2005
Mcirosoft
October 2007
Microsoft Certified Technology Specialist - SQL Server 2008
Mcirosoft
November 2009
Microsoft Certified IT Professional - Database Developer
Mcirosoft
December 2008
Microsoft Certified IT Professional - Database Administrator
Microsoft
October 2007
Microsoft Certified IT Professional - Database Administrator 2008
Microsoft
November 2009
Mahesh Gupta's Education
National Institute of Information Technology
GNIIT
Sikkim Manipal University of Health, Medical and Technological Sciences
Masters in Computer Application, Database Management Systems
Additional Courses Completed
Information TechnologyMS-DOS 6.2 & Windows for Support Professionals
Microsoft Excel Beginner & Intermediate
Microsoft Word Beginner & Intermediate
Microsoft Powerpoint Beginner & Intermediate
Microsoft Project Beginners course
Personal Computer Architecture
Macintosh System Support
Microsoft Windows 95 Advanced course
Microsoft Windows NT 3.51 & 4.0 Server
Microsoft Mail 3.5
TCP/IP
Microsoft Remote Access & Routing
Microsoft SQL Server 6.5, 7.0, 2000, 2005, 2008, 2012
Microsoft Internet Information Server 3.0 & Index Server
Object Oriented Analysis and Design with UML, Patterns and the Unified Process
Mahesh Gupta's Additional Information
Websites:
SQL DB Consultant complex updt
SQL Server Administrator QA
My Blog - Database Tutorial
Interests:
I have a large variety of interests, from technology to science, from photography to
travels. The list is never ending, as life goes, these keeps changing. But I am more
interested in New Technology Ways to make life simple Technology early adopter
Investment Can be contacted @ Email : ******@******.**
Contact Mahesh for:
Contact this candidate