Nikunjbhai T. Dhameliya

(BE I.T.)

Email Id: - admcqu@r.postjobfree.com

Contact No: +91-903******* (India)

Summary

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

Experience:

Jun 2019 (Current), Persistent System

Project/Client Name

Oil & Gas (Schlumberger) / Petronas (Malaysia)

Role

SQL DBA, SQL Developer / Database Engineer

Aug 2018 – Jun 2019, Cognizant Technology Solution India, Pune

Project/Client Name

British Telecom (BT)

Role/Designation

DBA, SQL Developer/ Tech Lead

Apr 2015 – Aug 2018, E Procurement Technologies Pvt Ltd

Project Name

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

Designation

Senior DBA/SQL Developer

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

Project Name

OTAS (Finance Project)

Mar 2013 – Jan 2014, GLS Business India Service

Project Name

MonitorM Parser, LiveLinkM

7.6 Years of experience in MS SQL Server Administration & database development and support in MS-SQL Server environments.

Design and development Experience of cloud computing with Microsoft Azure, SQL Azure, Migrating application from on-prem to Azure SQL & Azure VM.

Basic knowledge of AWS Services.

Experience in deploying and managing SQL server clusters and using different methodologies for performance, high availability, business continuity and disaster recovery (HA/DR).

Familiar with end to end setup for an on premise and cloud deployment of Power BI, Hands-on dashboard design on Power BI desktop and report creation using virtualization on Power BI.

Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Ability to detect and troubleshoot SQL Server related CPU, memory, I/O disk space and other resource contention.

Strong knowledge of backup, restores, recovery models, database shrink operation, DBCC commands, Clustering, Database mirroring, Replication.

Knowledge of how indexes, index management, integrity checks, configuration. How statistics work, how indexes are stored, how they can be created and managed effectively.

Knowledge of SQL Server tools (Profiler, DTA, SSMS, SSCM, PerfMon, DMVs, SSIS and SSRS & Power BI).

SQL Development – ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, view, triggers, indexes and constraints).

Manage SQL Server database through multiple product lifecycle environments, from development to mission critical production system.

Independently analyze, solve and correct issues in real time, providing problem resolution end-to-end.

Assist developers with complex query tuning and schema refinement.

Share domain and technical expertise, providing technical mentorship and cross training to other peers and team members (including non-SQL specialized developers) to ensure secure, high-performing queries and SQL code across the enterprise.

Key Skills:

SQL Server 2008 R2/2012/2014/2016, Power BI, SSRS, SSIS, MySQL, C# (Basic knowledge), Visual Studio 2008/2012/2015, ETL Tools (BIDS, SSDT).

Proficient in SQL Server database administration

Proficient in SQL Server database design and build (schema, table layouts, optimization, field definitions & queries).

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

Database Backup & Restore, Log shipping.

Data Migration, Import/Export, Bulk Insert & migrate SQL object and SQL Server Migration.

Database Production Support, troubleshooting 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.

Key Points

Development/UAT

Production

Design & Test DR

Yes

Yes

Install & Config SQL

Yes

Yes

Migration

Yes

Yes

DB Development / Complex Query

Yes

Yes

Performance Tuning

Yes

Yes

Monitor Performance

Sometimes

Yes

Troubleshoot outages

Sometimes

Yes

Design Database/Tables

Sometimes

Yes

Power BI

Yes

Yes

MSBI (SSIS/SSRS/SSAS)

Yes

Yes

Technical Skills

Programming Languages : T-SQL, C# (Basic knowledge), HTML.

DBMS/RDBMS : MS Sql Server 2005/ 2008 R2/ 2012 /2014 /2016, MySQL, Oracle 9i.

Tools : SQL Delta, RedGate, Visual Studio 2010/ 2012, MS Office

MSBI Tools : Power BI, SSIS, SSRS, SSAS

Operating Systems : Microsoft Windows7/8/10, Windows Server 2012 R2/2016.

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

EDUCATIONAL QUALIFICATIONS

Degree/Certificate

Year of Passing

University/ Board

Institution

Grade

B.E.(I.T.)

2012

Maharashtra University

R.C. Patel Institute of Technology.

First Class

PROJECT EXPERIENCE

Petronas, Jun 2019 - till date

Client: Schlumberger Oil & Gas Services

Role: SQL DBA/Data Engineer

Responsibilities:

Responsible for installing, configuring, and maintaining SQL Server Instances.

Writing and improving SQL Server T-SQL queries.

Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.

Created automation of day to day operations, critical SQL server alerts and repetitive tasks.

Monitored the health and performance of SQL, server instances and home-grown applications using Extended Events, SQL server Profiler, PerfMon and other third-party tools.

