Oct 2017 – Jun 2021 · 3 yrs 8 mos · Gurgaon, India

Nov 2015 – Oct 2017 · 1 yr 11 mos · Bangalore Area, India

• Provide consulting, architecture in House Databases for Trading & Supply Business in Shell.
• RDBMS: - SQL Server / Oracle / MongoDB / AWS PaaS databases / SQL Azure
•  Review design specifications of database with respect to Application requirements.
•  Ensure all the databases (both SQL Server and Oracle databases) are complaint as per the security baseline by educating the Operational Landscape Managers (OLMs) regarding the non-compliances and making them understand the impact of the same in simple non-technical language.
•  Help migrate smaller databases to NoSQL like MongoDB, and help development team with writing queries for MongoDB.
•  Perform end to end database migration from on - premise databases to Cloud databases both on AWS and Azure platform.
•  Helping Strategy and Planning team with encryption, IDS and other security implementations on cloud environments like AWS and Azure.
•  Helping to automate an infrastructure deployment by writing JSON templates using Azure Resource Group Deployments.
•  End to end database development activity from planning phase to designing.
•  Ensure the database design follows the database naming standards.
•  Ensure all database source codes and models are identical across the Application environment.
•  Deliver sustainable, supportable Project databases.
•  Provide L3 or escalation support problem tickets resolution, RCA's.
•  Own Trading database standards, Process and representatives in Database Governance body.
•  Helping in ETL workflow by writing Informatica Power Center workflows, and certain data analytics logic using a tool called Alteryx.
•  Follow Agile methodology to deliver project and VSTS for source control.

Sep 2013 – Oct 2015 · 2 yrs 1 mo · Bengaluru Area, India

• Providing Support and Consultation for Customers across North America and India region. RDBMS: - SQL Server
•  Provide consultation on design specifications of database High Availability solutions with respect to Application requirements.
•  Help customers perform end to end database migration from on - premise databases to Azure Cloud databases.
•  Educating customers to automate their infrastructure deployment by helping them how to write JSON templates using Azure Resource Group Deployments.
•  Troubleshoot Azure Resource Group Deployments using PowerShell ISE.
•  Troubleshoot core issues like installation, configuration, upgradation, block corruption, service startup issues, etc.
•  Deep Dive analysis for performance tuning of SQL Server databases which includes T-SQL tuning, database configuration level tuning, O.S. level tuning, and to certain extent network level tuning to find the root cause of the slowness and provide the resolution.
•  Analyze memory dumps by aligning SQL Server source code to find the root cause of the issue.
•  Configure and troubleshoot High Availability and Disaster Recovery Solutions like AlwaysOn, Multi Subnet Clusters, Log Shipping, Mirroring and Replication.
•  Follow Proactive approach by educating the customers about the best practices and known issues.
•  Provide L3 or escalation support problem tickets resolution, RCA's.

Feb 2013 – Aug 2013 · 6 mos · Kolkata Area, India

• Project: - Merck
• RDBMS: - Oracle / SQL Server
•  Providing Master Data Management (MDM) Support for US Customer Master using Informatica MDM (Siperian), Informatica Power Center, Oracle and SQL Server databases.
•  System Test Plan (STP) preparation as per standard Merck Template.
•  Maintained code-versioning using Tortoise SVN.
•  DBA activities like creation and management of tablespaces, tables, views, creation of databases, space monitoring, enrolling users and maintaining system security etc.
•  Performing daily health check of the business critical databases.
•  Performing database backups as a part of a change request.
•  Troubleshooting and creation of RCA report for P1 issues related to database.
•  Checking backup report and troubleshooting error related to backups.

Nov 2010 – Feb 2013 · 2 yrs 3 mos · Kolkata Area, India

• Project: - Centralized Banking System (CBS) using TCS Bancs
• RDBMS: - Oracle / SQL Server
•  Development of Back-end components using PL/SQL for an in-house Data Migration Tool.
•  System Test Plan (STP) preparation as per standard AIG-TCS STP Template.
•  Maintained code-versioning using Microsoft Visual Source Safe.
•  Use Case Preparation as per TCS Standard.
•  DBA activities like creation and management of tablespaces, tables, views, creation of databases, space monitoring, enrolling users and maintaining system security etc.
•  Work on export / Import as per customer’s request.
•  Research and fix the TEMP & UNDO Tablespace issues.
•  Database user creation with required privileges.
•  Performing daily health check of the business critical databases.
•  Performing database backups as a part of a change request.