Server Dba
Resume:
PARIKSHIT BAROT
Senior SQL Server DBA / Microsoft Azure Certified
SUMMARY
• An experienced SQL Server DBA with detail oriented, analytical and troubleshooting skills having more than 9+ years of professional experience in the Banking & Insurance Domain.Serverd as the SQL Server Database Administrator with multi-experience with an assortment of Technologies including Microsoft SQL Server, MySQL, SSRS, SISS, Idera, Diagnostic Manager, RedGate tools FogLight, SQL LiteSpeed etc. Implement Security Policies. Defined and permissions for the SQL server environments
SUMMARY
• Expert in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2017/2016/2014/2000/2008 R2 also specialize in MS SQL Server 2019/2016/2014/2012/2008R/2005/ in Production, Test, Development, Replication and Cluster Server Environments.
• Core technical Database Administration experience primarily in SQL Server Database Support projects with SQL Server 2017,2016,2012 & lower versions.
• Experience in MS SQL Server upgrades from MS SQL Server 2000 and from 2000 to MS SQL server 2005 to MS SQL 2008 R2,2012,2014,2016,2019.
• Very good experience in Installation, configuration and maintenance of SQL Server 2016/2014/2012/2008 R2/2008 and lover versions.
• Experience and Expert level knowledge in Always On/SQL Clustering installations.
• Experience in implementation of High Availability/Disaster Recovery concepts(AlwaysOn Database Availability and instance Availability) for SQL Server2012/2014/2016 versions.
• Worked on SQL Server replication and high-availabllity soultions, including SQL Server failover clustering, AlwaysOn, log shipping and database mirroring.
• Experience in configuration, troubleshooting MS SQL failover Cluster(Active/Active & Active/Passive) and AlwaysOn.
• Implemented and Administering AlwaysOn and SQL Clustring
• Built & Migrated SQL Server database servers from On-prim DB environment to AZURE environments.
• Designed and configured Azure Virtual Networks (VNets),subnets, Azure network settings, DNS settings, security policies and routing.
• Deployed and configured Azure Virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.
• Participated in the evaluation and Proof of concept of the Database Server requirements for the Database migration from On-Prim to AZURE environment.
• Working knowledge and technical competence of current and advanced IT technologies and methodologies, AZURE services, Virtualization VMware, Windows, Scripting, Networking and Security.
• Provided high availability for laas VMs and PaaS role instance for other services in the VNet with Azure internal Load Balancer.
• Working knowledge and technical competence of current and advanced IT technologies and methodologies, AZURE services, Virtualization VMware, Windows, Scripting, Networking and Security.
• Experience in the evaluation and Proof of concept of the Database Server requirements for the Database migration from On-Prim to Cloud environments.
• Creating and managing Azure SQL PaaS databases and Managed Instances.
• Configuring Geo-Replication for Azure PaaS databases.
• Creating Azure Storage accounts and blobs to keep SQL backups 2
• Effectively used T-SQL Programming skills and DBCC commands, dynamic management views
(DMV), SQL profiler, Execution Plan, performance monitors SQL server management studio, trace analysis and execution plans as part of troubleshooting and performance tuning.
• Experience in troubleshooting and resolving performance issues related to locking, blocking, Index Optimization, Slow running queries, Database integrity etc.
• Worked on SQL Server consolidation & Upgrade projects from SQL Server 2008 R2 database to SQL Server 2016 instances to facilitate new features to the Applications like Partitioning, In Memory OLTP, Data Compression etc.
• Knowledge of implementation of software development life cycle (SDLC) process and has excellent analytical, programming and problem-solving skills.
• Involved in gathering user requirements, application design, and analysis of hardware requirements to meet business needs Interacted with the users and troubleshooting the problems involved with the development of stored procedure.
• Experience in implementing Disaster Recovery (DR) and High Availability Solutions (HA) using Always ON, Replication, Database Mirroring and Log Shipping features and installing SQL Server Cluster instances.
• Experience in capacity planning, performance tuning, disaster recovery, troubleshooting, backup and restore procedures.
• Expert level skills in High Availability, Disaster Recovery and Replication.
• Expert in installation, upgrade and configuration of 64-bit MS SQL Server databases in clustered
(Active/Active, Active/Passive) and non clustered environments in SQL 2016/2014/2012/,2008 R2.
• Expert in Log shipping/ Database Mirroring with SQL Server 2019/2016/2014/2012/2008 R2.
• Experience in implementing Snapshot and Transactional replication models with SQL Server 2008 R2 and Higher versions.
• Knowledge on Windows PowerShell Scripting to automate Database Administration tasks and to monitor compliance and capacity metrics from SQL server instances.
• Proficiency in SQL Server Database Administration activities like Installation, Configuration Management, Backup & Recovery, Database Security and Query Optimization, Upgrade and Migrations.
• Hands on experience in implementing Database backups strategies for Critical Application to define RTO & RPO strategies.
• Developed Backup and Recovery strategies for PRODUCTION environment.
• T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures, etc.
• Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities and using SQL Server latest DMV's.
• Created complex DTS Packages for Data Migration and Transformation and Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2019/2016/2014/2012/2008 R2.and lover versions.
• Analyzing the problems in the Production environments and developed new procedures and methods for monitoring the problems and send alert messages to take pro-active actions
• SQL Server Database Administrator with an experience of assortment of Technologies including Microsoft SQL Server, SSRS, SSIS, Idera Diagnostic Manager, RedGate tools, SentryOne, SolarWinds DPA and Idera SQLSafe etc.
• Implement the Security Policies and granting permissions to the users. Managing database user accounts and object permissions by defining roles and permissions for the SQL server environments.
• Excellent communication skills, good team player and can work Independently. 3
Technical Skills:
MS SQL Server 2019,2016,2014,2012,2008 R2,2008 and lover versions, Windows Server 2016,2012,2008 R2,2008 2003, Enterprise Manager, Query Analyzer, Oracle 10g/11i, DTS, MS SQL SSRS, SSIS, SQL Profiler, ASP.Net 2.0, SQL, PL/SQL, Visual Studio 2008/2005, T-SQL, Microsoft VISIO, IDERA SQL Diagnostic Manager, SQL Litespeed, IDERA SQLSafe, SentryOne, SolarWinds DPA Good Application Experience in
• Setting up Active/Active and Active/Passive Clustering on SQL Server 64-bit environment.
• Setting up Replication using MS SQL Server 2016,2014,2008 R2 and lower versions.
• SSIS (SQL Server Integration Services),SSRS (SQL Server Reporting Services).
• Setting up Log Shipping (Manual/Wizard) in SQL 2016/2014/ 2008 and lower versions.
• Setting up SQL Server Database Mirroring in SQL Server 2016.
• Database Migration from On Prem to Azure Cloud.
Professional Experience:
Organization: S&T Bank, Indiana, PA
Duration: Feb 2019 – Till Date
Designation: Senior SQL Server DBA
Project: Manage Production, Development, QA and UAT Environment. Gave 24/7 support to all environments, managed servers in HA and DR. Project was to Upgrade SQL Servers from lower version to higher Version and manage HA and DR environments.
Responsibilities:
• Supporting 300 SQL Servers 2017/2016/2014/2012 Database instances in Standalone and SQL Server cluster environment for critical Applications.
• Managed successful migration of critical production with minimum impact to the business from lower version to SQL 2016 version.
• As a Production support DBA responsible for managing production, development and QA environments.
• Managed multiple instances of SQL Server in Virtual and Physical environments with 32 / 64- bit environments
• Managed Production environments and participated in on call 24/7 support
• Did heavy duty Migration / Upgrades from lower version of SQL Server to SQL Server 2016.
• Deployed Azure services using ARM templates.
• Designed VNets and subscriptions to confirm to Azure Network Limits.
• Exposed Virtual machines and cloud services in the VNets to the internet using Azure External Load Balancer.
• Hybrid cloud experience & Virtualization experience (VMWare/Azure).
• Provided high availability for laas VMs and PaaS role instance for other services in the VNet with Azure internal Load Balancer.
• Installed / configured SQL Server in Virtual Environments using VMWare.
• Installed SQL Server 2016 /2014 a on windows servers 2016, applied service packs and security fix for all servers.
• Exclusive Knowledge of Database security including creation of roles/login/user accounts and having good Knowledge of authentication modes, types of roles, how to manage security accounts, grant /revoke permission to access data and how to make a security plan matching your business needs
• Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2005/2008
4
• Implemented Database Mirroring on SQL Server 2016 environments and experience in configured and maintained Log shipping on primary and secondary server with or without witness server on MS SQL 2016/2014.
• Automated daily database refreshes using Power shell from production to staging and on-demand refreshes from production to test environments, involving SQL versions2012/2008.
• Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2017/2016/2014 and lover versions.
• Implemented replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for transactional, merge and snapshot replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Created the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues. Environment: MS SQL Server 2017/2016/2012/2008, Windows Server 2019/2016/2012, VMware, vSphere, Virtualization, Idera Diagnostic Manager, RedGate, SSIS, SSRS, Clustering, Mirroring, Log Shipping, Replication, Azure.
Organization: ProSight Specialty Insurance, Morristown, NJ Duration: Jun-2017-Feb-2019
Designation: Senior SQL Server DBA
Project: Project was to Manage existing Production environment in HA and DR. Also support existing databases and implement new database designs. Give performance solutions for existing databases for maximum throughput.
Responsibilities
• As a Production and development support DBA responsible for maintaining 150 SQL Servers out of which 100 servers are production servers in which 30 were mission critical and 70 were business critical servers, remaining test and development servers.
• Installed SQL Server 2016 on windows 2012 R2 servers, applied service packs and security fix for all servers.
• Implemented Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64-bit environment
• Managed SQL Servers in 32/64-bit Clustered environments
• Implemented Database Mirroring on SQL Server 2008 environments.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Implemented transactional replication for data refresh
• Managed all Publisher, Distributor and Subscriber database environments for the replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Worked extensively with SQL Server DMV's for resolving performance bottlenecks
• Worked extensively on Windows Perfmon for I/O bottlenecks
• Upgraded server from MS SQL Server 2008 to MS SQL Server 2016.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups. 5
• Created extensive reports using SSRS (Tabular, Matrix) Environment: MS SQL Server 2017,2016,2014,2012,2008Windows Server 2016/2012R2/2012, VMware, Vsphere, Virtualization, SSIS, SSRS, Clustering, Mirroring, Log Shipping, Replication. Organization: Big Lots, Columbus, OH
Duration: Dec-2015-Jun-2017
Designation: Senior SQL Server DBA
Project: The role was to support SQL Server Environments and get involved heavily with Off-shore teams in implementing builds and releases.
Responsibilities:
• Managed All Production, Development and QA Environments running MS SQL Server 2005/2000.
• Involved in Migration of Production Database Servers from SQL Server 2000 to SQL Server 2005.
• Involved in Performance Tuning on Production, Staging and Test Servers.
• Worked with Off-shore teams for builds and releases
• Involved with maintenance of ACTIVE/PASSIVE Cluster Environments
• Implemented Database mirroring for High Availability.
• Maintained various databases for Production and Testing using SQL Server 2005.
• Worked with SQL Server Profiler and Perfmon.
• Involved in Monitoring Performance of different production servers.
• Planning the location of data, index, and Transaction log files on the disk.
• Performance tuning, and Optimization of Stored Procedures and Queries.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in creating reports using SQL Server Reporting Services (SSRS) as per the requirement.
• Migrated DTS packages to SSIS packages.
• Involved in Migration of Reporting Servers from SQL Server 2000 to SQL Server 2005.
• Managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies and by creating proxy accounts.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
Environment: MS SQL Server 2016,2014,2012, Windows Server 2016/2012,2008R2, VMware, vSphere, Virtualization, Idera Diagnostic Manager, RedGate, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication.
Organization: Walden Savings Bank, Montgomery, NY
Duration: May 2013-Dec 2015
Designation: SQL Server DBA
Project: Upgrade SQL Server from Lower version to Higher Version and manage and implement changes on SQL Server
6
Responsibilities
• Upgraded most of SQL Server 2000 to SQL Server 2005
• Involved with upgrade of databases from 2000 to 2005 in a Clustered environment.
• Worked on SQL Server 2005 with latest Service Packs.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring for disaster recovery.
• Maintained various databases for Production and Testing using SQL Server 2005.
• Planning the location of data, index, and Transaction log files on the disk.
• Performance tuning, and optimization of procedures and queries.
• Worked with SQL server Profiler.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Experience in creating and executing SQL Server Integration Services (SSIS) packages.
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Used BCP and Bulk Insert utilities and Worked with SQL Server Reporting Services (SSRS).
•
Environment: MS SQL Server 2014,2012, 2008R2/2008, Windows Server 2016/2012,2008R2, VMware, Red Gate, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication Organization: ING Windsor, CT
Duration: Feb-2012-May-2013
Designation: SQL Server DBA
Project: Maintain Database, Backup Restore from Production to DevTest and Cert environment, Create documents and Stored procedures, worked with senior DBAs. Responsibilities
• Involved in various stages of SDLC like Design (Logical & Physical), Development, Implementation and Testing.
• Created Database Maintenance Planner 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. This report gives a detail report to the management on the Performance of the server.
• Fine tuning the Database Settings as well as the Server Settings.
• Involved in creating tables, views, indexes, cursors and stored procedures.
• Involved in creating data models and designing logical and physical models of database.
• Designing and validating the forms according to client requirement by using VB.
• Involved in designing the system models using UML and ER Diagram.
• Developing the applications using ASP and VB.
7
• Involved in designing the database in Access
• Creating, maintaining the users, roles and granting privileges.
• Worked closely with the developers’ team and the end users while the system is being under development phase.
• Gave training sessions to the end users for the new product such as using the product.
• Involved in writing queries and optimizing the performance of the queries. Environment: MS SQL Server 2008 R2/ 2008/2005/2000, Windows Server 2003/2000, T-SQL, Stored Procedure, Performance Tuning
Contact this candidate