Anik Naskar

Looking ahead to work in a challenging position as a Azure Data Engineer with growth-oriented organization that offers ample opportunity to utilize technical expertise and willingness to learn in making an organization successful.

Over all 7 years 5 months of in depth experience in Database Design, Developing, Implementing and administering of multiple large database systems using MSSQL 2016/2014 /2012/2008R2/2008/2005. More than of six month ONSITE work experienceMS SQL Server administration & Elaticsearch 6.2.0 implementation. at Client location Apoteket AB,Sweden in Thorough understanding of SQL Server internal architecture, memory handling, DB Indexes and statistics. Designed and developed TSQL queries and appropriate database code such as joins, stored procs, functions, tables, views, triggers, indexes, constraints, CTE and CDC. Specialized in Installing, Upgrading, Migrating and Configuring of Microsoft SQL Server and Databases (2005, 2008, 2008R2, 2012, 2014, 2016,2017). Experienced on fresh Installation of SQL Server on cluster nodes and participated in patching activity on Stand Along, Clustered and Always-on environments. Responsible for the Production to Development, Test Database, QA Database Refreshes based on requests. Operated administrative task like assigning access and privileges to users in the server role, database role, SQL user, windows user and groups, grant and revoke statements along with fixing orphan users. Enforced regular database maintenance and ensured daily health checkup, housekeeping, Rebuild, Reorganization and Statistic Update of all database server. Configured, scheduled and administered routine Jobs, Tasks, Alerts and Maintenance Plans. Investigated and explored various monitoring issues including Data files auto growth, Transaction log files, Fill Factor, Fragmentation, Temp database growth and SQL services. Analyzed shipping issues, connectivity issues and security issues. and resolved database performance issues, blocking and deadlocking issues, log Linked Servers for central management servers and DB Mail creation and issues handling. As DBA, responsible for identifying, troubleshooting, and resolving database system alarms and alerts including detection of SQL Server related CPU, memory, I/O, disk space and other resource contention. Operated core administrative task like backups, restores, recovery procedure, database shrink operations, DBCC\DMV commands and SQL job failures. Hands on experience in query optimization, planning and database performance tuning using SQL Profiler, Audit Evidence, SQL Server Side Trace, Database Engine Tuning Advisor, Activity Monitor and Performance monitor. Presented IT Disaster Recovery planning and end to end executed the DR solution (log shipping) understanding the data loss risk and minimizing DB downtime. Setup and Configured High availability (HADR) concepts using Log Shipping, Database Mirroring, Transactional Replication, SQL Clustering in all applicable SQL versions. Performed daily Clustering, Database mirroring and Log-shipping administrative tasks. Administered Integration Services (SSIS), SQL Server Reporting Services (SSRS). in MSBI projects with extensive usage of ETL & Reporting tools like SQL Server Currently working as an Azure Data engineer. Taking care of all deployments of ADF pipelines, ADW/SQL PaaS objects through CICD pipelines. Working as Azure SQL PaaS database administrator for taking care of database monitoring, pipeline monitoring and performance tunnning.

• Tata consultancy services, IT Analyst (Database Admin), 3 years 9 Months
• Cognizant Technology Solutions, Technical Lead (Database Admin), 1 year 2 Months
• PWC India, Senior Consultants (Azure Data Engineer), 13 Months

• Dodge, Leading American Construction Publication Company, 09/2014 - 2015, New Jersey, USA, The Dodge API and Services is responsible for providing construction related projects data all around USA and Canada in an organized structure to dodge global network and different third party consumers. The purpose for Dodge API and Services is to ingest project and company related data into Sql Server repository and provide search result to consuming applications. Following is the main functionality and scope of the project:
• Exposing REST based API’s. Sql Server as data repository. Handling Request and Response in XML and JSON. License based access to consumers. Providing smooth search capabilities. Provide the advance features like Stemmed Search, Facet Filtering, SQL DBA, I worked as a SQL DBA, also providing support to the .NET development team. Apart from development, my responsibilities were requirement gathering, design, estimation and deployment/delivery., MS SQL Server 2008,2012, I proposed and implemented several out of box cost effective solutions to clients. I have achieved to fix and tune major performance related issues, which have helped the client double their existing user base.
• Pronet Application Support, Leading American Construction Publication Company, 09/2015 - 2016, New Jersey, USA, Pronet is responsible for providing construction related projects data all around USA and Canada in an organized structure to dodge global network and different third party consumers. The purpose for Dodge API and Services is to ingest project and company related data into MS SQL Server repository and provide search result to consuming applications. Following is the main functionality and scope of the project:
• Exposing REST based API’s. SQL Server as data repository. Handling Request and Response in XML and JSON. License based access to consumers. Providing smooth search capabilities. Provide the advance features like Stemmed Search, Facet Filtering, SQL DBA, I worked as a SQL DBA, also providing support to the .NET development team. Apart from development, my responsibilities were requirement gathering, design, estimation and deployment/delivery., MS SQL Server 2008,2012, I proposed and implemented several out of box cost effective solutions to clients. I have achieved to fix and tune major performance related issues, which have helped the client double their existing user base.
• Elasticsearch Upgarde 6.2.0, Leading Sweden Medicine Company, Present, Stockholm, Sweden, We have upgraded current Elasticsearch to 6.2.0., Elasticsearch Admin, I worked as a Elasticsearch Admin, also providing support to the development team. Apart from development, my responsibilities were requirement gathering, design, estimation and deployment/delivery., Elasticsearch 6.2.0, I proposed and implemented several out of box cost effective solutions to clients. I have achieved to fix and tune major performance related issues, which have helped the client double their existing user base.
• SQL Server DBA, Leading Sweden Medicine Company, 2017, Stockholm, Sweden, Administration of SQL SERVER 2008,2012,2016, MS SQL Server ADMIN, I worked as a MS SQL SERVER Admin, also providing support to the development team. Apart from development, my responsibilities were requirement gathering, design, estimation and deployment/delivery., Database, I proposed and implemented several out of box cost effective solutions to clients. I have achieved to fix and tune major performance related issues, which have helped the client double their existing user base.

• Pan Number: ALSPN5138P
• Date of Birth: 06/11/91

1.Az-108-Microsoft Certified: Azure Administrator Associate

2.Google-Introduction to Generative AI

3.Dp-203-Microsoft Certified: Azure Database Administrator Associate

4. Microsoft Azure Data Fundamental

5.Microsoft Certified: Azure Database Administrator Associate