Summary
Overview
Work History
Education
Skills
Timeline
Hi, I’m

Kola Rakesh

Hyderabad
Kola Rakesh

Summary

Detail-oriented SQL Server Database Administrator with expertise in database management and recovery strategies. Skilled in cloud solutions and problem-solving, ensuring data integrity and availability.

Overview

8
years of professional experience

Work History

Genpact
Hyderabad

SQL Server Database Administrator
07.2022 - Current

Job overview

· Worked on Microsoft Azure IaaS, PaaS SQL DB, Managed instance and ADF.

· Created VMs, drives configuration and installation of SQL services. Installed 2017 SQL version also. This is on IaaS server.

· Created SQL storage account and created container in blob storage.

· Created Recovery vaults for production and non-production to take backup of databases.

· Configured AZ backups from on-premises server to azure (IaaS SQL databases) to recovery vaults and created alerts to know the backup status whether they are healthy or not.

· Created backup policies like full every week Friday, diff backup every 6 hours and Log backup every 15 minutes.

· We are restoring these AZ backups randomly every month on on-premises server for the SOX evidence. Whether backups are valid or not and we could restore from AZ backups or not.

· If backups are failed, we will re-run those which status is showing not healthy.

· If we dropped any database on on-premises server, we will go and delete backup configuration for that particular database.

· As per the disk space issue we are increasing disk space on IaaS server.

· Created users and groups on Azure active directory. Provisioning access as per the request and optimizing privileges.

· Worked on SQL DB and elastic pools and much hands-on PaaS Managed instance.

· Created SQL DB for single application on Azure.

· Hands on PaaS migration. Migrated around 450 databases from IaaS to PaaS MI (2017 version).

· Created 4 Managed instances.

· Created databases on PaaS MI and restored databases one MI to other MI within same region.

· Restored databases from PaaS MI to IaaS SQL servers.

· Provided access on PaaS Mi instance for the users.

· Worked on DB encryption on PaaS MI and instance level.

REALPAGE
Hyderabad

Invoice Processor
08.2019 - 06.2022

Job overview

  • Processed and verified incoming invoices for accuracy and completeness.
  • Coordinated with vendors to resolve discrepancies and billing issues.
  • Maintained organized records of invoices and payment documentation.
  • Reviewed purchase orders to ensure alignment with invoiced amounts.
  • Utilized accounting software to enter and track invoice data efficiently.

GLOBALLOGIC
Hyderabad

Associate Analyst
01.2018 - 08.2019

Job overview

  • Analyzed data trends to support project development and decision-making processes.
  • Collaborated with cross-functional teams to gather requirements for software solutions.
  • Developed reports and presentations to communicate findings to stakeholders effectively.

Education

NALLA NARSIMHA REDDY COLLEGE OF ENGINEERING
Hyderabad

Bachelor of Science from Computer Science
07-2017

University Overview

Skills

  • SQL database management
  • Database backup strategies
  • Database migration techniques
  • Database performance tuning
  • Problem solving
  • Data analysis and reporting
  • Cross-functional collaboration
  • Azure cloud services
  • Data encryption practices

Timeline

SQL Server Database Administrator
Genpact
07.2022 - Current
Invoice Processor
REALPAGE
08.2019 - 06.2022
Associate Analyst
GLOBALLOGIC
01.2018 - 08.2019
NALLA NARSIMHA REDDY COLLEGE OF ENGINEERING
Bachelor of Science from Computer Science
Kola Rakesh