KINNARY K PATEL
**** ***** *** ** ***#D-*** Bellevue WA-98007 Cell 732-***-**** Email: *******.***@*****.***
Education:
New York Institute of Technology, NY
Master in Computer Science (August 2006 - December 2007) GPA 3.65/4.0.
North Gujarat University, Gujarat, India
Bachelor of Engineering Computer Engineering (July 2001 - May 2005)
Certificate of Excellence:
• MS SQL Server 2012 – Advanced Level (Brain bench)
Microsoft SQL Server 2005 - Implementation and Maintenance (70-431) (MCTS)
•
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition. (70-228)
•
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. (70-229)
•
Cloud Computing Concepts
•
Technical Skills:
Operating Systems Windows ME/NT/2000/XP/2003/VISTA/server2008/server 2012,UNIX,Linux
Databases(Backend) MS SQL Server 2014/2008 R2/2008/2005/2000/7.0/6,Oracle 8i,9i,MS Access, MYSQL,
Tools Mongo DB
ETL Tools SQL server BI Tools, SQL Server Integration Services (SSIS), SSAS(SQL Server
Analysis Services), SSRS(SQL Server Reporting Services),DTS (Data transformation
services), METAL
Programming C, C++,Visual Basic 6.0, VB .Net, Visual C++, ASP, .net
Languages
Scripting Language Power shell scripting, CSS, PL\SQL
Web Technologies HTML, Semantic HTML, WML, XML,IIS
Reporting Tools: SQL Server Reporting Services (SSRS), Crystal reports 9.0, Oracle Reports.
DB Modeling Tools MS Visio, Erwin
Testing Tools DB N Unit, SQL cop, Ocracoke
Other Tools SQL Azure, Chef,Idea Dignostic Tool, Splunk, Performance Point Server, Tako, Log
Parser, Lite speed, SCOM, BPA, COSMOS, Visio, MOM, SCOM, Octopus, ProClarity,
TOAD, TFS, Demo mate,SQL Server Analysis Services(SSAS),SQL Server Service
Broker,VMWare, SQL server Integration Services, SQL Always On(2012)
DR Technologies Clustering, Mirroring, Log shipping, Replication
Professional Experience:-
Database Administrator
Avalara Inc. (Seattle WA) (July 2014 to Current)
• Maintaining a production MSSQL database server environment. Work on mirroring, replication, clustering.
Performance tuning and SQL query. Work on Database connection issues.
• Involved in SQL script review. Participates in rotating schedule for designated responder duties that require
on-call availability 24x7 during scheduled period.
• Participate in post mortems conducted for outages. Participation in web site/server restoration and find root
cause analysis as part of problem management.
• Responds to database-oriented Engineering helpdesk requests (related to Data and application).
• Performs database migration/upgrade in collaboration with operation staff and external service providers as
needed.
• Respond to monitoring alerts and resolution within any applicable OLA or SLA for the service.
• Involved in deployment of applications in production and other environments (Cloud and windows
environment.)
SQL Database Administrator/IT service Engineer
Microsoft Corporation (Sammamish, WA) (June 2011 - July 2014)
• Install and administer mission critical database servers running SQL 2008 R2, SQL 2008,2014.
Proficient in day to day database maintenance tasks (Monitoring, Backups, space Management, resource
•
utilization, etc.) Work on database permissions and security related issues.
Involved in deciding the backup strategy for the application.
•
Work on Analyzing the Customer facing issues according to the priorities and severity of the problem.
•
Working on ITIL and MOF framework.
•
Work on the Primus KB articles to help the team to troubleshoot the issues in future. Collaborate/Help
•
offshore team to drive the projects.
Capacity planning and monitoring database growth.
•
Respond to monitoring alerts and resolution within any applicable OLA or SLA for the service. Involved in
•
deployment of applications in production and other environments.
Responsible for site availability. Participate in post mortems conducted for outages. Participation in web
•
site/server restoration and root cause analysis as part of problem management.
Troubleshooting and resolving database integrity issues, performance issues, clustering, database connectivity
•
and security issues.
Review, enhance and maintain database security. Create and maintain users and roles, assign privileges.
•
Provide best suggestions on database design (stored procedures, functions, tables, views, triggers, indexes,
•
constraints).
Work with the development for the issues related to the deployments.
•
Work on creating and applying standard SQL configurations to the all the backend in the environment.
•
Provide support for 24x7 production environment.
•
Expedia Inc. (Bellevue, WA) (Dec 2010 - May 2011)
Database Developer
• Developing Database objects like Tables/Stored Procedures/Triggers etc. in OLTP environment. Required for
the program of website at Expedia.
• Work with different teams to create a Database Schema- relational Model in Erwin.
Providing required backups, permissions, authentication to the site.
•
Create/update SSIS packages for data transformation.
•
Create SQL Agent jobs for Re-indexing Database, updating statistics, maintenance etc.
•
Microsoft Corporation (Redmond, WA) (Feb 2010 – Nov 2010)
SQL Database Administrator
• Involved in Deployment of production code for company’s site for internal and external customers.
Suggesting developers the best practices of SQL, index improvement and query optimization.
•
Working with release manager with critical release cycles.
•
Involved in creating SSRS (SQL Server Reporting services) to create Dashboards, graphical, Master-detail
•
reports.
Working on creating and maintaining Synchronous mirrored environment.
•
Creating SQL server agent jobs for tasks like: maintaining Backup’s, Capacity threshold Alerts, Index
•
Maintenance alerts etc.
• Created PowerShell scripts for maintenance related activities.
Morse best Innovation (Seattle, WA) (Oct 2009 - Dec 2010)
SQL Database Administrator
Involved in installing SQL server with analysis services on windows machine, maintain the servers with SQL.
•
Use demo mate tool to make business presentation of different features of SQL.
•
Worked on spatial data with GEOGRAPHY and GEOMETRY data types with creating reports.
•
Microsoft Corporation (Bellevue, WA) (Apr2008 - Sep 2009)
SQL Database Developer\Database Administrator
• Creating SSIS Packages for transferring data (ETL) from Data Mart to Data Warehouse Cube.
Interacting with Users to get requirements and integrating it with Performance Point Server.
•
Created SSIS packages or loading dimensions and facts in PPS environment.
•
Used DB Unit to write test cases for code testing
•
Writing complex queries for project. Analyzing reports to make a decision which will be the best to use
•
OLAP or OLTP.
Prepare and maintain active/passive clusters DR in production.
•
Install and maintain reporting environments.
•
Communicate with different team for releases. Working in replication, Clustering and mirroring environment.
•
Working with SQL profiler, event viewer and performance monitor to dig into the problems.
•
Closely working with SQL profiler to tune stored procedures, Work on SSIS package.
•
NIRMA Limited (Gujarat, India) (Jan 2005 - Jan 2006)
Oracle Developer
• Created Forms and Reports using D2K (Oracle Forms and Reports 6i) for Account, Sales and Warehouse
modules.
• Worked on Complex Oracle Queries using TOAD.
Created matrix, Master-Detail and tabular reports.
•
Created stored procedures using PL/SQL on OLTP Databases.
•
Used Microsoft Visio to create Data flow diagrams to effectively represent business logic.
•
Academic Projects:
Bio- Medical Reporting system (Sept 2007- Dec 2007):
This project I have developed as a part of final semester submission of my masters of computer science. This system
was implemented in .net and SQL as a database. It was designed to provide the patient’s information based on patients
enrollment ID.
Online shopping (Sept 2007- Dec 2007):
This project has been implemented as a study of database management system. It was providing online shopping for
apparels like clothes, jewelry, Shoes, bags etc.
Online Data Ware-house (Dec 2004 – Mar 2005)
This project was implemented in Oracle 9i forms and PL/SQL. It has all the information about company’s ware house
quantity, customer information, and purchase order on warehouse items etc.
Student Information system: (Dec 2003-Mar 2004)
This project I have worked on during my undergraduates. Have used Visual basic to create forms and MS access for
data, having academic, sports, hobby, and exam results about all the students enrolled in a college.
Bank Account Management: (Dec 2003-Mar 2004)
This was a small project created in Visual Basic and MS Access to create bank inventory for all its customers. It has all
account Information and its related transactions detail.
Paper Presentation: Presentation on E–Book reader. Presentation included how the reader functions, what are the
advantages of it, the design Of E-Book reader, history of its innovation etc. (Apr 2004 – Aug 2004)