Kolli Srinivasa Rao
MS SQL Server Database Administrator
Gundalapadu
Summary
Working as a MS SQL SERVER DBA with 9 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
2
2
years of post-secondary education
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 Domain: Financial Services.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, Always-On and Azure admin IAAS, PAAS and SQLMI 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 Migrating on-premises SQL Server Database to IAAS and SQLMI 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
06.2003 - 05.2005
Skills
MS SQL Server Database Admin
undefinedHome
Gundalapadu, Guntur, Guntur, 522549, India
Personal Information
- Date of Birth: 12/04/1982
- Gender: Male
- Nationality: Indian
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
06.2003 - 05.2005