Uploaded File
add photo
Vishnu
vishvijv@gmail.com
954-952-4700
3020 SW 119th Ave
Miramar, FL 33028
Sr. Database Administrator
11 years experience W2
1
Recommendation
Average rating
144
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
Sr. Database Administrator
Information Technology
Oct 2015 - present

Responsibilities:

  • Created and maintained various databases on Production, Staging and development environments with SQL Server 2016/2014/ 2012/2008 R2/ 2008.
  • Migrated Various SQL Servers from SQL Server 2012 to SQL Server 2016 and Some Legacy Servers to SQL Server 2012.
  • Created, Configured and Maintained AlwaysOn AG with 3 Node as [A (Primary), B (Secondary Sync Commit) and C (Secondary ASync Commit).
  • Created and Maintained Windows Server Failover Clustering.
  • Implemented Log Shipping and Transactional Replication.
  • Implemented Ola Hallengren’s SQL Server Backup, Integrity Check, and Index and Statistics Maintenance
  • Created database Maintenance Plans, SQL Server Jobs and deployed custom maintenance scripts to schedule regular DBA tasks for enhancing the performance of SQL Server including Database Integrity checks and Re-Indexing, Updating Statistics, Full, Differential and Transactional Log Backups and DBCC Cleanup.
  • Created and Managed User Permissions, Logins and Configuring Security Per Organizational Standards.
  • Closely worked with the Data Warehouse Team in suggestions about the ETL Processes and Deployed Various SSIS Packages for Various ETL Processes.
  • Deployed Various RDL’s across our Report Servers and Maintained Various Report Servers, Configured Data Sources and Configured the Security on the Report Servers.
  • Involved in Deployment of various Jobs, Stored Procedures, and T-SQL Queries across Development, Staging, Pre-Production and Production Environments.
  • Experience in Installation, Configuration and Maintenance of SQL Servers in BIZTalk, MicroStrategy and SharePoint Server Environments.
  • Implemented Change Data Capture (CDC) in SQL Server.
  • Involved in Migration of Various SQL Servers to New Domain.
  • Involved in the Migration of SharePoint Database Server to a new domain.
  • Analyzed and Created Various Reports on Server Performance and Preventive measures to ensure High Availability.
  • Created Various Reports on SQL Server Job History for Various Teams.
  • Provided Audit Reports for HIPPA Compliance using ApexAudit.
  • Involved in Tuning of Various Stored Procedures and SSIS Packages by providing valuable performance related reports and suggestions to the development team.
  • Provided 24*7 Production Support for the database and application issues.
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 ETL MicroStrategy
Remove Skill
References
Average Rating

1 recommendation
Database Administrator
Information Technology
Jun 2014 - Oct 2015

Responsibilities:

  • Created and maintained various databases on Production, Development and Test environments using SQL Server 2012/2008 R2/2008.
  • Migrated MS SQL Server 2008 to MS SQL Server 2012.
  • Implemented Database Mirroring and Configured Database Mirroring in both High Safety and High Performance.
  • Installed necessary Service Packs and Patches for SQL server 2012/2008 R2/ 2008.
  • Configured replication methods like snapshot, transactional and merge replications.
  • Performance Tuning with regards to Indexing on the Databases by Re-Build and Re-Organized Indexes.
  • Monitoring and scheduled jobs on production and staging environment.
  • Implemented Ola Hallengren’s SQL Server Backup, Integrity Check, and Index and Statistics Maintenance
  • Created database Maintenance Plans, SQL Server Jobs and deployed custom maintenance scripts to schedule regular DBA tasks for enhancing the performance of SQL Server including Database Integrity checks and Re-Indexing, Updating Statistics, Full, Differential and Transactional Log Backups and DBCC Cleanup.
  • Created and Managed User Permissions, Logins and Configuring Security Per Organizational Standards.
  • Used the Execution Plan to improve the optimization of the T-SQL code.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
  • Expert in Performance Tuning of the Stored Procedures.
  • Developed, Optimized complex stored procedures, triggers, views to handle complex business rules, history data and audit analysis.
  • Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
  • Provided 24 x 7 Production support for the database and application issues.
  • Handled user's permissions and Group Policy Management on Production, Development, Test Servers and Managed security on them.
  • Resolving performance related issues to Blocking, Deadlocks and long running queries
  • Scheduling SSIS packages by creating the corresponding job tasks for updating the synchronizing of data between two databases.
  • Involved in Source Data Analysis, and designing mappings for data extraction.
  • Responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
DBA Data Replication SQL Server Performance Tuning Triggers Data Analysis Database Maintenance Production Support SQL SSIS Stored Procedure Database Backups Database Design T-SQL
Remove Skill
Database Administrator
Information Technology
Jan 2014 - May 2014
New York City, NY

Responsibilities:

  • Created and maintained various databases on Production and development environments using SQL Server 2012/2008 R2.
  • Installed necessary Service Packs for SQL server 2012/2008 R2.
  • As a Part of Disaster Recovery Implemented Active-Active and Active-Passive Clustering.
  • Tuned databases for better performance.
  • Monitored and configured the complete environment for resource utilizations and to avoid any bottlenecks.
  • Installed and configured SSRS.
  • Created Various SQL Server Extended Event Sessions as a part of Monitoring SQL Servers.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
  • Implemented Ola Hallengren’s SQL Server Backup, Integrity Check, and Index and Statistics Maintenance
  • Created database Maintenance Plans, SQL Server Jobs and deployed custom maintenance scripts to schedule regular DBA tasks for enhancing the performance of SQL Server including Database Integrity checks and Re-Indexing, Updating Statistics, Full, Differential and Transactional Log Backups and DBCC Cleanup.
  • Created and Managed User Permissions, Logins and Configuring Security Per Organizational Standards.
  • Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
  • Created various SSIS packages based upon the requirement.
  • Created various reports using SSRS.
  • Analyzed the Performance of a Cube by partitioning it and creating Perspective Cubes.
  • Scripted the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
  • Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
  • Data migration using DTS services across different databases like Oracle, MS access & flat files.
  • Analyzed various backup compression tools available and made the recommendations.
DBA SQL Server Oracle Data Migration Disaster Recovery SSIS SQL Database Maintenance Clustering Database Backups T-SQL
Remove Skill
Database Administrator/Developer
Information Technology
May 2013 - Dec 2013
New York City, NY

Responsibilities:

  • Created and maintained various Databases of which contains information of Tutors and Student Information, Schedules, Practice Tests using SQL Server 2012/2008 R2
  • Actively participated in gathering of User Requirement and System Specification.
  • Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database.
  • Created reports from database onto excel spread sheet using DTS.
  • Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
  • Checks, Update Database Statistics, Re-indexing and Created Users and Roles, and managed security and permission of database.
  • Completed High Number of service requests from the internal ticketing system.
  • Oversaw the daily performance and maintenance of 10 servers and over 15 SQL Server instances.
  • Performed system imaging using Norton Ghost 12.0.
  • Analyzed long running slow queries and tuned same to optimize system performance.
  • Set up SQL Server configuration settings.
  • Monitored database servers using Idera SQL Diagnostic Manager.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Data Analysis and Data Profiling as required
  • Rebuilding the indexes at regular intervals for better performance
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Migrated SQL Server 2005 data bases into SQL Server 2008.

SQL Server Data Profiling Database Maintenance DBA Data Analysis Disaster Recovery SQL Database Backups Database Design Project Management T-SQL Triggers
Remove Skill
Database Administrator/Developer
Information Technology
Jan 2011 - Dec 2012

Responsibilities:

  • Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
  • Planned and modified the permission issues in the server.
  • Designed a report on the monitoring of SQL Server Performance.
  • Fine-tuned the Database Settings as well as the Server Settings.
  • Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed and Maintained SQL Script for creation of Database Objects.
  • Creating, maintaining the users, roles and granting privileges.
  • Logical and Physical Data Modeling using AllFusion ERWIN.
  • Performed Database backups (operating system, flat file backups & export/import).
  • Maintained various databases for Production and Testing using SQL Server 2008.
  • Planning the location of data, index and Transaction log files on the disk.
  • Performance tuning and optimization of procedures and queries.
  • Gathered functional requirements and Business requirements and written the technical specifications.
  • Created database objects like tables, indexed views, indexes, stored-procedures, triggers and cursors using DDL, DML statements.
  • Developed stored procedures and views for managing efficient data retrieval and application development.
  • Wrote stored procedures for querying the data dynamically by defining parameters.
  • Extensively used reporting tool (Web focus) to create reports as per user requirements.
  • Created reports out of the views and developed OLAP cubes.
  • Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
  • Used DTS Packages for data import and export data from SQL Server to MS Access, Flat files and EXCEL files.
  • Performed some DBA Tasks like checking the jobs, data consistency and troubleshooting the issues.
  • Worked closely with developers, end users and Administrator in designing and developing database.
  • Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
  • Responsible for enhancements and Maintenance of the product.
  • Optimized SQL statements for customer summary reports.
DBA Data Modeling SQL Server Erwin Data Modler Performance Tuning Database Backups Database Maintenance SQL Stored Procedure Database Design Disaster Recovery Triggers Application Development
Remove Skill
Edit Skills
Non-cloudteam Skill
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
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