Pinal Dave
Mentor
pdave@solidq.com
Pinal Dave is a Microsoft SQL Server MVP actively involved in community service in India through his technology blog and website SQLAuthority.com. He proficient Principal Database Architect, Developer, Administrator and Project Manager specializing in SQL Server Programming with over 7 years of hands-on experience. He holds a degree in Masters of Science (Computer Networks) and has accomplished a number of certifications including MCDBA and MCAD (.NET). He is an expert in SQL Server 2008 / SQL Server 2005 technologies. At present, he leads two user groups - Gandhinagar SQL Server User Group and Ahmedabad SQL Server User Group. He has also been awarded Regional Mentor for PASS Asia.
Since his time of working as a Teaching Assistant in the University of Southern California, Los Angeles, CA, teaching has been Pinal's expertise and passion. From then on, he pursued his teaching role and taught various students groups, corporates and technology organizations as well as spoke in several SQL Server events. A profuse writer, he has authored around 1200 SQL Server articles at SQLAuthority.com and is a regular columnist for several prominent IT websites and magazines. His Blog articles range from SQL Server 2005 technologies and SQL Server 2008 to Business Intelligence.
Technology Specialties
- SQL Server 2008/2005 Architecture, Design and Tuning
- Query Optimization and Server Tuning
- Database Health Analysis and Reporting
Professional Certifications
- MCDBA – Microsoft Certified Database Administrator
- MCAD – Microsoft Certified Application Developer
Professional Affiliations
Education
- Univercity of Southern California
Los Angeles, CA, USA – Masters of Science – Computer Networks
- Nirma Institutes of Technology - Gujarat Univercity
Ahmedabad, India – Bachelor of Engineering (Electronics & Communication)
Professional Experience
Digicorp Information Systems Pvt. Ltd. Ahmedabad, India
Digicorp is a leading and globally accepted IT service provider, offering a wide array of software services ranging from Healthcare Solutions to Smartphone Application Development, thereby incorporating a broad range of technologies. We believe in delivering finest outcome to our customers through a combination of process, quality frameworks and service delivery innovation, enabling them to achieve substantial differential advantage over their competitors.
- Designed and implemented complex database architecture; implemented strategies for database high availability and scalability
- Introduced strategic advancements in the query optimization and performance improvement
- Communicated and represented ideas through data model documentation and ensured that documentation was current
- Established standards for SQL installations, maintenance, tuning, and coding
- Lead in the development of our OLAP data warehouse reporting initiative
- Provided training, mentoring, and feedback to team members to enhance communication and performance
- Take ownership of current operational data structures and initiate optimizations and reconfigurations as warranted
- Envisioned and presented employees’ ideas on the concepts of technologies to management to enhance staff development and boost team spirit
Excellence Infonet Ahmedabad, India
- Designed and implemented complex database architecture
- Implemented strategies for database highly availability and scalability
- Provided leadership to employees for web site production
- Researched and implemented production methodologies and documented system
- Create bug tracking database and quality assurance systems to organize project assets, reduce time and locate assets
- Design systems to collect, organize, and display electronic correspondence to increase client satisfaction and management expectations
Leading Automobile Organization Las Vegas, USA
I was part of the organization, which is the leading provider of integrated Internet Marketing technology and services to the automotive marketplace. Our fully-integrated and automated solution makes it easy to consolidate your dealership’s separate Internet marketing systems into a single, more effective solution. Dealerships using our solution experience a dramatic, measurable increase in lead generation and sales.
- Responsible for logical and physical design for application and database tuning
- Major activities included advanced performance tuning, database design, and capacity planning
- Establishing standards for SQL installations, maintenance, tuning, and coding standards
- Architected and implemented large volume of Leads Management System
- Established Data Mining Algorithms to create Self Learning Automated System
- Designed Single Page Application and implemented Database Driven navigation
- Established and wrote Performance Tuning guidelines to enhance quality of product
- Redesigned a thorough backup and recovery strategy for all major production systems
- Upgraded all SQL Server 2000 to SQL Server 2005, without service interruption
- Effectively managed outsourcing team in India