Summary
Overview
Work History
Education
Skills
Timeline
Generic
Kolli Srinivasa Rao

Kolli Srinivasa Rao

Summary

Working as a MS SQL SERVER DBA with 10 years of experience. Currently looking for new opportunities in the same technology to develop myself and at the same time help the organization with skills. MS-SQL Server2019,2016, 2012, 2008 R2, 2008 and 2005 Database Administration.

Having good knowledge on Azure IAAS, PAAS and MI, Azure migration, Performance tuning, Always-on and SSIS, SSRS and SSAS admin

Overview

9
9
years of professional experience

Work History

Senior Associate

LTI MINDTREE
03.2022 - Current

Currently working as SQL Database Technical Lead in LTIMindtree Limited From Aug 2022 to currently.

Client: Carlyle Group Inc, USA

Role: SQL Database administrator

Environment: MS SQL Server 2008R2\2012\2014\2016\2019 SSIS, SSRS, SSAS, Performance Monitor, Clustering, SQL Agent, SQL Profiler, Database Tuning Advisor, Veritas NetBackup, PowerShell and Always-On

Responsibilities: Design, implement and administer databases on MS SQL Server 2014/2016/2019 platforms for OLTP

  • Migration of SQL Server Instances from 2008 R2 to,2014,2016,2019
  • Experienced in providing analysis on High availability/Disaster recovery & scalability
  • Troubleshooting and Query Tuning complex SQL Code, Stored Procedures, Triggers, Views etc., by analyzing wait stats, Execution plan & updating statistics
  • Applying Patches and Hot fixes
  • 16x7 Production support and On Call duties
  • Troubleshooting log file space issues, temp Db contention
  • Used SQL Server Profiler to monitor and record database activities of users and applications

Senior Consultant

Cognizant technologies
02.2020 - 01.2022

Client:JohnHancock

Role: SQL Database administrator Domain: Health Insurance.

Consulatant

Infosys Ltd
01.2019 - 02.2020

Client: Exxon Mobil Brazil

Role: SQL Database administrator Domain: Fuel and energy.

SQL Database Administrator

Mashreq Global Service
07.2016 - 10.2019

Client: Mashreq Bank, UAE

Role: SQL Database administrator Domain: Banking

SQL Database Admin

IDC Consultancy services
03.2015 - 03.2016

Client: Mashreq Bank, UAE

Role: SQL Database administrator Domain: Banking

Education

Master of business administration -

Nagarjuna University

Skills

    MS SQL Server Database Admin

    Azure IAAS,Azure PAAS and Azure MI

    Azure Migration

    Always-on

    SSIS,SSRS and SSAS admin

    Performance tuning

    Knowledge on using the Powershell cmdlets

    Able to modify the powershell scripts as per requirement

Timeline

Senior Associate

LTI MINDTREE
03.2022 - Current

Senior Consultant

Cognizant technologies
02.2020 - 01.2022

Consulatant

Infosys Ltd
01.2019 - 02.2020

SQL Database Administrator

Mashreq Global Service
07.2016 - 10.2019

SQL Database Admin

IDC Consultancy services
03.2015 - 03.2016

Master of business administration -

Nagarjuna University

Similar Profiles

CREATE PROFILE
Kolli Srinivasa Rao