Contact Me

Email Me:
jugal.shah@sqldbpool.com
SQL Server and MySQL Trainings
trainings@sqldbpool.com
Advertise With Us
advertisewithus@sqldbpool.com

Profile

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

• 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