Jan 2020 – Jul 2020 · 6 mos

• ● A diligent and competent professional with more than 7.5+ years of experience in MS SQL Administration, 2.5+ years on VMWare VSphere virtual solutions.
• ● Working with stakeholders on a day-to-day basis to understand and resolve architectural issues.
• ● Manage end-to-end service delivery, including offsite operations and stakeholder management for the end-to-end solutions.
• ● Promptness in the understanding of the business needs and the ability to come up with innovative ideas.
• ● Managing virtualized MS SQL Server environment, Capacity Planning, Migrations and Transition of Applications.
• ● Working with the latest High Availability-Disaster Recovery Solutions such a Clustering, AlwaysOn, Log shipping etc.
• ● Managing Virtualized environment through VMWare Vsphere and related tasks on DataStores,ESX Hosts, etc.
• ● Performance Tuning on applications where the response is not optimal and bringing them up to the established mark.
• ● Spearheading the automation of day to day tasks to keep a high level of engagement on projects and effective time management.
• ● Mentoring team members and building them up to take new roles and responsibilities.

Mar 2017 – Dec 2019 · 2 yrs 9 mos

• Role
• Diligent and competent professional with almost 7.5 years of experience in MS SQL Administration, 2.5+ years on VMWare VSphere virtual solutions.
• Working with stakeholders on a day-to-day basis to understand and resolve architectural issues across environments.
• Manage end-to-end service delivery, including offsite operations and stakeholder management for the end-to-end solutions of respective applications.
• Excellent time management skills with the ability to work accurately and quickly prioritize
• Co-ordinate and consolidate tasks.
• Promptness in the understanding of the business needs and ability to come up with
• Innovative ideas.
• Excellent communication & interpersonal skills.
• Responsibilities
• Managing projects for the client such as SQL Database Migration, Application Upgradation, SQL Monitoring Solutions, Automation & Powershell Scripting.
• On-boarding\Upgrading application in the environment and working on their seamless integration within the organization.
• Building new-working environment for the client involving spinning up new clusters, new SQL Servers, database growth & disk growth planning, and the best possible ways to support the application.
• Building PowerShell Scripts for automating the Environment & reporting solutions for in-house applications.
• Troubleshooting various performance issues on SQL instances.
• Performing VMWare admin tasks such as expanding the disk space, hot adding CPU and memory for the virtual machines.
• Migrating\vMotion VM’s to other data stores to resolve datastore disk space issues.
• Analyzing the SQL traces, memory and SQL dumps to fix the root causes of the issues.
• Troubleshooting the Active Batch jobs running on and for SQL Servers for the client.
• Troubleshooting on High Availability Issues for Clustering, Always-On, Log Shipping, Replication etc
• Planning and implementing Disaster Recovery Procedures to ensure minimal downtime and data loss.

Feb 2015 – Mar 2017 · 2 yrs 1 mo · Kolkata Area, India

• ● Managing the Installation, Configuration and Upgradation of the MS SQL Server environment to the latest builds.
• ● Planning and Implementing Disaster Recovery Solutions to ensure minimal downtime and data loss. ● Working on High Availability features such as AlwaysOn, Clustering, Replication, Log shipping.
• ● Creating Backup\Restore policies, Maintenance Plans to ensure the high-performance delivery of the in-house applications.
• ● Troubleshooting performance issues for applications on MS SQL Server Instances and related applications.
• ● Creating automated jobs to run and deliver reports on system Health Checks on a timely basis through PL\SQL and Powershell.
• ● Systemized the process for incoming tickets and delivery of services in a timely and proficient manner.
• ● Excellent Time Management skills with the ability to work accurately and quickly prioritize, coordinate and consolidate tasks.

Jan 2014 – Jan 2015 · 1 yr · Noida Area, India

• ● Working and performing tasks on various types of Backups and running restores as per the client requirement.
• ● Setting up monitoring alerts on the SQL specific jobs for alerting the respective teams in case of job failures.
• ● Performing MS SQL Server Installation, Uninstallation and applying Service Packs, Cumulative patches.
• ● Authorizing access on SQL Server through Security groups and SQL Logins.
• ● Running reports on Health Checks and Analyzing them to make sure the environment is in the best state possible.
• ● Performing maintenance activities and Logging calls with Microsoft to troubleshoot issues halting the production environment.
• ● Hand-on Training and Experience on High Availability features such as Mirroring, Log Shipping, and Clustering.
• ● Handling level 1 performance issues for the client.

Jun 2012 – Dec 2013 · 1 yr 6 mos · Noida Area, India

• I am a SQL Server Database Administrator performing the following functions as a part of my profile
• >Admin Tasks
• >Responsible for the day-to-day operation on Servers.
• >Create/maintain user profiles,
• >Perform daily, weekly and monthly backups.
• >Job scheduling,
• >System Maintenance/Performance
• >Restoring data/libraries,
• > Performing Log-shipping, Mirroring, and other high availability tasks.

Jun 2011 – Jul 2011 · 1 mo

• Software Testing and Database Management and Query Optimization.

Jun 2011 – Jul 2011 · 1 mo