Shahin Vahora
Microsoft Sql Server Database Administrator @Capital One
Signup · Get unlimited contacts
WORK HISTORY
Microsoft Sql Server Database Administrator @Capital One
Richmond, VA, US
Worked as a Production DBA with a primary database comprising of SQL Server 2019/2017/2016/2014/2012/2008R2/2008/2005• Performed side by side migration and followed both pre and post checklist for database migration• Migrated SQL Server Databases from SQL Server 2008/2008R2/2012 /2016/2017/2019 on working hours as well as weekends• Installed SQL server 2019/2017/2014/2012 instances on VMware server• Expert in using VMWARE Server• Managed SQL Server Clusters in a SAN environment• Migrated all databases and servers from one data center to another data center• Working knowledge of Double Take SQL migration tool• Resolved all migration-related issues after the databases migration and created database maintenance plan for the performance of SQL Server which covers Database Integrity Checks, Update Statistics, and Re-indexing• Implemented best practices for Database Monitoring, Backups, and Restores• Used Lite speed backup tool for database backups and restores • Used SQL Azure extensively for database needs in various applications• Import data from different data sources to create Power BI reports and dashboards• Created Power BI Visualizations and Dashboards as per the requirements • Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance• Involved in troubleshooting and fine-tuning of databases for their performance and concurrency• Wrote ad-hoc T-SQL queries for data analyzing, research, unit testing, and identifying and resolving bugs• Experience in using SQL Server Profiler and Database Engine Tuning Advisor (DTA)• Planned and Implemented AlwaysON availability groups for 3 replicas• Documented and managed AlwaysON availability groups• • Responsible for designing and implementing cloud-based solutions• Planned and Implemented SQL Server in Microsoft Azure and Cloud-based systems
EDUCATION
Glen Burnie High School
High School / GED
University of Maryland Global Campus
Bachelor's degree
Anne Arundel Community College
Associate's degree
ABOUT SHAHIN VAHORA
USCitizen#Microsoft#Certified#SQL#DBA#USC#Database Over 6+ years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008R2, 2008, 2005 in Production, Development, UAT & Test Environments• Extensive experience in installation, configuration, and maintenance of MS SQL Server 2019, 2017, 2016, 2014, 2012 and 2008R2• Expert in upgrading and migrating from SQL server 2008R2/2008 to SQL server 2019/ 2017/2016/2014• Extensive experience in Data Mapping and Database migration/testing for SQL Server Environments• 5+ years of experience in working with production 24/7 Environment and on-call basis.• Expert working in Virtual Environment using VMWARE for SQL Server• Expert in implementing/installing/configuring and migrating SQL Server to Microsoft Azure-based cloud (IAAS)• Experience in Advanced Excel like Power View, Power BI, Power Pivot, and Excel Data Connection• Has good knowledge in implementing Log Shipping, Data Mirroring Techniques, Replication.• Knowledge in Installing and configuring Cluster SQL Servers in Active/Passive and Active/Active environments.• Experience in Software Development Life Cycle (SDLC) and configuring Alerts using SQL Mail.• 5+ Years’ experience with T-SQL in developing Database Objects, Triggers, stored procedures, Functions.• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles, and granting privileges• Excellent communication skills and ability to develop solutions for client needs using agile methodologies.• Manage the SQL Servers using PowerShell• Experienced in working in OLTP and OLAP environment• Experienced in working of Client/Server and Web-based applications using Visual Basic/Visual Studio/ASP.NET• Experienced in Database Backup, Recovery, and Disaster Recovery procedures.• Extensive experience in Maintaining High Availability using Failover Clustering and AlwaysON availability Groups• Expert skills in VMware and Virtual environments• 5+ Years’ experience in SSIS, SSRS, and SSAS• 5+ Years’ experience in HA (High Availability) and DR (Disaster Recovery)• 5+ Years’ experience in Clustering, Mirroring, and Log Shipping• 5+ Years’ experience in Performance Tuning SQL Server
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.