About Jugal

Email Me:
jugal.shah@sqldbpool.com
Chat
jshah.sqldbpool@gmail.com

Profile

Jugal has around 8 plus years of experience as Database Administrator which includes SQL Server 2000, SQL Server 2005, SQL Server 2008 and MySQL.

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)
  • Imparted the SQL Server, MySQL and Crystal report trainings

My Certifications

9 Responses to About Jugal

  1. swarajsaini says:

    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. scvinodkumar says:

    Could you please guide me on MySQL Certification?

    • JShah says:

      Yes Sure

  3. PB says:

    Great feat!! :)

    Congratulations!!

  4. Sachin Ohal says:

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

  5. bhanu says:

    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…

    • Jugal Shah says:

      You can implement the virutal machines on your machine, do all the practice…

  6. kabir says:

    great Achivement

  7. Mahesh kolhe says:

    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…..

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 )

Connecting to %s