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
I am Sr. Database Administrator / Developer and Project Manager specializing in SQL Server Programming with 6+ years of hands on experience. I am also awarded Microsoft Most Valuable Professional (MVP) for SQL Server technology. 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 regularly write on prominent technology blog (http://www.SQLAuthority.com) and have written over 700 articles related to SQL Server technology. I am also regular columnist in official magazine of SQL Server (http://sqlservermag.com).
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
- SQL Server 2008, SQL Server 2005
- .NET (C#)
- ColdFusion MX
- Database Architecture
- JavaScript
PROFESSIONAL EXPERIENCE
Principal Database Administrator (Las Vegas, USA) – Jan 2004 to Nov 2007
Software Outsourcing Manager (Ahmedabad, India) – Nov 2007 to Present
(In India I work for same US company’s Outsourcing Location)
- Responsible for logical and physical design towards application and database tuning.
- Major activities include advanced performance tuning, database design, capacity planning.
- Establishing standards for SQL installations, maintenance, tuning, and coding standards.
- Converted page embedded SQL queries to secure and optimized Stored Procedure.
- Architected and implemented Large volume 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 our product for .
- Maintain performance of databases using advanced tuning methods and 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 interruption.
- 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.
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.
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.
SELECTED PUBLICATIONS
SQLAuthority.com
- 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)
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
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)
pinaldave
