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