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
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
scvinodkumar said
Could you please guide me on MySQL Certification?
JShah said
Yes Sure
PB said
Great feat!!
Congratulations!!
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”
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…
Jugal Shah said
You can implement the virutal machines on your machine, do all the practice…
kabir said
great Achivement
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…..
srihari22187 said
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……
Jugal Shah said
Thanks SriHari.. Let me know what information you are looking for?
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.
Jugal Shah said
There is no specific version, most of the client use 2005 and 2008
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
DEV DUTT said
HI