Uploaded File
no photo
Vishnu
Sr. Database Administrator
9 years experience W2 Miramar, FL
Available immediately
Actively seeking
no photo
Vishnu
81
views
Sr. Database Administrator
1 recommendation
1
Recommendation
Average rating
81
Profile views
Database Maintenance DBA MS SharePoint node.js SQL SQL Server Stored Procedure T-SQL Windows Compliance
Remove Note
View Note
Recent Experience
Sr. Database Administrator 10/15 - present
DBA Data Replication SQL Server Windows Server Clustering Stored Procedure Database Maintenance HIPAA SSIS SQL Data Warehousing Database Backups T-SQL Compliance MS SharePoint node.js Windows
Database Administrator 06/14 - 10/15
DBA Data Replication SQL Server Performance Tuning Triggers Data Analysis Database Maintenance Production Support SQL SSIS Stored Procedure Database Backups Database Design T-SQL
Database Administrator 01/14 - 05/14
DBA SQL Server Oracle Data Migration Disaster Recovery SSIS SQL Database Maintenance Clustering Database Backups T-SQL
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.

Top 5 Skills
SkillsProficiencyLast Used
Database Maintenance
2020
DBA
2020
MS SharePoint
2020
node.js
2020
SQL
2020
Education and Certifications
Master's in Information Network and Computer Security
New York Institute of Technology
Bachelor's in Information Technology
Anna University
Preferences
Availability:Immediately
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:Up to 75%
Employment Type:Any
Security Clearance:No clearance
Citizenship:H-1B Visa