[Pinal Dave]
Microsoft MVP - SQLResume
Pinalkumar Dave Database Administrator
Email : pinaldave "at" yahoo.com
Home Page: http://www.pinaldave.com
Blog Site: http://www.SQLAuthority.com
PINALKUMAR DAVE
Email : pinal "at" sqlauthority.com
Web-Site : http://www.pinaldave.com
Blog : http://blog.sqlauthority.com
PERSONAL PROFILE
Sr. Database Administrator / Developer and Project Manager.
Microsoft Most Valuable Professional (MVP - SQL).
I am Sr. Database Administrator / Developer and Project Manager specializing in SQL Server Programming with 5+ years of hands on experience. I am Microsoft Certified Professional (MCP, MCDBA, and MCAD) along with degree in Master of Science (Computer Networks). I have strong programming logic with zest to learn new technologies. I am communicative enthusiastic team player and dedicated individual.
I am also regular columnist in official magazine of SQL Server (http://sqlservermag.com). I regularly write on my personal technology blog (http://www.SQLAuthority.com) which contains over 600 articles related to SQL Server technology.
EDUCATIONAL QUALIFICATION
Master of Science (Computer Networks) – GPA 3.70
University of Southern California, Los Angeles. 2003
Bachelor of Engineering Electronics & Communication – GPA 3.65
Nirma Institutes of Technology, Gujarat University, India 2001.
Microsoft Certified Professional (MCP) – 2006
Microsoft Certified Database Administrator (MCDBA) – 2006
Microsoft Certified Application Developer (MCAD) – 2006
Macromedia Certified ADVANCED ColdFusion MX Developer – Feb 2005
SOFTWARE PROFICIENCY
Primary:
- SQL Server 2005
- ColdFusion MX
- Database Architecture
Secondary:
- MySQL
- .NET (C#)
- XML
- JavaScript
- CSS and HTML
PROFESSIONAL EXPERIENCE
Principal Database Administrator – Jan 2004 to Present
Software Outsourcing Manager – Nov 2007 to Present
(Company Name Protected*), Las Vegas, NV
- Responsible for logical and physical design with a significant effort towards application and database tuning.
- Major activities include advanced performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning, and coding standards.
- Converted page embedded SQL queries to secure and optimized Stored Procedure.
- Architected and implemented Leads Management System, which handles more than 15K Lead Emails/Day.
- Architected and implemented Vehicle Data System. Established and Implemented Data Mining Algorithms to create Self Learning Automated System which maintains itself without human interaction.
- Designed Ticket Tracking system for company intranet.
- Designed Single Page Application and implemented Database Driven navigation.
- Established and wrote Performance Tuning guidelines to enhance quality of our product for all current and future code development.
- Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts.
- Redesigned a thorough backup and recovery strategy for all major production systems.
- Upgraded all SQL Server 2000 to SQL Server 2005 without service interption.
- Effectively managed outsourcing team in India.
- Provided employee development, coaching and team building in addition to ensuring the implementation of optimized processes and procedures for rapidly producing software.
Web Developer and Database Administrator - Feb 2002 to Jun 2004
University of Southern California, Los Angeles, CA
- Designed and implemented a relational Admissions database with a web interface.
- Web Based Control Panel.
- Hand-coded websites using HTML, DHTML, XML/XSLT, and JavaScript.
- Developed code in a clean and consistent manner.
- Optimized images for the best download speed & cross-browser compatibility.
- Modified existing backend scripts and database.
- Communicated effectively with team managers.
- Followed specifications, guidelines and standards set by the department.
- Accurately estimated time on projects.
- Skills used: HTML, ASP, Java Script, VB.
Teaching Assistant - Jun 2003 to Jun 2004
University of Southern California, Los Angeles, CA
- Coached more than 100 students to complete class projects.
- I maintained a web based database for graduate level course Broadband Network Architecture.
Selected Publications
SQL Server Magazine
- SQL SERVER - UDF vs. Stored Procedures and Having vs. WHERE - (SQL Server Magazine October 2007)
- SQL SERVER - Sharpen Your Skills: Joins, Groupings, and Data Types - (SQL Server Magazine November 2007)
- SQL SERVER - Sharpen Your Skills: Brush up on FILLFACTOR, ISNULL, NULLIF, and % as wildcard and operator - (SQL Server Magazine December 2007)
- SQL SERVER - Sharpen Your Basic SQL Server Skills - Database backup demystified - (SQL Server Magazine February 2008)
Technical Papers
- "Location-centric Isolation of Misbehavior and Trust Routing in Energy-constrained Sensor Networks". IEEE Workshop on Energy-Efficient Wireless Communications and Networks (EWCN), April 2004, Phoenix, Arizona.
- "Secure Locations: Routing on Trust and Isolating Compromised Sensors in Location-aware Sensor Networks". ACM Sensys November 2003, Los Angeles. California.
- "Insecure Location Avoidance and Routing on Trust in Location-aware Sensor Networks". IEEE International Conference on Network Protocols (ICMP), November 2003, Atlanta, Georgia
SQLAuthority.com
- SQL Server Interview Questions and Answers Complete List Download (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)
