Summary
Overview
Work History
Education
Skills
Timeline
Generic
Rahul Deval

Rahul Deval

MS SQL SERVER & Azure DBA
Noida

Summary

With 13+ years of experience in the IT industry, possess expertise in SQL DBA, Azure SQL, and Release Management Engineering. Throughout 10-years tenure as a SQL DBA, successfully managed various versions of SQL Server from 2005 to 2017.Skills encompass critical tasks like Database Backups, Restores, High Availability (Always ON), Server Migrations, and Data Recovery Procedures on-premises and on the Azure platform. Moreover, excel at resolving performance issues including Blocking, Fragmentation, and optimizing memory and CPU utilization.

Overview

14
14
years of professional experience

Work History

Analyst - Datacentre Services

COFORGE
05.2021 - Current
  • Azure migrations.
  • Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
  • Improved internal knowledge sharing by developing comprehensive documentation outlining standard operating procedures for various tasks.
  • Increased efficiency by streamlining data analysis processes and implementing automation tools.
  • Application maintenance support for SSIS pkgs.
  • Ensure high levels of performance, availability, sustainability and security

Associate Consultant

Tata Consultancy Services
05.2019 - 05.2021
  • Installation and configuration of various SQL Server version
    SQL Server Migration from 2008 to 2014, Data Cloud AZURE migration.
  • DB scripts deployment automation, Change Management, Managing all environment, PAAS Azure environment
  • On-premise SQL Server to PAAS/IAAS/SAAS Azure migrations.
  • Collaborated closely with cross-functional teams to devise effective strategies and action plans for clients'' businesses.
  • Mentored junior team members, sharing expertise, knowledge, and best practices to enhance overall team performance.

Assistant Lead Engineer

R1RCM
03.2013 - 03.2019
  • Installation and configuration of various SQL Server versions.
  • SQL Server Migration from 2008 to 2014, Data Cloud migration, Configured High Availability environment including replication. DB scripts deployment automation, Replication etc.
  • Change Management – Prepare/Review/Approve/Implement Change Requests related to SQL databases. Incident, Change, Problem and Configuration Management point of contact for the Team.
  • Creating deployment plan for standard releases.
  • Managing all environment like QA, UAT & Production.
  • Design database backup strategy for production, non-prod databases,

configuring database redundancy and recovery operations.

Troubleshooting Performance, and investigating various types of

locking and blocking problems.

Software Developer

Hughes Communication India Ltd.
02.2011 - 02.2013
  • Improved software efficiency by troubleshooting and resolving coding issues.
  • Saved time and resources by identifying and fixing bugs before product deployment.
  • Contributed to a positive team environment through effective communication, problem-solving, and collaboration skills.
  • Involve in designing the databases used in project as well as developed the stored procedures for calculating revenue shares.
  • Include in deployments and manage the UAT environment.

Education

B.Tech - Computer Science

Accurate Institute of Management & Technology
Greater Noida
04.2001 -

12th -

Kendriya Vidyalaya Aonla
Bareilly
04.2001 -

10th -

Kendriya Vidyalaya Aonla
Bareilly, India
04.2001 -

Skills

AlwaysOn Availability Groups

SQL Server Integration Services

Replication Management

SQL Server Reporting Services

SQL Server Analysis Services

T-SQL

Azure - PAAS, IAAS, SAAS

Backup/ Recovery

Performance Tuning

Database maintenance plans, scheduling, alerts

Database Scripts Deployment Automation

PowerShell

Timeline

Analyst - Datacentre Services

COFORGE
05.2021 - Current

Associate Consultant

Tata Consultancy Services
05.2019 - 05.2021

Assistant Lead Engineer

R1RCM
03.2013 - 03.2019

Software Developer

Hughes Communication India Ltd.
02.2011 - 02.2013

B.Tech - Computer Science

Accurate Institute of Management & Technology
04.2001 -

12th -

Kendriya Vidyalaya Aonla
04.2001 -

10th -

Kendriya Vidyalaya Aonla
04.2001 -
Rahul DevalMS SQL SERVER & Azure DBA