Tested newly built servers for performance impact with DB load simulators.

Setup and maintain Log Shipping between various environments.

Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling.

Backed up master & system databases and restored them when necessary.

SQL Server to PostgreSQL migration.

Oracle to SQL Server Migration using SSMA.

Environment: SQL Server 2008/2008 R2/2012/2014/2016, Azure SQL, Power BI, Visual Studio 2010 / 2012, MSBI (SSIS/SSRS).

Project: British Telecom

Responsibility

SQL Server 2008 R2/2012/2014/2016, SQL, T-SQL, Stored Procedures, Triggers, UDF, BCP, DTS, SSIS packages

Installing, designing, developing, maintaining and tuning of RDBMS like SQL 2008 R2/2012/2014/2016

Experience in deploying and managing SQL server clusters and using different methodologies for performance, high availability, business continuity and disaster recovery

Monitor the status of Maintenance jobs-schedule to run daily and on weekends (tasks like Rebuild Indexes, Defragmenting databases, Shrink and Backup).

Verify backups and error logs on the servers and troubleshoot on any failures or alerts, open trouble tickets if necessary, to work with technicians from other departments.

Query Optimization. Attending customer complaints regarding slow query performance and tuning accordingly.

Environment: SQL Server 2005/2008 R2/2012/2014/2016, Visual Studio 2010/2012.

Project: E Tendering/Auction (Procurement Services), E MarketPlace, CRM, TenderTiger.com (April 2015-Aug 2018)

Description

This project 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, Biometrics, Crypto keys, etc. e-Procurement has its own Global Supplier portal (TenderTiger.co.in) which has an exhaustive Global Supplier database running into 1 Million+ Suppliers chasing Global Tenders & Pvt. Leads. Its suite is a very flexible & modular application which needs no customization because of Integrated Dynamic Form engine, Workflow & Roles manager, Payment Gateway, etc.

Responsibility

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 2008 R2/2012/2014/2016

Worked as both Production DBA and Application Support DBA.

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

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

Customer focus and ability to take ownership to resolve issues.

Backup and Restores Database.

Log Shipping, Mirroring, Clustering and Replication High Availability options.

System and User database corruptions and Page specific corruptions.

End to End Windows/SQL Server cluster deployments.

Research on new releases as SQL Server 2008 R2 / 2012 / 2014 / 2016.

Environment: SQL Server 2008/2008 R2/2012/2014/2016, Power BI, Visual Studio 2010 / 2012, MySQL, MSBI (SSIS/SSRS)

Project: E MarketPlace (April 2015-Aug 2018)

Description

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, Crypto keys, etc. e-Procurement has its own Global Supplier portal (TenderTiger.co.in) which has an exhaustive Global Supplier database running into 1 Million+ Suppliers chasing Global Tenders & Pvt. Leads. Its suite is a very flexible & modular application which needs no customization because of Integrated Dynamic Form engine, Workflow & Roles manager, Payment Gateway, etc.

Responsibility

Developed Power BI model used for financial reporting and Headcount.

Designed and documented the entire Architecture of Power BI POC.

Automated Power Query refresh using power shell script and windows task scheduler.

Installed and configured Enterprise gateway and Personal gateway in Power bi service.

Created Workspace and content packs for business users to view the developed reports.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.

Weekly presentation to the business users about the reports and their changes as required.

Worked on all kinds of reports such as Yearly, Quarterly, Monthly, and Daily.

Worked on all types of transformations that are available in Power bi query editor

Environment: Power BI, SQL Server 2012, SSMS, SSIS, SSRS, T-SQL, MS Word, MS Excel

Project: OTAS-Olivetree Analytical Solution (Stocks Trading Assistance Application) (Jan 2014-Apr 2015)

Description

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 projects for the Stocks market, third-party market data applications. You can instantly access the relevant signals and risk forecasts from every important market observable. The information 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.

Environment: SQL Server 2008/2012/2014/2016, Visual Studio 2008/2012/2014/2016, MSBI (SSIS/SSRS), Packages.

Project: LiveLinkM Nunit Testing Tool (Mar 2013-Jan 2014)

Description

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.

Responsibility:

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#. (Mar 2013- Jan 2014)

Description

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' products, 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.

Responsibility:

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

Full Name : Nikunjbhai Tulsibhai Dhameliya

E-mail : admcqu@r.postjobfree.com (Preferred)

Phone No : +91-903******* (India)

D.O. B : 11/01/1991

Present Address:

A 302, Aeromatic Breeze, Near CCD ZEN Business Center,

Bhumkar Chowk, Pune, India (411057)

Contact this candidate