Journey to SQL Authority with Pinal Dave

Solid Quality Mentor
Principal Database Architect, Developer, Administrator and Project Manager
Microsoft Most Valuable Professional (MVP – SQL). I am a Principal Database Architect / Developer and Project Manager specializing in SQL Server Programming with 7 years of rich, hands-on experience. I have been awarded Microsoft Most Valuable Professional (MVP) in SQL Server technology. I am also a Microsoft Certified Professional in MCP, MCDBA, and MCAD backed with a degree in Master of Science (Computer Networks). My expertise lies in programming logic, and I have exceptional analytical skills. I have also participated (as Key Speaker) in SQL Server user group meetings to enhance and share my knowledge. Moreover, I am a communicative enthusiastic team player and a dedicated individual who believes in sharing my valuable experience and knowledge with other technology enthusiasts.

Writing is another domain where I have done extensive and commendable work. A prolific technology writer, I have written over 1000 articles related to SQL Server technology. I am an avid blogger and I regularly write on a prominent technology blog http://blog.SQLAuthority.com. In addition, I am also a regular columnist for several prominent IT websites and magazines.

• SQL Server 2008, SQL Server 2005
• .NET C#
• ColdFusion MX
• Database Architecture
• Project Management

President - SQL Server User Group, Gandhinagar, India – Link
Leader – SQL Server User Group, Ahmedabad, India – Link
Member – Professional Association of SQL Server (PASS) – Link

Mentor - June 2009 till date
Solid Quality India Pvt. Ltd. Mumbai, India

• Subject Matter Expert (SME) – SQL Server and Business Intelligence.
• Delivered 100+ Hands-On-Lab (HOL) in different cities.
• Conducted Corporate training and workshop in leading IT Industries.
  (Send me email for client list and reference)
• Delivered numerous technical sessions all over the world in prominent technology conferences.
• Implemented End to End Business Intelligence (BI) stack solution.

Principle Database Architect – March 2009 till date
Digicorp Information Systems Pvt. Ltd. Ahmedabad, India

• 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.

Senior Project Manager – Nov 2008 to Feb 2009
Leading Healthcare Industry, 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.

Principal Database Administrator – Jul 2004 to Oct 2008
Leading Automotive Industry, Las Vegas, USA

• 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.

Teaching Assistant – Jun 2003 to Jun 2004
University of Southern California, Los Angeles, CA

• Trained and assisted over 100 students to execute class projects.
• Maintained a web-based database for graduate level course: Broadband Network Architecture.

Web Developer and Database Administrator – Feb 2002 to Jun 2004
University of Southern California, Los Angeles, CA

• Designed and implemented a relational database with a web interface.
• Created web based control panel.

SQLAuthority.com (Total over 1100 Articles)

• SQL SERVER – 2008 – Interview Questions and Answers Complete List Download (Link)
• SQL SERVER Database Coding Standards and Guidelines Complete List Download (Link)
• SQL SERVER – Download FAQ Sheet – SQL Server in One Page (Link)
• SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions , Triggers, Tables, Views, Constraints and All Other Database Objects (Link)
• SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL (Link)
• SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server ( Link)