Mahesh Gupta – SQL Server Consultant

Leave a comment (0) Go to comments


Mahesh Gupta   SQL Server Consultant Mahesh Gupta dbatag AUTHOR

This is Mahesh Gupta, DBATAG (virtual preferred name) .  I am trained, certified and experienced with SQL Server and all the technologies required to maintain a high performance, secure and reliable database environment for your company.

Having 12+ years’ experience in Microsoft SQL Server Database Administration, Designing & Implementing Solutions and Training people on SQL Server 2012, 2008, 2005, 2000, 7.0, 6.5 versions; databases ranging from GBs to TBs in size.

Education / Certifications
======================
• Done my Masters (Degree) in Computer Applications; MCA (Database Management)
• Project Management Professional (PMP Certified) since 2009
• ITIL V3 Foundation Certified
• Quality Management Certification
• MS Certified IT Professional (MCITP-Database Administrator) – SQL Server 2008
• MS Certified IT Professional (MCITP-Database Developer) – SQL Server 2008
• MS Certified IT Professional (MCITP-Business Intelligence Developer)
• MS Certified IT Professional (MCITP-Database Administrator)
• MS Certified IT Professional (MCITP-Database Developer)
• MS Certified Database Administrator (MCDBA)
• MS Certified System Engineer (MCSE)
• Oracle Certified Professional (OCP)

Specialties
=========

• MS SQL 2012 / 2008 / 2005 / 2000 / 7.0 DBA on VLDB Environment
• SQL Server Consolidation & Virtualization
• Production Database Support & Troubleshooting (24*7*365)
• Performance tuning SQL profiler, Query Execution plan
• 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

Worked extensively on following  technologies / component as Database Consultant for various Clients to meet various project requirement:

DBA
=====
• MS SQL 2012 / 2008 / 2005 / 2000 / 7.0 DBA on VLDB Environment
• SQL Server Consolidation & Virtualization
• Performance tuning SQL profiler, Query Execution plan
• 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
• SQL Server DBA, Database Production Support [24*7*365]
• Design and Implement Database Backup Restore Strategy
• Auditing SQL Server Security
• Setting up Base lining and Capacity Planning
• Data Transfer / Transformation
• Plan Database Maintenance & Administrative Tasks
• Configuring Replication / Data Syncronization
• Implementing and Maintaining Log Shipping | Database| Clustering | Mirroring | Always On HADR
• SQL Server Database Monitoring – Preventive alerts
• Monitoring with DDL Triggers | SQL Server Profiler | Event Notifications
• Troubleshooting SQL Server
• Schedule SQL Jobs | SQL Server across multiple Servers
• Tuning SQL Server Performance Execution plan, Profiler, Perfmon, Extended Events, Data Collector and Resource Governor
• Disaster Recovery
• Install multinode multisite SQL Server clusters
• SQL Server Setup, Upgrade & Architect Setup
• Scaling out SQL Server
• SQL Server Installation, Version Upgrade & Architect Setup
• SQL Server Hardening | Best Practice Implementation
• Database Archiving / Partitioning (Horizontal / Vertical)
• SQL Server Load Balancing
• Solution Architect Design / Implementation
• SQL Server Hardware sizing and bottleneck tuning
• Backup/Restore & Disaster Recovery Setup
• Enterprise Policy Management / Centralized Management
• Data Quality and Master Data Service Design and Implementation
• Train and Educate Developers / DBA’s

DEV
====
• Creating Databases, Schemas, Snapshots
• Planning, creating and Optimizing Indexes in SQL Server
• Implementing Data Integrity by Using Constraints and Triggers
• Creating, Implementing XML Schemas, Indexes
• creating, Retrieving and Shredding XML Data | XQuery
• Creating, Managing & Optimizing Performance for Views, Procedure, Triggers, CLR Objects, Table, Functions
• Query Performance Optimisation – Execution Plans, Exception Handling
• Creating Service Broker Object, Sending and Receiving Messages
• Optimizing distributed Transactions and Locks

OLAP / SSAS
==========
• Installing & Configuring SQL Server Analysis Services on clustered environment
• Memeory Management | Resource 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 SQL Server 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
• Scaling out SQL Server Reporting Services

SSIS
=====
• Installing and Configuring SQL Server Integration Services on Clustered Environment for High Availibility
• Troubleshooting and Optimising SSIS package performence
• Migrating DTS Packages to SSIS
• Deployed and Scheduled DTS | SSIS Packages

 

If your business runs on a SQL Server database and you are looking Database Consultant for some special, highly demanding & critical database project(s), I think you will find that we are the people you’re looking for.

Contacts:
========
Phone: +1 (260) CALL DBA, +1 (260)225 5322
Email : dbatag@gmail.com
Google+ : http://plus.google.com/100154917288283086959
Facebook : http://www.facebook.com/sqlServerTraining
Twitter: @dbatag

EOF - Mahesh Gupta – SQL Server Consultant, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.