About Me


I’m a IT Manager and DBA

I’m a database professional and currently working as an Senior Manager Delivery for one of the largest SQL Server environment.

I have 12 years experience as DBA in SQL Server, MySQL and PostgreSQL. Working with the different databases and dealing with technology challenges is my passion. I love to share knowledge. Knowledge sharing is the best way to learn anything. I love to do programming whenever get a time. I have good knowledge in VB 6.0, .Net and Power Shell.

About Blog

This Blog is a place where I share my own personal thoughts, notes, opinions and experiences with databases. I believe we together learn the new things by sharing knowledge. I hope you all will enjoy reading this blog. If you do have any question please let me know, I will try my best to answer you.

Contact Me

Email Me:
jugal.shah@sqldbpool.com

My Profile

I have around 9 plus years of experience as Database Administrator which includes SQL Server 2000, SQL Server 2005, SQL Server 2008, MySQL and PostgreSQL.

Profile Summary

  • Expert in installing and configuring SQL Server instances on both stand-alone and failover cluster servers.
  • Advanced knowledge in Failover Clustering, Replication and Log shipping in SQL Server 2000, 2005 and 2008.
  • Good knowledge and experience in security procedures, SQL Server security and auditing procedures.
  • Experience in usage of performance monitoring and troubleshooting, extensive use of profiler, Performance monitor, extended stored procedure, DBCC and DMVs for troubleshooting the performance issues.
  • Extensive experience in support and maintenance of real time production databases.
  • Very good experience in planning and implementing Database backup and disaster recovery plan using native and SQL Lite Speed backups.
  • Experience in handling large tables using SQL Server table partitions.
  • Extensive experience in migrating and upgrading SQL Server from 7.0.to 2000, 2000 to 2005 and 2005 to 2008.
  • Experience in designing ELT process to extract data from other data sources like Oracle and Mainframe.
  • Extensive experience in design, development and administration of SQL Server databases.
  • Expert in handling, troubleshooting and providing quick and long-term solutions to production issues.
  • Good experience in installing and configuring SQL failover clusters in SQL Server 2005 and 2008. And has good experience in maintaining and troubleshooting Active-Passive and Active-Active clusters.
  • Patch management for development, staging and Production databases.
  • Managing multiple servers with different configurations.
  • Performance and Tuning of the SQL Server, databases and Procedures
  • Database Development (Database Design, T-SQL, Linked Server, DB Mail, SQL Mail, E-R diagram, CDC and new SQL Server 2008 features)
  • Implementation, Monitoring and Troubleshooting database HA Services( Replication, Mirroring, Log shipping and Backups/Restore)
  • Capacity Planning, Production Server Alerts setup.
  • Expertise and experience in implementing ITIL and Operation Maturity
  • Troubleshooting Windows and Linux Server
  • Implementation and Monitoring of Linux Clustering, Disk Replication, NAS server management
  • Database Report design using Microsoft Reporting Service, Crystal Reports and BIRT (open source)

My Certifications

34 thoughts on “About Me

  1. Dear sir

    i am very much happy and like to see your certifications in you blog spot . i also want to do MS SQL Server 2005 Administration certification can you guide me for that

    thanks
    swaraj

  2. “The uncertainties of the present always give way to the enchanted possibilities of the future. You are destined for greatness. Enjoy your journey”

  3. hello sir…
    I want to be a sql dba i have knowledge of t-sql stored procedures etc. but i have no any environment where i could make practise of these things and become a successful dba

    now a days i m in practise web developer with asp.net and c# sql server 2005 bt i want to be sql dba …

    please Suggest me…

  4. Hello sir,Awesom awards u got…
    i also want to be DBA bcoz i m interested in database…
    I m now in final year IT engg (2011-2012)from mumbai university..
    so plz suggest me what kind of knowledge is necessary4 dat…
    my email-id is:makkolhe12@gmail.com
    plz sir…….help me…..

  5. Hi Shah,
    I have eight years experience in windows system administration, now i plan to change my profile as SQL DBA, whats your opinion and from what version i need to start, currently what is the most used version between customer.

  6. Hello sir,i am shayna student of btech i want to get certified in oracle ocp bt rite now i want training in oracle.can i get training in oracle within 1 month ?

  7. hello sir,i m rajashri can u tell me which is the latest version of sql server 2005 or 2008.i m doing rdbms course from compufield institute at warden road mumbai there is a scope for institutions course. plz guide me this is my email id
    thank u.

  8. Hello Jugal, Im from Canada but completly Non-IT background. I started my little step by doing a course in Software Testing and got certified from ISTQB. I want to become DBA or atleast i think that..!!! I need a mentor who could guide me through the path. Would you like to be my Mentor..?? Please guide me through the path of DBA..!!

    Thanks
    DR

  9. Hi Sir

    can please suggests good books ,to get guidence while practicing below tasks as you mentioned in your PPT.
    -performance and tuning
    -Backup and restore
    -Maintenance plan
    -HA Setup
    -DBCC
    -Bloking/Deadlock
    -capacity planning
    -SQL profiler
    -DTA
    -SQL Configuration
    -Best practice
    -security setup
    -Database Design

  10. Hi Jugal Shah
    I am having 3 years in sql sever DBA in on one organization for my environment we have to configure power shell script for below mentioned things:

    Please configure powershell scripting and email notification for monitoring below.

    1. SQL Server services running in PROD instances
    2. Mirroring status on these instances.
    3. Backup status on all instances.

    Note :output should be in html format.and email notification.

    can you help on this please.

  11. HI JUGAL ,
    CAN U PLEASE TELL ME ABOUT JOB FAILURE ISSUES\

    FOR EXAMPLE JOB WAS INVOKED BY USER
    JOB WAS INVOKED BY SCHEDULE LIKE KIND OF ISSUES CAN U PLEASE INFORMATION ABOUT IT WILL BE HELPFUL TO ME…

  12. Sir, I am working on MIS with Excel and MySQL .. My hobby is to work on data.. So please suggest me for DBA. I have done 6 months traing in .net as well but still not using.
    Kindly suggest..
    Regards,
    Shiv

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s