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

15 Responses to “About Jugal”

  1. swarajsaini said

    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. Could you please guide me on MySQL Certification?

  3. PB said

    Great feat!! :)

    Congratulations!!

  4. Sachin Ohal said

    “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 said

    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…

  6. kabir said

    great Achivement

  7. Mahesh kolhe said

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

  8. Hi sir,
    Great position you are, and i also be like you, please gude and help me.
    srihari22187@gmail.com-This is my mail iD.

    Pls……

  9. Krish said

    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.

  10. DEV DUTT said

    Hi Shah jee,

    It is very good and helpful material to everyboy related to database.Sir,
    can you send me the related book’s name which are useful to become a DBA.

    Thanks
    DEV DUTT
    9899489304
    Emailid——devjnv2007@gmail.com

  11. DEV DUTT said

    HI

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

 
Follow

Get every new post delivered to your Inbox.

Join 174 other followers