Rajesh Kumar D. Email & Phone Number

San Mateo, California, Us

Lead the upgrade of SQL Server 2016 Availability Groups to SQL Server 2019 successfully with minimal downtime.Responsible to manage very critical databases for SurveyMonkey’s business.Built 2016 Windows servers from scratch, configured multi subnet failover clusters to handle Very large databases ranging from 2TB to 50TB.Setup and configure SQL 2016 Distributed Availability groups for High Availability and Disaster RecoveryExpert in managing, troubleshooting different issues regarding Distributed Availability groupsBuilt and Migrate SQL 2016 Databases from on Premises to AWS EC2 and RDS.Work on creation, modification, deletion, and restoration of AWS SQL RDS instance based on requirements.Perform schema refresh from Production to lower environments using Redgate tool.Experienced in handling large deletes (5 Billion records) on a highly transnational databases using different techniques.Optimize database accessibility by distributing workload and processes to eliminate downtime using High availability database clustering.Gather database, disk reports for capacity growth and monitor the availability using SentryOne.Identifying the bad performing queries stored procedures using SentryOne monitoring and Optimize them to perform per business requirement.Install, configure, upgrade, create custom script to monitor SQL Server performance and availability using SentryOne monitoring tool.Document operating procedures, work instructions for operational support.Perform table level fragmentation, update statistics, database consistency checks during off-peak hours to reduce overhead.Install, patch, backup, restore, change service accounts, changing sa passwords, copy logins, sql jobs, schedules, creating operators and perform many other DBA activities using PowerShell module dbatools.io. Developed custom PowerShell scripts to restore 100TB databases seamlessly on 4 replicas (2 nodes in on-prem, 2 nodes in AWS) Provide 24x7 on call Production support.

San Mateo, California, Us

Thousand Oaks, Ca, Us

▪ Built SQL Servers 2014/2016 on various environments and upgraded them to their respective service packs using DMA automation tool.▪ Setup and Configure SQL 2012/2014/2016 Always On for High Availability and Disaster Recovery for both Sync And async modes.▪ Built and Migrate SQL 2014/2016 Databases from on Premises to AWS EC2 and RDS.▪ Work on creation, modification, deletion and restoration of AWS SQL RDS instance based on requirements.▪ Perform Database refresh from higher to lower environments.▪ Develop customized scripts using T-SQL, VB scripts, SSIS, Power Shell to provide various reports to Higher level management.▪ Optimize database accessibility by distributing work load and processes to eliminate downtime using High availability database clustering.▪ Gather database, disk reports for capacity growth and monitor the availability using System Center-Configuration Manager (SCOM).▪ Implement scripts to automate SQL related information for ServiceNow.▪ Document operating procedures, work instructions for operational support.▪ Perform table level fragmentation, update statistics, database consistency checks during off-peak hours to reduce overhead.▪ Restore databases from tape backups and Replication Manager as required▪ Assist project managers in gathering tasks required for database activities.▪ Schedule SQL Agent jobs through Multi Server Administration▪ Provide 24x7 on call Production support.

Thousand Oaks, Ca, Us

▪ Setup and Configure SQL 2012/2014/2016 Always On for High Availability and Disaster Recovery for both Sync and A sync modes.▪ Built SQL Servers 2008 R2/ 2012/2014/2016 on various environments and upgraded them to their respective Service packs.▪ Extensively supported high terabyte Databases for SAP applications.▪ Recovered five High Volume SAP Databases from corruption without any Data loss.▪ Maintains and Supports around 500 SQL Instances and 4000 Databases.▪ Extensively worked and supported 4 Node Windows Cluster for ERP Databases.▪ Worked on DR techniques such as SAN Replication/ Log shipping and DB mirroring.▪ Recommends and Implements SQL tuning opportunities to improve system response and run times.▪ Studied the execution plans of queries and built indexes and updated statistics to improve the performance.▪ Implement and Configure DB appropriate to business requirements.▪ Built and Migrated SQL2012 Databases from on Premises to AWS EC2 and RDS.▪ Implements and Supports database security regulations, policies and guidelines.▪ Involved In Database Design, Indexing.▪ Extensively used Fog light, NimSoft applications/tools to analyze server performance.▪ Participate root cause analysis & reviews when applicable.▪ Installed and Upgraded from SQL server 2005 to SQL server 2008R2 & 2012 on Various Production Servers and upgraded to their respective Service Packs.▪ Installed SQL server 2008 R2 Failover cluster.▪ Implemented and setup database mirroring and log shipping as a part of disaster recovery solution.▪ Migrating Databases from SQL server 2005 to SQL server 2008R2/ 2012.▪ Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics.▪ Worked with Transparent Encryption, table compression, database compression and Merge statements.▪ Involved In Database Design, Normalization, Indexing.

▪ Created Security, Roles and Permissions to users. ▪ SQL Server optimization, DBCCs, debugging scripts and automating DBA tasks.▪ Documented business rules and logic. ▪ Involved in Performance Tuning and Query Optimization.▪ Monitored the event logs and server error logs for troubleshooting. ▪ Identified the bottlenecks and troubleshooting them for optimal performance. ▪ Maintained the Production and Test Database Environment.▪ Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery ▪ Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.▪ Used log shipping for disaster recovery.▪ Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.▪ Created Stored Procedures, Triggers, Views and Functions for the Application.▪ Extensive testing on the Performance of the Stored Procedures.▪ Worked on the failed job reports and made sure they ran successful.▪ Worked on weekly Issues reports which are generated as a part of infrastructure setup.▪ Have experience working on disk space issues. ▪ Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008/2008R2.▪ Migrated all the test environment objects into Production database and maintained high availability of the database. ▪ Created Database Maintenance Plans for the Performance of SQL Server ▪ Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.▪ Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments.▪ Checking Database Health by using DBCC Commands and DMV. ▪ Created alerts and notifications for system errors, insufficient resources, and fatal database errors. ▪ Created Triggers to enforce data and referential integrity.▪ Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.