Database Cloud Migration Imp Team Lead • June-2021 to May-2024
Description: Design, implement and administer databases on MS SQL Server 2014 2016 2017 2019 platforms for OLTP Migration of SQL Server Instances from 2008 R2 2012 2014 to, 2016 2017 2019. Migrating on-premises SQL Server Database to Azure cloud Implemented new SQL Server features by performing successful POCs Experienced in providing analysis on High availabilityDisaster recovery scalability Good Understanding Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service IaaS, Platform as a Service PaaS and Software as a Service SaaS Experience in managing Very Large databases VLDB and troubleshooting problems Implemented Extended Events to replace custom scripts for monitoring & troubleshooting issues Use of Query Store feature for monitoring performance of database systems Scripting PowerShell to automate database/Server level activities like monitoring disk space, Status of services etc., Have Good understanding & experience on different RAID levels Experienced in Securing data with Dynamic Data Masking, Always Encrypted, Row-level security Building and integrating information systems to meet the company’s needs. Assessing the systems architecture currently in place and working with technical staff to recommend solutions to improve it. Resolving technical problems as they arise. Providing supervision and guidance to development teams. Continually researching current and emerging technologies and proposing changes where needed. Informing various stakeholders about any problems with the current technical solutions being implemented. Assessing the business impact that certain technical choices have.
Senior database administrator • October-2020 to June-2021
INetFrame Technologies pvt Ltd
Description: Design, implement and administer databases on MS SQL Server 2014 2016 2017 2019 platforms for OLTP Migration of SQL Server Instances from 2008 R2 2012 2014 to, 2016 2017 2019. Migrating on-premises SQL Server Database to Azure cloud Implemented new SQL Server features by performing successful POCs Experienced in providing analysis on High availability Disaster recovery scalability Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service IaaS, Platform as a Service PaaS and Software as a Service SaaS Experience in managing Very Large databases VLDB and troubleshooting problems Implemented Extended Events to replace custom scripts for monitoring troubleshooting issues Use of Query Store feature for monitoring performance of database systems Scripting PowerShell to automate database Server level activities like monitoring disk space, Status of services etc Have Good understanding & experience on different RAID levels Experienced in Securing data with Dynamic Data Masking, Always Encrypted, Row level security Building and integrating information systems to meet the company’s needs. Assessing the systems architecture currently in place and working with technical staff to recommend solutions to improve it. Resolving technical problems as they arise. Providing supervision and guidance to development teams. Continually researching current and emerging technologies and proposing changes where needed. Informing various stakeholders about any problems with the current technical solutions being implemented. Assessing the business impact that certain technical choices have.
Senior database administrator • May-2019 to September-2020
Productiva info tech Solution
Description: Experience on monitoring SQL Server Performance using Perfmon and Profiler Tools Maintenance tasks like index defragmentation or rebuild on different databases. Having experience on database backup and restorations. Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support. Identifying resolving fragmentation resulting in improved performance. Hands on experience in High Availability such as Log-Shipping, Database Mirroring, Replication, clustering and Always ON. Having experience on rebuilding master database during crash situations Monitoring SQL Server alerts at regular intervals Monitoring SQL Server agent jobs maintenance plans Provided 24 7 Production support for the database and application issues. Working with Transaction replication installation and maintenance. Enrolling users, controlling, and monitoring User Access to the database, and maintaining system Doing Weekly Refresh of Database from Production to Test Environment. Configuring the Transaction replication in production environment. Good experience in performing the Log Shipping and Mirroring in Production environment. Performed various Databases up gradations and server migrations. Good Experience in Applying the DR activities using Backup and restore and log shipping. Participating in on-call rotation and working occasionally after hours or on weekends
Microsoft SQL Server DBA • February-2018 to January-2019
Magna info tech and Capgemini
Description: Performance tuning using activity monitor, custom sql codes, SP who and who2 active, sqldiag, DMV's, sql profiler, perfmon, index tuning wizard and query analyzer. Responsible for installation of SQL server instances, and for general database maintenance (creating and modifying in-house written and wizard generated maintenance plans, monitoring the state of databases using DBCC utilities and DMV’s. Set up and supported log shipping, replication transactional and database mirroring that were used for failover and DR purposes. Provided physical database design suggestions, and technical support for the development staff. A major part of this work involved performance tuning, including index design and suggestions on how to recode SQL statements as well as general problem solving of setup and operational issues. Working on various ticketing tools for various clients within the shared support team. Monitoring multiple ticketing queues. Mainly worked for finance and insurance division on this share account. Troubleshooting SQL Server service outages as they occur. Track and resolve database related incidents and alerts within client service levels SLA by following incident management procedures Responding to client email requests. Refreshing of databases based on the client request from PROD to UAT, DEV Test environments. Participating in change management processes including deploying database changes in all environments as requested, following client change management standards and procedures Performing SQL Server installations, upgrades, migrations, and patching Monitoring and tuning SQL Server database performance Mentoring, instructing, and providing guidance to lower-level team members Participating in on-call rotation and working occasionally after hours or on weekends
senior operation professional SQL DBA • June-2015 to August-2017
IBM India Private Limited
Description: Involved in installing SQL Server 2008, 2008R2 and 2012. Involved installing service pack, cumulative updates, and hot fixes. Creation of user databases and ensuring file group creations and ideally placing files Creating logins and mapping logins to DB and granting permissions at server and object level. Checking the status of backups and troubleshooting the failed backups. Checking the backup reports and ensuring that all the backups are proper. Schedule and maintain routine jobs, alerts, and maintenance plans. Restoring the backups when it needed. Recovering databases from backup in disaster situation. Implemented high availability option such as log shipping, Database mirroring Always On AG Monitoring and maintaining high availabilities options being used in server such as log shipping, Database mirroring and Always On AG. Creating indexes on tables to improve the performance as per the Dev App team request. Tuning and monitoring performance of the database. Tracking the locking issues, including deadlocks, blocking and locks. Monitoring disk space of all the servers and freeing up the space as per the requirement.
Database support • April-2013 to November-2014
Magna info tech and HP
Description: Involved in installing SQL Server 2005, 2008, 2008R2 and 2012. Involved installing service pack, cumulative updates, and hot fixes. Creation of user databases and ensuring file group creations and ideally placing files Creating logins and mapping logins to DB and granting permissions at server and object level. Checking the status of backups and troubleshooting the failed backups. Checking the backup reports and ensuring that all the backups are proper