Sign in

Sql Server Project

Ahmedabad, Gujarat, India
December 27, 2017

Contact this candidate

Nikunj T Dhameliya

(BE I.T.)

Email Id: -

Contact No: - 09033669939


B.E.: Bachelor of Engineering, North Maharashtra University (NMU) with First class.


Apr 2015(Current),E-Procurement Technologies Pvt Ltd (CMMMi 3)

Project Name

E-Procurement (Auction/Tender, Procurement Services) System, CRM.



Jan 2014 – Apr 2015, MSBC Solution (India) Pvt Ltd, Ahmedabad (CMMMi 3)

Work for OTAS Technology (UK)

Project Name

OTAS (Finance Project)


Software Developer

Mar 2013 – Jan 2014, GLS Business India Service (Marketly LLC),Ahmedabad

Project Name

MonitorM Parser


Software Developer

An Innovative thinker with extensive experience designing, coding, testing and supporting next generation database solution possesses as Database support.

Expert in technical problem solving skills.

Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.

Key Skills:

SQL Server 2008/2012, MySQL, SSRS, SSIS, Ado.Net, ASP.NET, C#, Visual Studio 2012.

Knowledge of tables, Store Procedure, Triggers, Views & Index, T-Sql.

Database Backup & Restore, Log shipping.

Database Production Support.

Trouble shooting Sql Server problem, Error handling.

Handling of large data tables & joins.

Knowledge of Performance Tuning, Optimizing Query, Execution Plan.

Good communication and analytical skills.

Having Good Knowledge of SDLC.

Object Oriented Programming Concepts.

Good Debugging Skills for Codes.

Good technical and problem solving skills.

Technical Skills

Programming Languages : T-SQL, ASP.NET, Ado.Net, C#, HTML, AJAX, JavaScript, LINQ, C, and C++.

DBMS/RDBMS : MS Sql Server 2008 / 2012, MySQL, Oracle 9i.

Tools : Visual Studio 2010/ 2012, MS Office, Adobe Flash Professional CS5, Adobe Dreamweaver CS5, SQL Delta, RedGate.

Operating Systems : Microsoft Windows XP/Vista/Windows7/8/10.

Testing : Unit Testing (Nunit Tool .Net Frame Work), Manual Testing, Integration testing.

Key Points

Development/UAT DBA

Production DBA

Design Tables



Design Database



Write Query



Deploy Changes



Tune Queries



Monitor Performance



Troubleshoot outages


Install & Config SQL


Design & Test DR




Year Of Passing

University/ Board





Maharashtra University

R.C.Patel Institute of Technology.

First Class

Project Experience

Project: E Tendering/Auction (Procurement Services), E MarketPlace, CRM


