add photo
Vishnu
vishvijv@gmail.com
954-952-4700
3020 SW 119th Ave
Miramar, FL 33028
Sr. Database Administrator
13 years experience W2
1
Recommendation
Average rating
331
Profile views
Summary

Technical Summary:

  • 6+ Year Experience in Database Administration, Design, Development and Support of MS SQL Server 2016/2014/ 2012/ 2008 R2/ 2008/ 2005 in Production, Test, Development Servers of Very Large, Multi-Terabyte and Complex Environments.
  • Expertise in Installing, Configuring and Troubleshooting AlwaysOn Availability Groups.
  • Extensively worked on Active-Active and Active-Passive Clustering.
  • Experience in implementing Merge replication, Snapshot and Transactional replication models.
  • Implemented Database Mirroring and Configured Database Mirroring in both High Safety and High Performance.
  • Implemented both In-Place and Side by Side Migrations of SQL Server Environments.
  • Experience in supporting high transaction OLTP Databases in Production Environments.
  • Experience in Setting up Log-Shipping.
  • Expertise in Capacity Planning, MS SQL Server installation, configuration and installation of Service Packs, Hotfixes for SQL Server.
  • Expertise in Creating and Managing User Permissions, Logins and Configuring Security Per Organizational Standards.
  • Experience in Installation, Configuration and Maintenance of SQL Servers in BIZTalk, MicroStrategy and SharePoint Server Environments.
  • Extensive Knowledge of SOX Compliant and HIPAA Compliant Database Environments and Experience in Working with Change Management Process.
  • Expertise of Various Backups, Recovery Methods of SQL Server.
  • Hands on Experience in Using Third Party Tools such as Idera SQL Diagnostic Manager, New Relic, Apex SQLDIFF.
  • Expert Knowledge in Usage of Open Source Maintenance and Support Solutions Such as Ola Hallengren, Brent Ozar, Adam Machnic’s Who_is_Active and Active in Various SQL Server Communities and PASS.
  • Extensive Knowledge in Performance Tuning and Analyzing Locks and Deadlocks in SQL Server
  • Hands on Experience in Using SQL Server Native Tools and Options Such as Extended Events, SQL Server Profiler, Activity Monitor for Performance Analysis and Tuning.
  • Expertise in Analyzing Index Usage, Fragmentation and Reorganize/Rebuild Indexes, Update Statistics for Better Performance.
  • Expertise in Analysis of Query Execution Plans for Low Cost Execution Options and Providing Suggestions on the same.
  • Experience in Database Consistency Checks using DBCC Utilities.
  • Implemented Change Data Capture (CDC) in SQL Server.
  • Extensive Knowledge of Installing SSIS, SSRS and SSAS in Various SQL Server Environments.
  • Expertise in Installation and Configuration of Multiple Instances of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
  • Extensive Knowledge of Development, Troubleshooting and Deployment of SSIS Packages.
  • Created Various Useful Reports using SSRS regarding Database Administration.
  • Knowledge of Development and Deployment of OLAP Cubes in SSAS.
  • Experience in Developing Basic PowerShell Scripts, VB Scripts for Automation.
  • Expertise in Disaster recovery planning and participated in disaster recovery drills.
  • Highly Committed, Motivated Individual and a team player with Strong Ability.
  • 24/7 Production Support Experience.

Experience
Education
Master's in Information Network and Computer Security
New York Institute of Technology
Bachelor's in Information Technology
Anna University
Skills
ETL
2021
6
MicroStrategy
2021
6
Database Maintenance
2021
5
DBA
2021
5
MS SharePoint
2021
5
node.js
2021
5
SQL
2021
5
SQL Server
2021
5
Stored Procedure
2021
5
T-SQL
2021
5
Windows
2021
5
Compliance
2021
4
Data Replication
2021
3
Performance Tuning
2015
3
SSIS
2021
3
Clustering
2021
2
Database Design
2015
2
OPTIM
2015
2
Triggers
2015
2
Application Development
2012
1
Data Analysis
2015
1
Data Modeling
2012
1
Data Warehousing
2021
1
Database Backups
2021
1
Erwin Data Modler
2012
1
HIPAA
2021
1
Production Support
2015
1
Windows Server
2021
1
APEX
0
1
Data Migration
2014
1
Data Profiling
2013
1
Disaster Recovery
2014
1
OLTP
0
1
Oracle
2014
1
PowerShell
0
1
Project Management
2013
1
SOX
0
1
Visual Basic
0
1