Vikram S.
Got Certified in the below. 1.70-462 MSSQLDBA 2012/2014 2.AZ-900 Azure Fundamentals 3.AWS Certified Solution Architect Associate 4.AWS Cloud Practitioner foundational 5.Azure data fundamentals DP-900
- Role
- Associate Team Lead at Tech Mahindra
- Location
- Hyderabad, TG, IN
- LinkedIn followers
- 500 followers
About Vikram S.
PROFESSIONAL SUMMARY MSSQL DBA: • Having 8+ years of experience in Database Administration of very large and complex databases in SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 and SQL Server Expertise in Database Administration on Production Servers with server installation, configuration, Performance tuning and maintenance with outstanding troubleshooting capabilities.• Proficiency and expertise in Database Backup/Recovery, Disaster recovery and planning.• Experience with installation, failover, applying patches, fixing the issues of SQL server cluster. • Migrated SQL Server 2008 databases to SQL Server 2016.• Recovered Database servers from Ransomware attack. • Having experience in maintaining 12TB & 5TB huge database environments.• Configured and maintained Always on availability groups for critical production servers.• Participated in HA DR activities. • Experience in mentoring team members and writing documentation for SOPs for the references.• Ability to interact with clients/application & development teams regarding issues and keeping track of the issues till it gets resolved.• Worked with SOX & HIPPA servers.Azure SQL Cloud: Cloud Services : IaaS, PaaS, DMS, Azure SQL, Azure Managed Instance, elastic pools. • Having experience on Migrating on Premises SQL Databases to SQL Azure using DMA & DMS, Side by side method.• Having experience on installing SQL Servers on AZURE VMs with the latest versions.• Experience in moving on premises SQL Server databases to Azure using Bacpac files and Backup, restore method.• Experience in working with Azure SQL Database Import and Export Service.• Refreshing databases from one server to another server from AZURE portal and using T-SQL Scripts.• Having experience on configuring Virtual machines using Azure portal.• Having experience on configuring elastic pools.• Adding and removing databases from elastic pools in terms of billing control to the clients.• Scaling elastic pools as per the demand.• Troubleshooting performance issues using AZURE monitoring.• Worked on the recovery vaults in azure portal with the existing one.Having Experience in Data-bricks also. Having experience in azure infra.Experience in IBM Sterling Integrator.
Experience
Associate Team Lead
Sep 2021 — Present
Responsibilities:• Migrated 100+ On premise SQL Servers to AZURE Cloud environment.• Installed SQL Server 2016, 2019,2022 versions on AZURE VMs.• Migrating databases from On-premises SQL servers to cloud VMs.• Created run books for easy migration. Created maintenance jobs for the IAAS servers.• Performed backup & restore in azure sql.• Configured SQL Auditing in SQL Db servers to capture the traces of the sessions.• Created the bubble environment for the migration of the databases for testing in isolated environment.• Troubleshooted access issues and performance issues after migration.• Provided Hyper care support after the migration for 14 days.• Monitoring and solving incident tickets, change requests and service calls in 24/7 environment, adhering to SLAs.• Providing 24x7 technical database support for SQL Database systems.• Configuring Azure Services PaaS, IaaS and Migrated databases from on-premises to Azure.• Creating and monitoring Azure SQL Server databases.• Configuring and Maintaining Elastic DB pools, adding the databases and removing the databases in to it.• Configured failover groups to provide high availability for PAAS SQL Server.• Configuring backups and restoring database from recovery vault.• Configuring Server level and database auditing for SQL server.• Deploying Azure IaaS virtual machines (VMs) and Cloud services (PaaS instances) into secure VNets and subnets.• Using the tools AZ copy and storage explorer to migrate the databases from on premise to Cloud VM and PAAS SQL servers.• Flipping of the recovery vaults in azure.• Configuring server level and database level firewalls as per security compliance.• Provided Root cause analysis for the P1 and P2 incidents.
Education
Sri Chaitanya Junior College, Hydernagar
MPC
2005 — 2007
Jawaharlal Nehru Technological University, Hyderabad
Bachelor's degree, Electrical, Electronics and Communications Engineering
2007 — 2011
AVM DEGREE COLLEGE, NAKREKAL
SSC
2004 — 2005
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.