I’m a IT Consultant and DBA
I’m a database professional and currently working as an Manager Delivery for one of the largest SQL Server environment.
I have 9 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 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 and in .Net.
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
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
Could you please guide me on MySQL Certification?
Yes Sure
Great feat!!
Congratulations!!
“The uncertainties of the present always give way to the enchanted possibilities of the future. You are destined for greatness. Enjoy your journey”
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…
You can implement the virutal machines on your machine, do all the practice…
great Achivement
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…..
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……
Thanks SriHari.. Let me know what information you are looking for?
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.
There is no specific version, most of the client use 2005 and 2008
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
HI
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 ?
You have check for the institutes near by your location.
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.
it is SQL Server 2012
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
write your queries, i will guide you.
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