This project for enabled 100,000+ eTenders, RFQ’s, Reverse Auctions, eAuctions, transactions for 100’s of Buyers worth Trillions of Dollars till date. It is an Open source e-Procurement Solution. It offers the most secure e-Procurement suite that meets all International digital security guidelines like SSL, Digital Certificates, Hashing, Bio Metrics, Crypto keys, etc. e-Procurement has its own Global Supplier portal ( which has an exhaustive Global Supplier database running into 1 Million+ Suppliers chasing Global Tenders & Pvt. Leads. It suite is a very flexible & modular application which needs no customization because of Integrated Dynamic Form engine, Work flow & Roles manger, Payment Gateway, etc.


Strong hands on experience in MS SQL Server Installations, Upgradation, Performance Tuning, Backup and Recovery, and implementing high availability solutions.

Installed and configured Cluster on SQL Server 2012, 2008/2008 R2

Worked as both Production DBA and Application Support DBA.

Working knowledge of Active Directory Domain with Windows administration.

Worked well independently as well as in team-oriented environments.

Establishing guidelines for a New Server builds and backup restore strategy.

Experience in supporting huge databases and trouble-shooting problems.

Extensive knowledge of ITIL concepts like Problem management, Change management etc.

Posses sound analytical, Problem Solving and Team Leading skill.

Customer focus and ability to take ownership to resolve issues.

Installation of SQL Server 2005/2008 R2/2012, Service Packs, Hot fixes, Slipstream

User Management/Security Implementation

Backup and Restores

Log Shipping, Mirroring, Clustering and Replication High Availability options

Automating and Hardening SQL Server Instances

System and User database corruptions and Page specific corruptions

End to End Windows/SQL Server cluster deployments (N+1, N+M configurations)

Research on new releases as SQL Server 2008 R2 and 2012

Environment: SQL Server 2008/2008 R2/2012, Visual Studio 2010 / 2012, MySQL, SSIS.

Project: OTAS-Olivetree Analytical Solution (Stocks Trading Assistance Application)


OTAS is a secure, cloud based platform that alerts portfolio Managers and Traders to hidden risk and opportunities concealed & analytics on 10000+ stocks worldwide. It manages more than 1 million data-integration project for Stock market, third-party market data application. You can instantly access the relevant signals and risk forecasts from every important market observable. The information is presented in a format designed for market professionals working under pressure in difficult markets. Important information can be concealed in events, insider transactions, short interest, options, valuation, technical, news flow, and credit and analyst revisions.


Requirement analysis.

Create new database for the customer and export other monitoring scripts.

Solution design & Implementation, Testing, This project for financial analysis of stock market Dow Jones Emerging Market Indices. Dow Jones publishes the world's most trusted business news and financial information in a variety of media.

Developed Test Cases for testing purpose.

Manage all stocks data with its history data in MS- Sql sever.

Managed and resolved design issues during development stage. Worked closely with developers.

Added more new features to existing analysis software tools.

Proficiency and expertise in Database Administration - SQL Server 2008, SQL Server 2012.

Technical expertise in all aspects of database implementation life cycle - from sizing, through capacity planning, design, and implementation.

Technical expertise and hands-on support in consolidation and migration of databases to new hardware and platforms.

Recommend, implement and maintain best practices and corporate standards.

Implement SQL server solutions for complex projects and have deep understanding of SQL server security requirements and policies.

Implement SQL Server High Availability and Disaster Recovery strategies like SQL clustering, Always-on, Transactional replication, Mirroring and log shipping.

Implement Backup/Recovery and backup contingency tests.

Providing inputs in defining database standards and best practices for advanced monitoring and troubleshooting, performance tuning and automation.

Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals.

SQL 2012 migrations, Security Management operations, Transparent Data Encryption and CDC.

Proficiency and expertise in SQL Server performance problems, fine-tuning of databases and index Analysis.

Experience in using DMV and dynamic management functions for analysis.

Monitor and maintain; All SQL Server instances (Production, Staging, QA, & Development) All SQL Server subsystems (SQL Agent etc.)

Creation of several SQL Administrative reports using SQL Reporting Services and fulfill ad hoc query and requests from other departments.

Experience with multi 1+ TB databases on SQL environments.

Experience with remote disaster recovery and business continuance sites.

Ensure that the team follows the processes & distribute the workload among the team evenly.

Environment: C#, SQL Server 2008/2012, Visual Studio 2008/2012/2014, SSIS, Packages.

Project: LiveLinkM Nunit Testing Tool


This project also for anti-piracy challenges testing on downloading sites which is available their contents & product link on his site. Parsing all content & matches with actual content on test cases.


Requirement analysis.

Solution design & Implementation, Testing.

Developed Database SPs/Functions/Tables.

Environment: C#, Nunit (.Net framework tool), Visual Studio 2008/2012/2014

Project: Implementation of Parsing Product of MonitorM Crawler, MonitorM Parser

Creation and Testing Application in C#.


This project for engineered solutions that address today’s anti-piracy challenges, producing quantifiable results for Microsoft. That delivers actionable market intelligence solutions to Fortune for Microsoft, Warner Brothers, Disney and many other companies' product, protecting their brands online from counterfeit and piracy activity. Implementation in ‘MonitorM Parser Engine’ application. This application collects all the product site information from the given listings of every module.


Requirement analysis

Solution design & Implementation

Developed Database SPs/Functions/Tables.

Environment: SQL Server 2008/2008 R2/2012, C#, Visual Studio 2008/2012/2014.

Personal Details

Name: Nikunj T Dhameliya

E-mail: (Preferred)

Ph No: 09033669939

D.O.B: 11/01/1991

Present Address:

B-11, Aatirth Complex, Near Hirabag Crossing,

Ambawadi, Ahmedabad. (380004)

Contact this candidate