Nirav Parikh Email & Phone Number

Monroe Township, Nj, Us

Monroe Township, Nj, Us

Rolling Meadows, Il, Us

• Responsible for MS SQL 2022/2019, 2017, 2016, 2012 Installation, Configuration, and Tuning and responsible for 24*7 dedicated support to multiple IT projects and delivery teams.• Responsible for managing team of DBAs and assisted them in planning and day to day DBA activities, acted as a single point of contact for owned IT processes.• Participated in Windows Clustering reassembly projects, Always ON and Replication.• Responsible for managing huge environment with more than 2000 servers, 20000 databases and 6 big divisions with TB sized databases.• Created Central Management server repository using PowerShell to maintain huge database Inventory so that entire team can use it effectively.• Responsible for migrating on-prem SQL to Azure IaaS, and Paas Models by doing detailed analysis and keeping the minimum cost, created documentation for the same.• Worked on configuration of on Rubrik SQL Backup tool by moving traditional database that improved restore times for SQL workloads with an average time-to-recovery reduction of 90 – 95%.• Actively worked on Data centre migration Project and participated in meeting about designing architecture, capacity planning, defining best HA\DR solutions and made actual cutover as smooth as possible.• Proactively monitored database performance, locking and used resource manager for system performance.• Coordinated with project management staff on database development timelines and project scope.• Responsible for normalization, capacity planning, database design using tools such as Erwin, Visio.• Responsible for managing IDM user\AD group permissions on SQL\Azure portal\SSRS.• Responsible for implementation and manages processes to ensure integrity, security, and accessibility of data.• Configured and set up new Azure SQL environment in DEV-QA-UAT-PROD, configured elastic jobs.• Provided documentation and gave demos to team on new features\functionalities etc.

New York City, New York, Us

Burlington, Massachusetts, Us

• Responsible for installation, configuration & tuning of MS SQL 2017/2016, Azure Hyperscale, Managed Instance, SSAS, AAS, Azure Data Factory etc.• Worked on Always ON Environment and configured always on in SQL 2012/2017 version with few replicas which included 1 primary replica and remaining secondary replicas.• Responsible for implementation and manages processes to ensure integrity, security, and accessibility of data.• Migrated on premise SQL environment to Azure SQL VM by doing detailed analysis, provided cost and size estimates, risk analysis and testing etc.• Responsible for scheduling SQL backups to Azure Blob, manage user permissions, create audit and policies etc.• Configured and set up new Azure SQL environment from scratch in DEV-QA-UAT-PROD, configured alerts and monitoring etc.• Responsible for capacity planning, database design using tools such as Erwin, Visio.• Responsible for SSIS packages migration and implemented use of Azure Blob components using Azure feature pack, modified existing logic to support new business requirements, testing and deployment to SSISDB.• Responsible for maintenance of existing Production server DR running under Always on Availability Groups, clustering & Mirroring.• Made lot of performance improvements by tuning and optimizing queries\code for various applications.• Set up and support Azure Analysis Server, Data Factory jobs for generating cubes.• Responsible for writing and tuning complex stored procedures\views etc. as per business requirements.• Worked with TB size databases, created partitions, maintenance of filegroups and indexes etc.• Provided documentation and gave demos to team on new features\functionalities etc.• Proactively monitored database performance, locking and used resource manager for system performance etc.

New York, New York, Us

Responsible for MS SQL 2017,2016,2014, 2012, 2008 R2 Installation, Configuration, Tuning and responsible for 24*7 dedicated support to multiple IT projects and delivery teams.Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements, safeguarding database backups and securing databases.Actively involved in database deployment process life cycle from DEV-QA-UAT-PROD.Involved in configuration and set up of HA DR solution such as clustering with availability groups.Involved in Database & SSIS Packages migration from SQL 2014 to 2016/2017, 2008 to 2012 using side by side upgrade method using data migration assistant.Coordinated and facilitated environment upgrades, software upgrades and patches in a timely manner. Extensive experience in handling very large TB size databases.Experience migrating SQL 2014 to Azure & implementing Azure Data Warehouse.Involved in database design using Visio, made db diagrams and planning of location of data, index, and transaction log files on disk.Implemented contained database, policy-based management, TDE and data compression features.Implemented automated scripts\SSIS packages to monitor expensive\long running queries and other DBA monitoring activities.Monitored system for Locking, Blocking, Deadlocks & various performance related issues using traces, performance counters and DMVs, Catalog Views, DBCC commands etc.Involved in Data Security by creating logins, users & custom database roles and monitored user accounts and maintaining and giving granular permissions to the users\login as needed.Implemented Database Mirroring in SQL 2012\2008 R2 PROD and responsible for maintenance and support.Monitoring SQL server logs, SQL agent job logs, windows, application and system logs and analyzing the logs.Created documentation for Migration process, SSIS Packages, SQL Installation, disaster strategy, Configuration, and change management.

Beverly Hills, California, Us

 Responsible for MS SQL 2008 R2, 2005, SQL Anywhere 12 Installation, Configuration and Tuning.  Responsible for maintenance of Log shipping and Replication and Mirroring. Created Backup\Restore Strategies for Prod-Dev-QA environments. Responsible for Performance tuning of queries & procedures to improve system performance. Actively involved in meeting with all different teams regarding new application feature release to discuss new structure’s efficient design, impact on existing environment, schema changes. Responsible for creating database stored procedures, functions, triggers, Watcom triggers, schema changes, tables, constraints and other database objects using multi-edit for Sybase central/Sql. Maintained various large sized databases in production for SQL 2008 R2. Actively supported DBA team for all new releases with new features implementation by preparing various builds from vanilla database and created new functional databases. Involved in User Database and Transaction log backups & restoration for developers & script deployment. Migrated Data from Access, Oracle and Sybase databases to and from SQL using SSIS/DTS and BCP. Responsible for maintaining security by creating Logins & Users and assigning proper permissions to various groups in both SQL server and Sybase. Monitoring SQL server logs, SQL agent job logs, windows, application and system logs . Actively working with QA, web application and power builder team regarding features testing, bugs & issues and tried to resolve them based on Archtics & Account manager tickets’ priority on JIRA. Presented final demo of design document with entire team to explain them how the new functionally is working and possible enhancements discussion. Extensively used Jetson tool to validate .NET query and verified pipe delimited output of Sps. Set up various Account Manager Websites to test ticket functionality and to troubleshoot existing production bugs.

New York, New York, Us

Chicago, Il, Us

Portland, Oregon, Us

North Brunswick, New Jersey, Us

SQL Developer/DBA.